Can you please also share table definitions for table1, table3 too please.
mysql> SHOW CREATE TABLE table1\G
mysql> SHOW CREATE TABLE table3\G
I tried with populating all tables with test data and run INSERT/UPDATE on all three tables parallel on master and at the same time few SELECT queries on all 3 tables on slave. Didn't get any DUPLICATE KEY errors though. I will try again once i have missing info.
Can you please also share table definitions for table1, table3 too please.
mysql> SHOW CREATE TABLE table1\G
mysql> SHOW CREATE TABLE table3\G
I tried with populating all tables with test data and run INSERT/UPDATE on all three tables parallel on master and at the same time few SELECT queries on all 3 tables on slave. Didn't get any DUPLICATE KEY errors though. I will try again once i have missing info.