List:General Discussion« Previous MessageNext Message »
From:Ken Menzel Date:November 24 2003 4:01pm
Subject:Re: Inquery from Varian Medical Systems
View as plain text  
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" <robert.xu@stripped>
To: <mysql@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
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/mysql?unsub=1
>
>

Thread
Inquery from Varian Medical Systemsrobertxu22 Nov
  • Re: Inquery from Varian Medical SystemsKen Menzel24 Nov