Mysql Replication Master-Master -
i'm studing solution mysql replication master-master within servers in different location, redundancy, load balancing , fault tolerance. figured out far is master-master replication inserts can done in of servers , replicated 2nd, 3rd... masters. i've checked tuturials replications , ready ti implement , test. there problem havent found solution. imagine cenario on database primary keys int , auto increment. happens if 2 inserts made on same time on diferent master-master mysql replicated servers, can have chance of loosinf integrety? should db struture have colum identifying id of replication server? concerns should have database struture on master-master replication? thanks
using combination of auto_increment_increment
, auto_increment_offset
can command keys created on master , there should no overlap.
mysql replication database-replication
No comments:
Post a Comment