Hi Richard What we do is use Master Slave set-up on MySQL. So the Master dose all the work and the slave is like a host standby that we do backups from. We use Heartbeat (HA project) with all requests going to one IP. As soon as MySQL fails on box one the IP address is past to the slave. Another system pages us. I do not allow the Master backup until some one has looked at it. We have one Linux box and one FreeBSD to prevent OS problems.
Simon -----Original Message----- From: Richard Morton [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 11:58 To: MySQL List Subject: Highly Reliable MySQL Installations Hi, I am looking for advise on producing a MySQL platform which is reliable (i.e. fault resilient). I am not sure how, using MySQL's technology I can have two systems each one mirroring the other, and if the primary server fails, how the system can automatically use the other server for all DB access. What is the avg latency on the slave server in Replication? Any Ideas or Suggestions on this? Thanks Richard --------------------------------------------------------------------- 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
