What happens if you create a new record in a MySQL table at the same time?

Question

MySQL

Set up Master-Master replication between two MySQL servers. What will happen if at the same time on both servers add two NEW BUT DIFFERENT records in the same table of the same database?

Answer 1

Hot. I'll just throw you a link from my bookmarks

Answer 2

To avoid problems, manage the indexes yourself, at least at the application level, let each node take its own group for each index (for example, for 2 nodes - one is even, the other is not even).
In general, replication is a great way to shoot yourself in the foot, a good tool but you need to use it wisely.