MySQL supports replication filters and binlog filters. These features are powerful, but dangerous. Here you’ll find out the risks, and how to mitigate them.
Read moreDropping useless MySQL indexes
How to find useless indexes and get rid of them to improve your database performance.
Read moreSetting performance and availability objectives (SLO)
How to define realistic speed and availability goals. Understand what a SLO (service-level objective) is, and the cost of violating it.
Read moreDropping database objects in a safe way
Whenever I worked as a DBA, I was reasonably scared by 💧DROP commands. Don’t get me wrong: despite this, I badly wanted to drop obsolete tables. After that, I could more easily ask developers to fix bad practices, like tables …
Read moreThe perils of ALTER TABLE in MySQL/MariaDB
ALTER TABLE is often necessary, but it can be risky in a production environment for many reasons. Let’s discuss the problems that one has to take into account.
Read more