Debian Codegraph @

mysql-test/suite/rpl/r/rpl_relay_log_space_limit.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 # 1. Start the receiver
8
9 [connection slave]
10 include/start_slave_io.inc
11
12 # 2. Create a table
13 # 3. Generate 2 small transactions, rotate relay log after each
14 # transaction
15
16 [connection master]
17 CREATE TABLE t (a LONGBLOB) ENGINE = InnoDB;
18 INSERT INTO t VALUES (REPEAT('a', 1000));
19 include/sync_slave_io_with_master.inc
20 FLUSH RELAY LOGS;
21 [connection master]
22 INSERT INTO t VALUES (REPEAT('a', 1000));
23 include/sync_slave_io_with_master.inc
24 FLUSH RELAY LOGS;
25
26 # 4. Generate a transaction that exceeds the relay log space limit, which
27 # will block the receiver
28
29 [connection master]
30 INSERT INTO t VALUES (REPEAT('a', 10000));
31
32 # 5. Run replication applier
33
34 [connection slave]
35 include/start_slave_sql.inc
36
37 # 6. Synchronize source and replica servers
38
39 [connection master]
40 include/sync_slave_sql_with_master.inc
41
42 # 7. Execute a transaction that cannot fit into the relay log space
43 # limit. After purging relay log, the limit is ignored.
44
45 [connection master]
46 INSERT INTO t VALUES (REPEAT('a', 15000));
47
48 # 8. Synchronize source and replica servers
49
50 include/sync_slave_sql_with_master.inc
51
52 # Clean up
53
54 [connection master]
55 DROP TABLE t;
56 include/rpl_end.inc