Am 16.10.2012 21:55, schrieb Michael Dykman:
> I'm confused: in the first sentence, you say snapshots are bad (which
> directly contradicts the official MySQL documentation), and in the
> second sentence you say rsync is good.  Why would an rsync of a file
> system snapshot not be good enough?  By the way: I forgot to mention
> that I also did create a snapshot when the MySQL server on db-01 was
> actually shut down, and got the same sort of results.

i said nothing about rsync a snapshot!

* rsync HOT while runnining master
* stop master
* rsync cold to get the copy synchron

the two rsync runs because it minimizes downtime nearly to zero
i do not trust any FS snapshot in this context
i do not trust any documentation in this context

fact is if you stop the master there are REALLY no open files
and that is why i do two rsync runs, the sconed one only have
to care about diffs for changed files between both ones

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to