List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:October 18 2011 10:47am
Subject:Re: Synchronize two mysql servers (single user, only one server (but
not both) can be changed at any given time)
View as plain text  
As Johan describes, replication is the way. If that's not an option due to
connectivity between the hosts you could arrange for a logical dump to be
copied and restored. I would certainly opt for replication in your
situation.

A




On Tue, Oct 18, 2011 at 7:02 AM, Johan De Meersman <vegivamp@stripped>wrote:

> ----- Original Message -----
> > From: "Peng Yu" <pengyu.ut@stripped>
> >
> > Suppose I have two servers (one on mac and one on ubuntu), at any
> > time I only change one server but not both servers. After I have done
> >
> > I think that probably it is OK to synchronize these two servers at
> > the database file level using something like unison. However, this will
>
> It's not generally a good idea to copy database files across platforms, let
> alone possibly different versions of the mysql server.
>
> You probably want to set up master-master replication, which should work
> fine across platforms. If you are sure that you'll never change the (same)
> data on both sides concurrently, there is pretty much nothing that can go
> wrong.
>
> Have a look at the online documentation at mysql.com, it should be your
> first stop for everything :-)
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
Synchronize two mysql servers (single user, only one server (but notboth) can be changed at any given time)Peng Yu18 Oct
  • Re: Synchronize two mysql servers (single user, only one server (but not both) can be changed at any given time)Johan De Meersman18 Oct
    • Re: Synchronize two mysql servers (single user, only one server (butnot both) can be changed at any given time)Andrew Moore18 Oct