1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
include/master-slave.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
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.
[connection master]
[connection master]
CREATE TABLE t1 (c1 INT);
INSERT INTO t1 (c1) VALUES (1);
include/sync_slave_sql_with_master.inc
[connection slave]
include/stop_slave_sql.inc
[connection master]
FLUSH LOGS;
FLUSH LOGS;
INSERT INTO t1 (c1) VALUES (2);
include/sync_slave_io_with_master.inc
call mtr.add_suppression("File '.*slave-relay-bin.");
call mtr.add_suppression("Could not open log file");
call mtr.add_suppression("Failed to open the relay log");
call mtr.add_suppression("Replica failed to initialize applier metadata structure");
call mtr.add_suppression("Could not find target log file mentioned in applier metadata in the index file");
call mtr.add_suppression("Failed to initialize the relay-log-info structure");
call mtr.add_suppression("Failed to initialize the connection metadata structure");
call mtr.add_suppression("Failed to create or recover replication info repositories");
call mtr.add_suppression("listed in the index, but failed to stat");
call mtr.add_suppression("Error counting relay log space");
include/rpl_stop_server.inc [server_number=2]
# Removing file(s)
include/rpl_start_server.inc [server_number=2]
START SLAVE;
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
START SLAVE;
ERROR HY000: Replica failed to initialize applier metadata structure from the repository
RESET SLAVE;
RESET MASTER;
DROP TABLE t1;
include/start_slave.inc
[connection master]
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:t1, slave:t1]
[connection master]
DROP TABLE t1;
include/sync_slave_sql_with_master.inc
include/rpl_end.inc
|
