Skip to content

Vettabase

Watch your data from the top of a mountain. We take care of the machinery.

Menu

Primary menu

  • Services
    • Database Automation
    • Health Checks
      • MariaDB
      • MySQL
      • Cassandra
      • PostgreSQL
    • Monthly Time
    • Training
      • MariaDB
      • MySQL
      • Analysts Training
    • Upgrades and Migrations
      • Database Upgrades
      • Migration from CentOS
  • Articles
    • Vettabase
    • Automation
    • MariaDB
    • MySQL
    • PostgreSQL
  • Resources
    • Ebooks
    • VettaArchive
  • About
    • Testimonials
    • On the Web
    • Careers
    • Contact Us

Monitoring that AUTO_INCREMENT values won’t reach the limit

Posted on 13 November 2020 by Federico Razzoli — 2 Comments ↓

AUTO_INCREMENT primary keys are useful, because they save usthe trouble to generate a unique value for every row, delegating this task to the database. But when we reach the limit we need to take some action, or we won’t be able to insert more rows. Continue reading Monitoring that AUTO_INCREMENT values won’t reach the limit→

Posted inMariaDB, MySQL | 2 Replies

5 benefits of Infrastructure As Code

Posted on 10 November 2020 by Federico Razzoli — 2 Comments ↓

Automating deployments with the Architecture As Code paradigm has several benefits. Let’s see some of them. Continue reading 5 benefits of Infrastructure As Code→

Posted inDatabase Automation | 2 Replies

MySQL/MariaDB: use SQL properly to run less queries

Posted on 29 October 2020 by Federico Razzoli — No Comments ↓

Reducing the number of queries is important with any DBMS. There are two reasons for this: reducing the latency of applications; and reducing the workload for the database servers. Continue reading MySQL/MariaDB: use SQL properly to run less queries→

Posted inMariaDB, MySQL, SQL Language | Leave a reply

The risks of MySQL release policy

Posted on 27 October 2020 by Federico Razzoli — No Comments ↓

MySQL 8.0 and 5.7 follow a new release policy that exposes users to important risks. They broke compatibility with Xtrabackup (again). Continue reading The risks of MySQL release policy→

Posted inMariaDB, MySQL | Leave a reply

When to use NULLable columns in relational databases

Posted on 15 October 2020 by Federico Razzoli — No Comments ↓

SQL columns can be NULL or NOT NULL. Let’s see what are the good and bad reasons to declare NULL columns. Continue reading When to use NULLable columns in relational databases→

Posted inSQL Language | Taggednull | Leave a reply

READ ONLY transactions in MariaDB and MySQL

Posted on 8 October 2020 by Federico Razzoli — No Comments ↓

Transactions can be read only. This article explains what read only transactions are and why we should use them when appropriate. Continue reading READ ONLY transactions in MariaDB and MySQL→

Posted inMariaDB InnoDB, MySQL InnoDB | TaggedMariaDB-10.0, MySQL-5.6 | Leave a reply

Using CONNECT to access remote MariaDB or MySQL tables

Posted on 23 September 2020 by Federico Razzoli — 2 Comments ↓

This article discusses how to access data from a remote table using the CONNECT storage engine, in MariaDB. Continue reading Using CONNECT to access remote MariaDB or MySQL tables→

Posted inMariaDB Storage Engines | TaggedMariaDB-10.0 | 2 Replies

A MariaDB Server Fest 2020 review

Posted on 21 September 2020 by Federico Razzoli — No Comments ↓

MariaDB Server Fest 2020 was a great online event for the MariaDB community. This is a review from Vettabase. Continue reading A MariaDB Server Fest 2020 review→

Posted inMariaDB, Vettabase | Leave a reply

The most dangerous SQL statement

Posted on 11 September 2020 by Federico Razzoli — No Comments ↓

Vettabase asked the community what is the most dangerous SQL statment. Let’s think a bit about it! Continue reading The most dangerous SQL statement→

Posted inDatabases | Leave a reply

Dropping database objects in a safe way

Posted on 28 August 2020 by Federico Razzoli — 3 Comments ↓

Running DROP statements in production is always dangerous. But there are some measures we can take to make them safer. Continue reading Dropping database objects in a safe way→

Posted inMariaDB, MySQL | 3 Replies

Post navigation

← Older posts
Newer posts →

Primary Sidebar Widget Area


en_GB English

en_GB English


it_IT Italian

Vettabase Ltd logo

Content License

Creative Commons License
Except where otherwise noted, the content on this site is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Recent Posts

  • Basic practices for optimizing read and write performance in PostgreSQL
  • Vettabase is now a MariaDB Foundation Technology Partner
  • Sizing Aria Pagecache
  • How to skip an Ansible task by default
  • Can we shrink InnoDB Buffer Pool?

Categories

  • Amazon Redshift
  • Database Automation
  • Databases
  • MariaDB
  • MariaDB InnoDB
  • MariaDB Storage Engines
  • MySQL
  • MySQL InnoDB
  • PostgreSQL
  • SQL Language
  • Stored Procedures
  • Systems
  • Vettabase

Services

Check how Vettabase can maximise the efficiency and reliability of your database infrastructure!

  • Health Checks
  • Monthly Time
  • Training
  • Facebook
  • Twitter
  • Linkedin
  • RSS Feed
  • Instagram
  • Email
Copyright © 2021 Vettabase. All Rights Reserved.
Theme: Catch Box by Catch Themes
Scroll Up
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking "Accept", you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Policy dei Cookie

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

SAVE & ACCEPT