Re: copying a database in real time.

>>>
>> The problem with using replication in this situation is that
>> the slave (the new system) will create new records with new
>> primary keys at the same time that the old system is creating
>> new records with new primary keys which are then copied to the
>> slave system causing a duplicate record error.
>>
>> I _think_ that master-master replication would work.
>>
>> bill

> 
> That only happens if you're updating the slave.  With a 
> master-slave relationship all updates should be done only through 
> the master; the slave can be used for fetching data.
> 

Correct, but in this case he was talking about having both create new records

-bill Received on Sat Jan 20 2018 - 13:23:51 CET