|
|
|
|
|
|
by zorlem
4890 days ago
|
|
|
XtraBackup has its limitations wrt to locking when you've got a mix between InnoDB and MyISAM tables. The problem with taking a backup from a MySQL slave is that the data is not guaranteed to be identical to the master, thanks to the subtle problems and peculiarities of the MySQL master-slave replication (some of them are described in the OP). For precisely this reason I install an automated job that periodically checksums the tables and sends the results to the DBA role. |
|
|