Timeline for MySql master and slave design
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 18, 2013 at 15:46 | history | migrated | from stackoverflow.com (revisions) | ||
| Apr 18, 2013 at 12:17 | comment | added | Chris | You need to set auto_increment_increment and auto_increment_offset to differening values. Details on this are listed on the MySQL website as well as the comment on this article: howtoforge.com/mysql_master_master_replication. Be aware that if it breaks, master/master replication can be a pain to fix, so ensure you have good monitoring set up for this. | |
| Apr 18, 2013 at 11:57 | comment | added | habeebperwad | All the tables' have id with AUTO_INCREMENT. If I am using master-master replication, i will get dubliate entry error, right? How to solve the issue? | |
| Apr 18, 2013 at 11:44 | history | answered | Aya | CC BY-SA 3.0 |