hello, i'm new to the list and don't know if this has been discussed before, so excuse me if repeating.
i have the idea of setting up a two-way replication system with 2 mysql servers for my radius database. i need them to act interchangeably: 1. if server1 is alive, all selects and updates (radius acct) should go to server1. server2 should act as a slave for server1. 2. if server1 dies, all selects and updates (radius acct) should go to server2. so far, so good. but here comes the tricky (for me) part - when server1 comes up again, it shold do 2 things: a) catch up with server2. b) become master again, leaving server2 as it's slave (same situation as in 1. above). how could this happen ? all ideas are appreciated (pointing to reading - also), thanks in advance. kosio --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php