Bug #80291 relax restrictions on replicate_same_server_id with gtid_mode

• Submitted: 5 Feb 2016 19:34
• Modified: 8 Feb 2016 7:29
• Reporter: Santosh Praneeth Banda
• Status: Verified
• Category: MySQL Server: Replication
• Severity: S3 (Non-critical)
• Version: 5.6.27, 5.6.29, 5.7.11
• OS: Any
• CPU Architecture: Any
• Tags: GTID, replication

[5 Feb 2016 19:34] Santosh Praneeth Banda

Description:
Currently MySQL cannot be started with --replicate-same-server-id and --log-slave-updates. MySQL refuses to restart with the following error

"using --replicate-same-server-id in conjunction with --log-slave-updates is impossible, it would lead to infinite loops in this server."

But with gtid_mode=ON, I don't think infinite loops are possible. GTID feature is built to handle circular topology.

How to repeat:
see description

Suggested fix:
relax the restriction by checking for gtid_mode=ON

[8 Feb 2016 7:29] MySQL Verification Team

Hello Santosh,

Thank you for the report.

Thanks,
Umesh