I am establishing Multi Master Replication [All mater can write to their database], Initially I started with two server. After establishing connection and sync data on both servers. There are some questions which are bothering me like
- If there is connection lost between two server and at that time both updates the same row or create a row with same primary. There will be collision between them and sync will break.
- Can we implement same things for Multiple Master configuration?
- Is there any monitoring and conflict resolution tools which can I use?