| 1 |
SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME"; |
| 2 |
# |
| 3 |
# Test if binlog_format with the wrong value will fail. |
| 4 |
# |
| 5 |
SET GLOBAL binlog_format= STATEMENT; |
| 6 |
Warnings: |
| 7 |
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release. |
| 8 |
START GROUP_REPLICATION; |
| 9 |
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log. |
| 10 |
SET GLOBAL binlog_format= "ROW"; |
| 11 |
Warnings: |
| 12 |
Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release. |
| 13 |
SET GLOBAL binlog_transaction_dependency_tracking= COMMIT_ORDER; |
| 14 |
Warnings: |
| 15 |
Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release. |
| 16 |
SET GLOBAL transaction_write_set_extraction=OFF; |
| 17 |
Warnings: |
| 18 |
Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release. |
| 19 |
START GROUP_REPLICATION; |
| 20 |
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log. |
| 21 |
SET GLOBAL transaction_write_set_extraction= WRITE_SET_EXTRACTION_ALGORITHM; |
| 22 |
Warnings: |
| 23 |
Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release. |
| 24 |
SET GLOBAL binlog_transaction_dependency_tracking= BINLOG_TRANSACTION_DEPENDENCY_TRACKING; |
| 25 |
Warnings: |
| 26 |
Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release. |
| 27 |
# |
| 28 |
# Test if parallel applier is enabled and that start |
| 29 |
# Group Replication will fail. |
| 30 |
# |
| 31 |
SET @replica_parallel_type_saved= @@GLOBAL.REPLICA_PARALLEL_TYPE; |
| 32 |
Warnings: |
| 33 |
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release. |
| 34 |
SET @replica_parallel_workers_saved= @@GLOBAL.REPLICA_PARALLEL_WORKERS; |
| 35 |
SET @replica_preserve_commit_order= @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER; |
| 36 |
SET @@GLOBAL.REPLICA_PARALLEL_TYPE= "DATABASE"; |
| 37 |
Warnings: |
| 38 |
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release. |
| 39 |
SET GLOBAL REPLICA_PARALLEL_WORKERS= 4; |
| 40 |
START GROUP_REPLICATION; |
| 41 |
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log. |
| 42 |
SET @@GLOBAL.REPLICA_PARALLEL_TYPE= "LOGICAL_CLOCK"; |
| 43 |
Warnings: |
| 44 |
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release. |
| 45 |
SET GLOBAL REPLICA_PARALLEL_WORKERS= 4; |
| 46 |
SET @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER= OFF; |
| 47 |
START GROUP_REPLICATION; |
| 48 |
ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log. |
| 49 |
SET @@GLOBAL.REPLICA_PARALLEL_TYPE= @replica_parallel_type_saved; |
| 50 |
Warnings: |
| 51 |
Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release. |
| 52 |
SET @@GLOBAL.REPLICA_PARALLEL_WORKERS= @replica_parallel_workers_saved; |
| 53 |
SET @@GLOBAL.REPLICA_PRESERVE_COMMIT_ORDER= @replica_preserve_commit_order; |
| 54 |
call mtr.add_suppression("Binlog format should be ROW for Group Replication"); |
| 55 |
call mtr.add_suppression("Extraction of transaction write sets requires*"); |
| 56 |
call mtr.add_suppression("In order to use parallel applier on Group Replication, parameter replica-parallel-type must be set to 'LOGICAL_CLOCK'"); |
| 57 |
call mtr.add_suppression("Group Replication requires replica-preserve-commit-order to be set to ON when using more than 1 applier threads."); |