| 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 |