I am running 5.0.24a on Slackware Linux. I would like to set up a
master-master replication process so that I can use both servers as master as
add/delete/update records on both servers from different application servers
(Tomcat.) I suspect the inserts will be OK but don't understand how the edits
and deletes would work (primary key is autoincrement):
(Serial)
(Serial)
Transaction Server A
Server B
Add to server A 1
Replicated
1
Add to server A 2
Add to server B (before record 2
2
is replicated)
Replicate to server B
?
Replicate to server A ?
Does replication control the order in which transactions are applied so that
somehow the replication from server A to server B is applied before the insert
to server B?
TIA,
Carl
