Transactions can be read only. This article explains what read only transactions are and why we should use them when appropriate.
MySQL
Running DROP statements in production is always dangerous. But there are some measures we can take to make them safer.
In MariaDB and MySQL, all tables should have a primary key – especially InnoDB tables. Here's why.
Updating triggers in production without causing a service disruption
It is possible to prevent some users from seeing a set of rows in a certain table.
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.