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 ?
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