1 Dec
2008
1 Dec
'08
7:49 p.m.
BERGANZ François wrote:
Hello,
I need to know how to use 2 mysql servers, if my first server go down...
Have you an idea?
Quite a few different ways depending on your ultimate goal. I believe
the simplest method would be to setup
a master-master replication between your two mysql servers.
Then place both IP addresses in a single DNS A record, which gives you a
round robin effect, but doesn't necessarily achieve 'high availability.'
A more complex situation would be ultramonkey (linux-ha) and/or some
sort of mysql connection proxying environment.
Jeremy McNamara