|
Michael McConnell wrote:
I know this is a little off topic. But here goes.
Can anyone see a down side or a reason why one could not have two System
in a Failover Relationship running MySQL. The Database file would be
synchronized between the two systems via a crontab and rsync.
Can anyone see a reason why rsync would not work? I've on many occasions
copied the entire mysql data directory to another system and start it up
without a problem.
I recognize that there are potential problems that the rsync might take
place whil the master is writing and the sync will only have part of a
table, but mysql's new table structure is supposed to account for this.
If anything a quick myismfix should resolve these problems.
Why not just use MySQL's built in replication?
--
=======================================================================
Paul J. Baker Internet Systems Developer
pbaker@xxxxxxxxxxxxxxx Where2GetIt.com
phone 847-498-0111x234
fax 847-480-7422
=======================================================================
| 