Database Administration is a tough, often ungrateful job. Especially if you run a 24/7 business-critical MySQL or MariaDB deployment.
MySQL has proven to be a remarkably solid database which supports billions of dollars in revenue. On some level this very solidity creates a false sense of security. There are many things that can wrong at any given time, whether that is a change to your app, a bug in the database, hardware failure or just simply running out of disk space.
Percona recently conducted a poll: “What keeps you up at night?”
Not surprisingly, “Downtime/HA” is very high on the list.
While there are many challenging issues and tasks that a DBA must deal …[Read more]