I've devised a solution under Linux, using Heartbeat, DRBD and Perl, but we have not put it into production yet. We also use LVS to put our database slaves into HA clusters.
The basic idea is that you have an Active/Standby master, (the standby being a slave) in a heartbeat cluster. You use DRBD to mirror the binlogs to the secondary machine. When a failure occurs, the standby takes over (this is done automatically with heartbeat), and at most, you lose only your current inserts that were happening during the failure. Heartbeat: http://linux-ha.org/ LVS: http://www.linuxvirtualserver.org/ DRBD: http://www.complang.tuwien.ac.at/reisner/drbd/ -J -----Original Message----- From: Rodrigo Dias Cruz [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 1:32 PM To: [EMAIL PROTECTED] Subject: Replication Hello I'd like to know if they have already implemented that feature of replication that changes the master server to other serve if the master fails. If they have not implemented that yet, how can I do something similar using the features that mysql have now? Thank you for any answer. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/03 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
