
At first glance, it is easy to make MySQL backups. Most immediately recall the mysqldump utility, the more advanced administrators of the file system snapshots and MySQL Enterprise Backup (MEB) hot copy tools, Percona XtraBackup.
All of these tools are able to maintain integrity, but not for free.
You have to pay with locks, including global, long transactions, increased load on the MySQL server, and even its complete stop.
For a working server serving millions of connections, all of the above is hardly acceptable.
On the
master class , based on real-life experience with MySQL support clients, I’ll tell you how to back up:
- in conditions of insufficient disk space
- inability to allocate sufficient maintenance window for backup
- how to perform backup in real time, without slowing down the application
- what to do with damaged data
Do not miss the exclusive master class on June 15 (VSK)!