| 1 |
################################################################################ |
| 2 |
# |
| 3 |
# Bug#25674926 VIEW CHANGE LOG EVENTS GENERATE NEW GTIDS |
| 4 |
# |
| 5 |
# Problem: When there is replication (async) between two groups, |
| 6 |
# group nodes are confused when it receives view_change_log_event |
| 7 |
# that is generated on the other group and the event is making |
| 8 |
# infinite round trips between the groups in case if the async |
| 9 |
# replication is circular replication. |
| 10 |
# |
| 11 |
# Scenario: Verify Group Replication behavior when we establish a |
| 12 |
# circular replication connection from a server in a group |
| 13 |
# to another server in the other group. |
| 14 |
# Steps to reproduce: |
| 15 |
# 0. The test requires six servers: M1, M2, M3, M4, M5 and M6. |
| 16 |
# 1. Bootstrap start a group, GR1, on M1. Start GR on M2 and add it GR1. |
| 17 |
# 2. Bootstrap start a group, GR2, on M3. Start GR on M4 and add it GR2. |
| 18 |
# 3. Setup a asynchronous replication connection from M3(GR2) into M1(GR1) |
| 19 |
# i.e. M3 -> M1. |
| 20 |
# 4. Setup a asynchronous replication connection from M1(GR1) into M3(GR2) |
| 21 |
# i.e. M1 -> M3. |
| 22 |
# 5. Test view change event issue by adding/dropping nodes from the groups. |
| 23 |
# Add node M5 to group GR1, and add node M6 to group GR2 and immediately |
| 24 |
# drop the node from group (GR2). (This step is just to generate more |
| 25 |
# VIEW_EVENTs) |
| 26 |
# 6. Execute some transactions on M3. |
| 27 |
# 7. Wait until transactions executed on M3 are applied on all nodes of GR1 |
| 28 |
# and GR2. |
| 29 |
# 8. Execute some transactions on M1. |
| 30 |
# 9. Wait until transactions executed on M1 are applied on all nodes of GR1 |
| 31 |
# and GR2. |
| 32 |
# 10. Validate data on all nodes (M1, M2, M3, M4 and M5). |
| 33 |
# 11. Check that GTID_EXECUTED on all servers are as expected. |
| 34 |
# 12. Clean data. |
| 35 |
# 13. Stop circular replication between groups. |
| 36 |
# 14. Stop Group Replication on all nodes (M1, M2, M3, M4 and M5). |
| 37 |
################################################################################ |
| 38 |
|
| 39 |
--source ../include/gr_replicate_group_to_group.inc |