MySQL Replication - 1 Master - 2 Slaves. Inserting works for One, not the other
1
vote
1
answer
2357
views
I am a Python developer, working with 3 databases, configured in
Master -> slave,slave
style.
Each slave
has their own application associated with it.
I am not too familiar with database administration as it relates to replication, but I do have a working scenario between the Master, and **one of the slaves**
The first slave stays in synch at all times properly at this time.
The second slave however, **fails on the first insert**
Table creation queries, user creaiton all replicates fine, but when I input any values, **the first slave gets the record, while the second slave** does not.
I tried importing the master DB to the second slave, updates to records will replicate, but new records will not.
My research leads me to believe this is an issue with **autoincrement** but I have not been able to use this to fix the issue. As opposed to a hack and slash method which is not working I figured id ask here.
If there is any more info I can provide, please let me know.
I am on Windows. Using WAMP Server 2.5 (MySQL 5.6.17)
Thanks for reading
EDIT: I am using binlog_format=mixed
Asked by Busturdust
(125 rep)
Feb 10, 2016, 02:41 PM
Last activity: Mar 26, 2018, 06:00 PM
Last activity: Mar 26, 2018, 06:00 PM