Bug #77996 Fabric does not stop replication when server is removed from active group.
Submitted: 8 Aug 2015 23:55 Modified: 25 Aug 2015 11:17
Reporter: Sterling Cox Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Fabric: Executor Severity:S3 (Non-critical)
Version:1.5.3 OS:Ubuntu (14.04LTS)
Assigned to: CPU Architecture:Any
Tags: ha, members, removing, replication, STATUS

[8 Aug 2015 23:55] Sterling Cox 
Description:
Removing a server from a group does not stop it replicating from the PRIMARY in that group. Seems like it really should.

This running on Percona 5.6.23-72.1 servers.

How to repeat:
~# msf group lookup_servers gp0tmp
Fabric UUID:  5c2dab1e-a007-feed-f00d-cab3f2d3249e
Time-To-Live: 1

                         server_uuid address  status       mode weight
------------------------------------ ------- ------- ---------- ------
08f82dbd-3bcc-11e5-9373-f23c912607f4    db2c   SPARE    OFFLINE    1.0
d8f2dfac-13ce-11e5-8eb0-f2dc91189be4  dbtf02   SPARE    OFFLINE    1.0
f42d8a6b-c136-11e4-b41c-f23c92d3c356     db2 PRIMARY READ_WRITE    1.0

~# mysqlfabric group remove gp0tmp dbtf02
Fabric UUID:  5c2dab1e-a007-feed-f00d-c2d32d13249e
Time-To-Live: 1

                                uuid finished success result
------------------------------------ -------- ------- ------
fa232d14-b7a5-462b-919e-9e2d8a575b2c        1       1      1

state success          when                                                        description
----- ------- ------------- ------------------------------------------------------------------
    3       2 1439077153.32 Triggered by <mysql.fabric.events.Event object at 0x7f3c7ac40750>.
    4       2 1439077153.33                                 Executing action (_remove_server).
    5       2 1439077153.33                                  Executed action (_remove_server).

~# mysqlfabric group lookup_servers gp0tmp
Fabric UUID:  5c2dab1e-a007-feed-f00d-cab3f2d3249e
Time-To-Live: 1

                         server_uuid address  status       mode weight
------------------------------------ ------- ------- ---------- ------
08f82dbd-3bcc-11e5-9373-f23c912607f4    db2c   SPARE    OFFLINE    1.0
f42d8a6b-c136-11e4-b41c-f23c92d3c356     db2 PRIMARY READ_WRITE    1.0

mysql>show slave status\G
Sat Aug  8 20:50:36 ART 2015: dbtf02
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
        Seconds_Behind_Master: 0
              Relay_Log_Space: 1,024,339,444

Suggested fix:
Turn off replication on the removed server?
[25 Aug 2015 11:17] Paulo Jesus 
Thank you for your bug report. The issue was verified.
[25 Aug 2015 11:21] Paulo Jesus 
Posted by developer:
 
Replication should be automatically stopped when a SECONDARY or SPARE server is removed from its group.
[6 Jul 2017 19:20] Bugs System 
Status updated to 'Won't fix' (Fabric is now covered under Oracle Lifetime Sustaining Support)