On Mon, Jul 01, 2002 at 06:24:45PM +0200, Mathieu DESPRIEE - NO SPAM wrote: > Hi all, > > > I want to setup (on linux systems) a pair of redundant mysql servers, > working this way : > * one master and one backup > * the master handles all the requests, the backup updates its data > frequently (and, if possible, CONSISTENTLY) from the master > * on failure of the master, the backup comes and handles all the > requests, as if it was the master. > * when the master server comes back, it updates itself from the backup, > and then restarts to work normally > > I think the slave/master system of MySQL is not sufficient (the > master does not updates itself after coming back).
What if you use a dual-master setup? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 32 days, processed 706,435,121 queries (248/sec. avg) --------------------------------------------------------------------- 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