hi,
we have 3 inet servers running mysql:

mysql1.mydom.tld
mysql2.mydom.tld
mysql3.mydom.tld

and we also got an dynamicdns entry mysql.mydom.tld.
normaly mysql.mydom.tld directs to mysql1.mydom.tld - but if mysql2
detects mysql1 is down it will use a dyndns script to become
mysql.mydom.tld.
what we now need is the exact same data content on all 3 servers!
and what we also need is any methode to "queue" tabel updates if one of
the servers is down. if mysql1 is down mysql2 will become mysql.mydom.tld
for all clients - but if an table is updated and mysql1 is down the data
will get lost on mysql1 if it comes up again... is there any tool to
"queue" mysql requests and update the failed master later on its comeback?
and how to configure the 3 mysql servers to have an

master(mysql1) <-> master(mysql2) <-> master(mysql3) <-> master(mysql1)

replication?

thx4any help Florian Engelmann

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to