Same with PXC 5.6 and PS 5.6
mysql> show slave status \G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.43.58 Master_User: root Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 778 Relay_Log_File: mysql_sandbox5617-relay-bin.000002 Relay_Log_Pos: 283 Relay_Master_Log_File: mysql-bin.000004 Slave_IO_Running: Yes Slave_SQL_Running: No ... Last_Errno: 1062 Last_Error: Could not execute Write_rows event on table mysql.proc; Duplicate entry 'nil-test_proc2-PROCEDURE' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.000004, end_log_pos 520
... Last_SQL_Errno: 1062 Last_SQL_Error: Could not execute Write_rows event on table mysql.proc; Duplicate entry 'nil-test_proc2-PROCEDURE' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.000004, end_log_pos 520 Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_UUID: d2ea6c67-fb2b-11e3-abb3-0800273cb9cd Master_Info_File: /home/nilnandan/sandboxes/msb_5_6_17/data/master.info
Same with PXC 5.6 and PS 5.6
mysql> show slave status \G ******* ******* ****** 1. row ******* ******* ******* ******
Slave_ IO_State: Waiting for master to send event
Master_ Host: 192.168.43.58
Master_ User: root
Master_ Port: 3306
Connect_ Retry: 60
Master_ Log_File: mysql-bin.000004
Read_ Master_ Log_Pos: 778
Relay_ Log_File: mysql_sandbox56 17-relay- bin.000002
Relay_ Log_Pos: 283
Relay_ Master_ Log_File: mysql-bin.000004
Slave_ IO_Running: Yes
Slave_ SQL_Running: No
Last_ Errno: 1062
Last_ Error: Could not execute Write_rows event on table mysql.proc; Duplicate entry 'nil-test_ proc2-PROCEDURE ' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_ FOUND_DUPP_ KEY; the event's master log mysql-bin.000004, end_log_pos 520
*******
...
...
Last_SQL_ Errno: 1062
Last_SQL_ Error: Could not execute Write_rows event on table mysql.proc; Duplicate entry 'nil-test_ proc2-PROCEDURE ' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_ FOUND_DUPP_ KEY; the event's master log mysql-bin.000004, end_log_pos 520 Ignore_ Server_ Ids:
Master_ Server_ Id: 1
Master_ UUID: d2ea6c67- fb2b-11e3- abb3-0800273cb9 cd
Master_ Info_File: /home/nilnandan /sandboxes/ msb_5_6_ 17/data/ master. info
Replicate_