| 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 |
[connection server2] |
| 7 |
SET @group_replication_gtid_assignment_block_size_save= @@GLOBAL.group_replication_gtid_assignment_block_size; |
| 8 |
[connection server1] |
| 9 |
SET @group_replication_gtid_assignment_block_size_save= @@GLOBAL.group_replication_gtid_assignment_block_size; |
| 10 |
|
| 11 |
############################################################ |
| 12 |
# 1. Set invalid values to group_replication_gtid_assignment_block_size. |
| 13 |
SET GLOBAL group_replication_gtid_assignment_block_size= ON; |
| 14 |
ERROR 42000: Incorrect argument type to variable 'group_replication_gtid_assignment_block_size' |
| 15 |
SET GLOBAL group_replication_gtid_assignment_block_size= OFF; |
| 16 |
ERROR 42000: Incorrect argument type to variable 'group_replication_gtid_assignment_block_size' |
| 17 |
SET GLOBAL group_replication_gtid_assignment_block_size= " "; |
| 18 |
ERROR 42000: Incorrect argument type to variable 'group_replication_gtid_assignment_block_size' |
| 19 |
SET GLOBAL group_replication_gtid_assignment_block_size= "a"; |
| 20 |
ERROR 42000: Incorrect argument type to variable 'group_replication_gtid_assignment_block_size' |
| 21 |
SET GLOBAL group_replication_gtid_assignment_block_size= 1.0; |
| 22 |
ERROR 42000: Incorrect argument type to variable 'group_replication_gtid_assignment_block_size' |
| 23 |
SET GLOBAL group_replication_gtid_assignment_block_size= 0; |
| 24 |
ERROR 42000: The value 0 is not within the range of accepted values for the option group_replication_gtid_assignment_block_size.The value must be between 1 and 9223372036854775807 inclusive. |
| 25 |
SET GLOBAL group_replication_gtid_assignment_block_size= -1; |
| 26 |
ERROR 42000: The value -1 is not within the range of accepted values for the option group_replication_gtid_assignment_block_size.The value must be between 1 and 9223372036854775807 inclusive. |
| 27 |
SET GLOBAL group_replication_gtid_assignment_block_size= 9223372036854775808; |
| 28 |
ERROR 42000: The value -9223372036854775808 is not within the range of accepted values for the option group_replication_gtid_assignment_block_size.The value must be between 1 and 9223372036854775807 inclusive. |
| 29 |
|
| 30 |
############################################################ |
| 31 |
# 2. Set valid values to group_replication_gtid_assignment_block_size. |
| 32 |
SET GLOBAL group_replication_gtid_assignment_block_size= 1; |
| 33 |
include/assert.inc [group_replication_gtid_assignment_block_size is correct] |
| 34 |
SET GLOBAL group_replication_gtid_assignment_block_size= 65535; |
| 35 |
include/assert.inc [group_replication_gtid_assignment_block_size is correct] |
| 36 |
SET GLOBAL group_replication_gtid_assignment_block_size= 4294967295; |
| 37 |
include/assert.inc [group_replication_gtid_assignment_block_size is correct] |
| 38 |
SET GLOBAL group_replication_gtid_assignment_block_size= 9223372036854775807; |
| 39 |
include/assert.inc [group_replication_gtid_assignment_block_size is correct] |
| 40 |
|
| 41 |
############################################################ |
| 42 |
# 3. Try set group_replication_gtid_assignment_block_size |
| 43 |
# while Group Replication is running. |
| 44 |
# It will be disallowed. |
| 45 |
SET GLOBAL group_replication_gtid_assignment_block_size= 1; |
| 46 |
include/assert.inc [group_replication_gtid_assignment_block_size is correct] |
| 47 |
include/start_and_bootstrap_group_replication.inc |
| 48 |
SET GLOBAL group_replication_gtid_assignment_block_size= 1000; |
| 49 |
ERROR HY000: The group_replication_gtid_assignment_block size cannot be set while Group Replication is running |
| 50 |
include/assert.inc [group_replication_gtid_assignment_block_size is 1] |
| 51 |
|
| 52 |
############################################################ |
| 53 |
# 4. Try join a group with a different value for |
| 54 |
# group_replication_gtid_assignment_block_size than the |
| 55 |
# group one. It will be disallowed. |
| 56 |
[connection server2] |
| 57 |
SET GLOBAL group_replication_gtid_assignment_block_size= 2; |
| 58 |
START GROUP_REPLICATION; |
| 59 |
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log. |
| 60 |
Matching lines are: |
| 61 |
DATE_TIME [ERROR] [MY-011527] [Repl] Plugin group_replication reported: 'The member is configured with a group_replication_gtid_assignment_block_size option value '2' different from the group '1'. The member will now exit the group.' |
| 62 |
Occurrences of 'The member is configured with a group_replication_gtid_assignment_block_size option value' in the input file: 1 |
| 63 |
|
| 64 |
############################################################ |
| 65 |
# 5. Clean up. |
| 66 |
[connection server1] |
| 67 |
include/stop_group_replication.inc |
| 68 |
SET GLOBAL group_replication_gtid_assignment_block_size= @group_replication_gtid_assignment_block_size_save; |
| 69 |
[connection server2] |
| 70 |
SET GLOBAL group_replication_gtid_assignment_block_size= @group_replication_gtid_assignment_block_size_save; |
| 71 |
include/group_replication_end.inc |