> load data from master never worked for innodb.
And the suggested mysqldump command does not work for MyISAM.
Either way, the suggestion is a non-starter. I could "flush tables
with read lock" and then do a mysqldump but again that would take
hours and all the databases would be read-only during the whole
operation, and even the read-only performance would be poor. I'd
really prefer not to do that.
I'll say again that the MySQL documentation specifically says that ZFS
snapshots are a good way to make backups of MySQL databases. Is the
documentation incorrect? Or perhaps does that also only work for
MyISAM tables? If so, that ought to be called out more clearly in the
documentation.
--
Tim Gustafson
tjg@stripped
831-459-5354
Baskin Engineering, Room 313A

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.