redudancy / high availability

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).

Did anybody manage to setup such a system ? Please explain me how, with
which kind of scripts or tools.

Thanks






---------------------------------------------------------------------
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 <mysql-thread113284@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php