I have a central Database which I want to spread across our regional offices for faster access and performance.
A transaction that is effected in a regional office must be syncronized to the central database and vice versa.
The databases have primary keys auto-generated. There should be no conflict of such keys or unique constraints.
I researched on the internet and found that this can be done using master to master replication.Is this method 100% sure of fixing key constraint conflicts ?
Or is there a better method ? I am using Mysql 5.4