You can run two different servers pointing to the same data dir, but for what you are asking you should use replication..
See: http://www.mysql.com/doc/R/e/Replication.html For redundancy , you have to write scripts.. See: http://www.mysql.com/doc/R/e/Replication_FAQ.html Gurhan -----Original Message----- From: Jean-Rene Cormier [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 2:48 PM To: [EMAIL PROTECTED] Subject: Multiple MySQL server for one db I would like to know if there's anyway I can setup 2 servers running MySQL to either share the same database or keep in sync with each other. So if something happens and one server goes down the other one can still be able to serve the users. Thanks Jean-Rene Cormier --------------------------------------------------------------------- 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
