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 <jcre...@warp.es> > 2010/6/24 Tompkins Neil <neil.tompk...@googlemail.com>: > > 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> >
