| 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_innodb (b1 BIT, b2 BIT); |
| 7 |
CREATE TABLE t1_ndb (c1 BIT, c2 BIT) ENGINE = NDB; |
| 8 |
CREATE TABLE t2 (d1 BIT(2), d2 BIT, d3 BIT) ENGINE = NDB; |
| 9 |
CREATE TABLE t3 (a INT PRIMARY KEY, e1 BIT, e2 BIT) ENGINE = NDB; |
| 10 |
CREATE TABLE t4 (f1 BIT, f2 BIT NOT NULL, f3 BIT NOT NULL, f4 BIT NOT NULL, f5 BIT) ENGINE = NDB; |
| 11 |
CREATE TABLE t5 (a INT PRIMARY KEY, g1 BIT(6)) ENGINE = NDB; |
| 12 |
INSERT INTO t1_innodb VALUES (1, 1); |
| 13 |
INSERT INTO t1_ndb VALUES (1, 1); |
| 14 |
INSERT INTO t2 VALUES (3, 1, 1); |
| 15 |
INSERT INTO t3 VALUES (1, 1, 1); |
| 16 |
INSERT INTO t4 VALUES (1, 1, 1, 1, 1); |
| 17 |
INSERT INTO t5 VALUES (1, 63); |
| 18 |
include/sync_slave_sql_with_master.inc |
| 19 |
[connection master] |
| 20 |
UPDATE t1_innodb SET b1 = NULL WHERE b2 = 1; |
| 21 |
UPDATE t1_ndb SET c1 = NULL WHERE c2 = 1; |
| 22 |
UPDATE t2 SET d1 = NULL WHERE d3 = 1; |
| 23 |
UPDATE t3 SET e1 = NULL WHERE a = 1; |
| 24 |
UPDATE t4 SET f1 = NULL, f5 = NULL WHERE f2 = 1; |
| 25 |
UPDATE t5 SET g1 = NULL WHERE a = 1; |
| 26 |
include/sync_slave_sql_with_master.inc |
| 27 |
SELECT * FROM t1_ndb; |
| 28 |
c1 c2 |
| 29 |
NULL |
| 30 |
SELECT * FROM t1_innodb; |
| 31 |
b1 b2 |
| 32 |
NULL |
| 33 |
SELECT * FROM t2; |
| 34 |
d1 d2 d3 |
| 35 |
NULL |
| 36 |
SELECT * FROM t3; |
| 37 |
a e1 e2 |
| 38 |
1 NULL |
| 39 |
SELECT * FROM t4; |
| 40 |
f1 f2 f3 f4 f5 |
| 41 |
NULL NULL |
| 42 |
SELECT * FROM t5; |
| 43 |
a g1 |
| 44 |
1 NULL |
| 45 |
[connection master] |
| 46 |
DELETE FROM t1_innodb WHERE b2 = 1 LIMIT 1; |
| 47 |
include/sync_slave_sql_with_master.inc |
| 48 |
SELECT * FROM t1_innodb; |
| 49 |
b1 b2 |
| 50 |
[connection master] |
| 51 |
DELETE FROM t1_ndb WHERE c2 = 1 LIMIT 1; |
| 52 |
include/sync_slave_sql_with_master.inc |
| 53 |
SELECT * FROM t1_ndb; |
| 54 |
c1 c2 |
| 55 |
[connection master] |
| 56 |
DELETE FROM t2 WHERE d2 = 1 LIMIT 1; |
| 57 |
include/sync_slave_sql_with_master.inc |
| 58 |
SELECT * FROM t2; |
| 59 |
d1 d2 d3 |
| 60 |
[connection master] |
| 61 |
DELETE FROM t3 WHERE a = 1 LIMIT 1; |
| 62 |
include/sync_slave_sql_with_master.inc |
| 63 |
SELECT * FROM t3; |
| 64 |
a e1 e2 |
| 65 |
[connection master] |
| 66 |
DELETE FROM t4 WHERE f2 = 1 LIMIT 1; |
| 67 |
include/sync_slave_sql_with_master.inc |
| 68 |
SELECT * FROM t4; |
| 69 |
f1 f2 f3 f4 f5 |
| 70 |
[connection master] |
| 71 |
DELETE FROM t5 WHERE a = 1 LIMIT 1; |
| 72 |
include/sync_slave_sql_with_master.inc |
| 73 |
SELECT * FROM t5; |
| 74 |
a g1 |
| 75 |
[connection master] |
| 76 |
DROP TABLE t1_innodb; |
| 77 |
DROP TABLE t1_ndb; |
| 78 |
DROP TABLE t2; |
| 79 |
DROP TABLE t3; |
| 80 |
DROP TABLE t4; |
| 81 |
DROP TABLE t5; |
| 82 |
Cleanup |
| 83 |
include/rpl_end.inc |