MySQL Database Replication with Rysnc

[MikeH30]

I am attempting to mirror MySQL databases from a master server to a secondary server. I followed this tutorial (How To Set Up Database Replication In MySQL | HowtoForge - Linux Howtos and Tutorials) but was not successful.

So I was wondering if this idea would work:

Is it possible to achieve MySQL database replication by mirroring the directory that MySQL resides on the master server to the MySQL directory on the secondary server with rysnc?

-Mike

[HROAdmin26]

No. There are multiple levels of caching involved with how DB's work. Rsync'ing the filesystem data from one machine to another does not guarantee the DB data is flushed/consistent.

You can A) stop MySQL, run rsync, and then start MySQL again or B) run a MySQL DB dump to disk and rsync/copy/FTP/whatever that dump to another server.

Google found a much newer replication tutorial made by the MySQL Dev's from 2008 dealing with MySQL 5.1.

[hugortega]

It's possible only if you turn down the mysql server on both machines before start the sync. I tested with a little customer with several point of sales and works fine. That's not the most elegant solution, but do the job ... anyway, I recommend the mysql replication schema to avoid bandwidth waste.