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
|
# 1. Initial setup
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]
# 2. Verify that current_number_of_bytes_used for 'memory/sql/Log_event'
# is same at global and thread level
[connection slave]
include/assert.inc [Before memory count matches]
# 3. Perform transactions and sync with replica
[connection master]
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
INSERT INTO t1 VALUES (1);
UPDATE t1 SET c1 = 10;
DELETE FROM t1;
include/sync_slave_sql_with_master.inc
# 4. Verify that current_number_of_bytes_used for 'memory/sql/Log_event'
# is same at global and thread level after transactions
include/assert.inc [After memory count matches]
# 5. Verify that current_number_of_bytes_used for 'memory/sql/Log_event'
# is same at thread level before and after transactions
include/assert.inc [Thread Memory count matches]
# 6. Cleanup
[connection master]
DROP TABLE t1;
include/rpl_end.inc
|
