Testing backups is often considered too expensive. But it is not, if the tests are adequately designed.
Vettabase Blog
Read our expert blog with articles on MariaDB, MySQL, PostgreSQL, Cassandra and related tools & technologies.
MariaDB supports regular expressions, but regexps won't use indexes. Here's a workaround that can be used in some cases.
Databases and technical debts: here's a list of requirements your database infrastructure should have.
Semantics and use cases of the WITH TIES syntax.
How to remote duplicate values from a table to add a UNIQUE index, in MariaDB.
Periodical maintenance windows can be healthy both for your team and your infrastructure. Business won't be damaged.
Before introducing a new database technology in your organisation, consider the drawbacks.
The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all ...
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.