List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:June 30 2010 10:39am
Subject:Re: MySQL Replication
View as plain text  
Hi

Just one other question.  With regards the replication in MySQL 5.1 - does
it it replication the whole row of data or just the field in which the data
has been changed for the current record ?

Thanks
Neil


2010/6/24 Jaime Crespo Rincón <jcrespo@stripped>

> 2010/6/24 Tompkins Neil <neil.tompkins@stripped>:
> > Hi
> >
> > Regarding two-way replication what do you mean by "very
> > controlled environment" ?  What things do I need to consider ?
>
> Control at application level that you are not going to
> insert/update/delete the same record on the two servers.
> Even if MySQL gives some support to handle this
> (auto-increment-offset, replicate-ignore-table), you should mostly
> handle it at business logic (application server) layer, not in the
> MySQL database. Alternatively, as Johan pointed, have a look at the
> semi-synchronous replication.
>
>
> --
> Jaime Crespo
> MySQL & Java Instructor
> Warp Networks
> <http://warp.es>
>

Thread
MySQL ReplicationTompkins Neil24 Jun
  • Re: MySQL ReplicationJaime Crespo Rincón24 Jun
    • Re: MySQL ReplicationTompkins Neil24 Jun
      • Re: MySQL ReplicationJaime Crespo Rincón24 Jun
        • Re: MySQL ReplicationTompkins Neil30 Jun
          • Re: MySQL ReplicationJaime Crespo Rincón30 Jun
  • Re: MySQL ReplicationMark Goodge24 Jun
    • Re: MySQL ReplicationTompkins Neil24 Jun
      • Re: MySQL ReplicationJohan De Meersman24 Jun