Hi Robert, I did not see any suggestions to you. So here is one. If you want a guarantee simple brute force dump the entire DB with mysqldump and recreate of the slave. For Exmaple mysqldump --opt mydb | mysql -umyuser -pmypwd -hremotehost myremotedb
You can run this through an ssh tunnel for security or compress and forward or do it in multiple steps. But if it completes without errors all data will be present on the remote system. Hope this helps, Ken ----- Original Message ----- From: "robertxu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 21, 2003 6:37 PM Subject: Inquery from Varian Medical Systems > To Whom It May Concern: > > I am Robert and work for Varian Medical Systems. MySQl is the backend of > our Intranet, VMSNet. > > Our current environment is: > > The web server and MySQL reside in one hardware server- US server. If this > hardware server fails, we switch the users to our European web server. But > the European web server is not bundled with MySQL. So all the MySQL > applications still are not available until US server is back. That is the > problem. > > Someone suggests to set up MySQL master and slave instances to solves > this. But such configuration does not guarantee 100% data synchronization > between the master and the slave. > > Is there any other alternatives? Please advise. Appreciate your attention > and time. > > > Regards, > > Robert > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
