Backups need to be tested to avoid epic incidents like the one occurred to GitLab in 2017. But how should they be tested, and what should we monitor exactly?
Let’s use Percona User Statistics to analyse our most used tables, and to look for problems where they mostly matter.
How to define realistic speed and availability goals. Understand what a SLO (service-level objective) is, and the cost of violating it.
How to add ProxySQL to our MySQL/MariaDB environment, and have it monitored by PMM. Docker allows to do this in minutes, for testing purposes.
Testing PMM as a monitoring solution for MySQL and MariaDB involves installing a lot of stuff. Let’s see how to so this in minutes with Docker.