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