Debian Codegraph @

mysql-test/suite/rpl/r/rpl_perfschema_connect_config.result

raw
1 include/master-slave.inc
2 [connection master]
3 # Asserted this: On master, the table should return an empty set.
4 connection slave;
5
6 # Verify that SELECT works for every field and produces an output
7 # similar to the corresponding field in SHOW SLAVE STATUS(SSS).
8
9 include/assert.inc [Value returned by SSS and PS table for Host should be same.]
10 include/assert.inc [Value returned by SSS and PS table for Port should be same.]
11 include/assert.inc [Value returned by SSS and PS table for User should be same.]
12 include/assert.inc [Value returned by SSS and PS table for Using_Gtid should be same.]
13 include/assert.inc [Value returned by SSS and PS table for SSL_Allowed should be same.]
14 include/assert.inc [Value returned by SSS and PS table for SSL_CA_File should be same.]
15 include/assert.inc [Value returned by SSS and PS table for SSL_CA_Path should be same.]
16 include/assert.inc [Value returned by SSS and PS table for SSL_Certificate should be same.]
17 include/assert.inc [Value returned by SSS and PS table for SSL_Cipher should be same.]
18 include/assert.inc [Value returned by SSS and PS table for SSL_Key should be same.]
19 include/assert.inc [Value returned by SSS and PS table for SSL_Verify_Server_Certificate should be same.]
20 include/assert.inc [Value returned by SSS and PS table for SSL_Crl_File should be same.]
21 include/assert.inc [Value returned by SSS and PS table for SSL_Crl_Path should be same.]
22 include/assert.inc [Value returned by SSS and PS table for Connection_Retry_Interval should be same.]
23 include/assert.inc [Value returned by PS table for Connection_Retry_Count should be 10.]
24
25 # Heartbeat_Interval is part of I_S and P_S. We will compare the
26 # two to make sure both match.
27
28 include/assert.inc [Value returned by IS and PS table for Heartbeat_Interval should be same.]
29
30 # Change configuration parameters and verify that these changes
31 # are shown correctly by SELECTs from PS table.
32
33 connection master;
34 create user replssl@localhost;
35 grant replication slave on *.* to replssl@localhost require ssl;
36 include/sync_slave_sql_with_master.inc
37 include/stop_slave.inc
38 change master to
39 master_user= 'replssl',
40 master_password= '',
41 master_ssl= 1,
42 master_ssl_ca= 'MYSQL_TEST_DIR/std_data/cacert.pem',
43 master_ssl_cert= 'MYSQL_TEST_DIR/std_data/client-cert.pem',
44 master_ssl_key= 'MYSQL_TEST_DIR/std_data/client-key.pem';
45 include/start_slave.inc
46 connection slave;
47
48 # Checking SSL parameters, they were empty in tests done in the
49 # previous section.
50
51 include/assert.inc [Value returned by SSS and PS table for SSL_Allowed should be same.]
52 include/assert.inc [Value returned by SSS and PS table for SSL_CA_File should be same.]
53 include/assert.inc [Value returned by SSS and PS table for SSL_CA_Path should be same.]
54 include/assert.inc [Value returned by SSS and PS table for SSL_Certificate should be same.]
55 include/assert.inc [Value returned by SSS and PS table for SSL_Cipher should be same.]
56 include/assert.inc [Value returned by SSS and PS table for SSL_Key should be same.]
57 include/assert.inc [Value returned by SSS and PS table for SSL_Verify_Server_Certificate should be same.]
58 connection master;
59 drop user replssl@localhost;
60 connection slave;
61 include/stop_slave.inc
62 CHANGE MASTER TO
63 master_host= '127.0.0.1',
64 master_user= 'root',
65 master_password= '',
66 master_ssl_ca= '',
67 master_ssl_cert= '',
68 master_ssl_key= '',
69 master_ssl_verify_server_cert=0,
70 master_ssl=1,
71 master_use_gtid=no;
72 include/start_slave.inc
73
74 # Test with different MASTER_USE_GTID values
75
76
77 # 1) Test for MASTER_USE_GTID=NO
78
79 include/stop_slave.inc
80 change master to
81 master_user = 'root',
82 master_use_gtid = NO;
83 include/assert.inc [Value returned by SSS and PS table for Using_Gtid should be same.]
84
85 # 2) Test for Auto_position= CURRENT_POS.
86
87 change master to
88 master_user = 'root',
89 master_use_gtid= CURRENT_POS;
90 include/assert.inc [Value returned by SSS and PS table for Using_Gtid should be same.]
91
92 # 3) Test for Auto_position= SLAVE_POS
93
94 change master to
95 master_user = 'root',
96 master_use_gtid= SLAVE_POS;
97 include/assert.inc [Value returned by SSS and PS table for Using_Gtid should be same.]
98
99 # Test INOGRE_SERVER_IDS
100
101
102 # 1) Test for IGNORE_SERVER_IDS= (10, 100);
103
104 connection slave;
105 change master to IGNORE_SERVER_IDS= (10, 100);
106 include/assert.inc [Value returned by SSS and PS table for Ignore_server_ids should be same.]
107 CHANGE MASTER TO IGNORE_SERVER_IDS=();
108
109 # 2) Test for IGNORE_DOMAIN_IDS(2)
110
111 CHANGE MASTER TO IGNORE_DOMAIN_IDS=(2), MASTER_USE_GTID=slave_pos;
112 include/start_slave.inc
113 include/assert.inc [Value returned by SSS and PS table for Replicate_Ignore_Domain_Ids should be same.]
114 include/stop_slave.inc
115
116 # 3) Test for DO_DOMAIN_IDS(1)
117
118 CHANGE MASTER TO DO_DOMAIN_IDS=(1), IGNORE_DOMAIN_IDS=(), MASTER_USE_GTID=slave_pos;
119 include/start_slave.inc
120 include/assert.inc [Value returned by SSS and PS table for Replicate_Do_Domain_Ids should be same.]
121 include/stop_slave.inc
122 CHANGE MASTER TO DO_DOMAIN_IDS=(), IGNORE_DOMAIN_IDS=();
123 include/start_slave.inc
124 include/rpl_end.inc