Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_gitd_only_mta_configuration_check.result

raw
1 include/master-slave.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 master]
6
7 ############################################################
8 # 1. Configure the channel with GTID_ONLY = 1
9 # Add some data to populate repository tables
10 [connection slave]
11 CHANGE REPLICATION SOURCE TO REQUIRE_ROW_FORMAT = 1, GTID_ONLY = 1;
12 include/start_slave.inc
13 [connection master]
14 CREATE TABLE t1 (a INT PRIMARY KEY);
15 INSERT INTO t1 VALUES(1);
16 include/sync_slave_sql_with_master.inc
17
18 ############################################################
19 # 2. Restart the replica.
20 # Check there is no worker info as it was purged after start
21 include/rpl_restart_server.inc [server_number=2 parameters: --skip_replica_start=1]
22 include/assert.inc [No info exists in the repository table]
23
24 ############################################################
25 # 3. Set the number of applier workers to 0
26 # Check the channel still has one worker.
27 SET @@GLOBAL.replica_parallel_workers = 0;
28 Warnings:
29 Warning 1287 '0' is deprecated and will be removed in a future release. Please use 1 instead
30 include/start_slave.inc
31 include/assert.inc [There is one worker runnning with id 1]
32
33 ############################################################
34 # 4. Disable GTID_ONLY
35 # Check the channel has no workers.
36 include/stop_slave.inc
37 CHANGE REPLICATION SOURCE TO GTID_ONLY = 0;
38 include/start_slave.inc
39 include/assert.inc [There is no worker with an ID]
40
41 ############################################################
42 # 5. Cleanup
43 [connection master]
44 DROP TABLE t1;
45 include/sync_slave_sql_with_master.inc
46 SET @@GLOBAL.replica_parallel_workers = NUMBER_OF_WORKERS;
47 include/rpl_end.inc