Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_binlog_index.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 CREATE TABLE t1 (a INT);
7 FLUSH BINARY LOGS;
8 INSERT INTO t1 VALUES (1);
9 include/stop_slave.inc
10 # Shutdown master
11 include/rpl_stop_server.inc [server_number=1]
12 # Move the master binlog files and the index file to a new place
13 # Restart master with log-bin option set to the new path
14 # Master has restarted successfully
15 include/start_slave.inc
16 # Create the master-bin.index file with the old format
17 include/stop_slave.inc
18 # Shutdown master
19 include/rpl_stop_server.inc [server_number=1]
20 # Move back the master binlog files
21 # Remove the unneeded master-bin.index file
22 # Restart master with log-bin option set to default
23 # Master has restarted successfully
24 include/start_slave.inc
25 include/rpl_stop_server.inc [server_number=2]
26 # relocate binlogs
27 # relocate relay logs
28 # Restart slave with options log-bin, relay-log set to the new paths
29 # Slave server has restarted successfully
30 include/start_slave.inc
31 include/stop_slave.inc
32 FLUSH LOGS;
33 INSERT INTO t1 VALUES (2);
34 INSERT INTO t1 VALUES (2);
35 INSERT INTO t1 VALUES (2);
36 INSERT INTO t1 VALUES (2);
37 FLUSH LOGS;
38 FLUSH LOGS;
39 include/start_slave.inc
40 include/diff_tables.inc [master:t1,slave:t1]
41 DROP TABLE t1;
42 include/stop_slave.inc
43 include/rpl_stop_server.inc [server_number=2]
44 # remove tmpdir
45 # restarted with previous slave settings
46 include/start_slave.inc
47 include/rpl_end.inc