I'm studing a solution to do Mysql replication master-master within servers in different location, for redundancy, load balancing and fault tolerance. What I figured out so far is that is master-master replication inserts can be done in any of the servers and it will be replicated to the 2nd, 3rd... masters. I've checked all the tuturials about replications and ready ti implement and test. But there is a problem that i havent found a solution. Imagine a cenario on a database that all primary keys are INT and auto increment. What happens if two inserts are made on the same time on diferent master-master Mysql replicated servers, can I have the chance of loosinf integrety? Should the db struture have another colum identifying the id of the replication server? What concerns should I have about database struture on a master-master replication? Thanks
