Bug #84729 Group Replication: Block Reads On Partitioned Nodes

• Submitted: 31 Jan 2017 8:39
• Modified: 30 Oct 2019 12:48
• Reporter: Kenny Gryp
• Status: Closed
• Category: MySQL Server: Group Replication
• Severity: S4 (Feature request)
• Version: 5.7.17
• OS: Any
• CPU Architecture: Any

[31 Jan 2017 8:39] Kenny Gryp

Description:
With group replication, when a node is partitioned, you can still read from it

(This is a feature request that is related to the bug https://bugs.mysql.com/bug.php?id=84727)

How to repeat:
- get GR cluster up and running
- do 'ifconfig eth0 down' on a node, effectively partitioning it
- do a select

Suggested fix:
add a variable to block reads from succeeding on partitioned nodes.

[31 Jan 2017 9:03] MySQL Verification Team

Hello Kenny Gryp,

Thank you for the report and feature request.

Thanks,
Umesh

[30 Oct 2019 12:48] Nuno Carvalho

Posted by developer:
 
Implemented on WL#12895: "Group Replication: Add OFFLINE_MODE to group_replication_exit_state_action" released on 8.0.18