| 1 |
include/group_replication.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 5 |
[connection server1] |
| 6 |
|
| 7 |
# 1. Start group in single primary mode. |
| 8 |
# Server1 will be primary and server 2 secondary. |
| 9 |
[connection server1] |
| 10 |
SET @@GLOBAL.DEBUG= '+d,group_replication_version_8_0_28'; |
| 11 |
include/start_and_bootstrap_group_replication.inc |
| 12 |
[connection server2] |
| 13 |
SET SESSION sql_log_bin=0; |
| 14 |
call mtr.add_suppression("Member version is read compatible with the group."); |
| 15 |
SET SESSION sql_log_bin=1; |
| 16 |
include/start_group_replication.inc |
| 17 |
|
| 18 |
# 2. Begin change of primary from server2(secondary). |
| 19 |
# Primary change should fail since server1 version is 8.0.28. |
| 20 |
# running_transactions_timeout is compatible with version 8.0.28 or greater. |
| 21 |
[connection server2] |
| 22 |
SELECT group_replication_set_as_primary("SERVER2_UUID", 0); |
| 23 |
ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; The optional timeout argument in group_replication_set_as_primary() UDF is only supported when all group members have version 8.0.29 or higher. |
| 24 |
|
| 25 |
# 3. Cleanup. |
| 26 |
[connection server1] |
| 27 |
SET @@GLOBAL.DEBUG= '-d,group_replication_version_8_0_28'; |
| 28 |
include/group_replication_end.inc |