|
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.
Just a thought.
Mike
| 