Renato Golin wrote:
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN.
Yeah, known problem...
We have an offsite backup that needs to be in the replication (2-way
to make switching back and forth easy) chain.
Why do you need a backup site to write things to your master ? Or did
I got wrong ?
This is another geographical location with automatic failover if there
is a problem, network, hardware etc. with the primary location. When the
problem is corrected, or corrects itself the traffic is automatically
sent back to the primary location. Without 2-way replication data would
be lost. We have been doing this for since MySQL 4.0 was released.
I am thinking of a master, slave setup at each location where the
masters continue to replicate both ways and then each replicates to
it's own slaves. I would like to load balance these slaves on each end.
Let me see if I got it right: you have two sites, one master on each,
one slave on each., and you want both master to replicate to the other
and both slaves to receive data from them as well. Right ?
If so, MySQL does not support multi-master setup.
It is not a multi-master setup. The master at each location is both
master and slave to each other. The slaves are only slaves to the master
in their respective locations. My problem is really with how to load
balance the slaves at each location.
As far as I've heard there is no direct move into that direction from
MySQL developers, although a voting system for a new master among one
of the slaves can happen in the near future.
What may work is to have only one master on one of your sites and both
sites update the same master (reducing speed for the slave site) and
in the case of failure you switch them (manually or with some tool).
hope that helps,
--renato
--
Ed Pauley II
Internet Software Developer
Bloodstock Research Information Services
859.223.4444
800.354.9206 ext. 297
[EMAIL PROTECTED]
http://www.brisnet.com
http://www.brisbet.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
