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.
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,
----- Original Message -----
From: "robertxu" <robert.xu@stripped>
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
> our Intranet, VMSNet.
> Our current environment is:
> The web server and MySQL reside in one hardware server- US server.
> hardware server fails, we switch the users to our European web
> the European web server is not bundled with MySQL. So all the MySQL
> applications still are not available until US server is back. That
> Someone suggests to set up MySQL master and slave instances to
> this. But such configuration does not guarantee 100% data
> between the master and the slave.
> Is there any other alternatives? Please advise. Appreciate your
> and time.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: