2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
CREATE TABLE t1 (a int key, b int) ENGINE=NDB;
12
INSERT INTO t1 VALUES (1,2);
13
INSERT INTO t1 VALUES (2,3);
15
CHANGE MASTER TO MASTER_HOST="127.0.0.1",MASTER_PORT=SLAVE_PORT,MASTER_USER="root";
21
Master_Port SLAVE_PORT
23
Master_Log_File slave-bin.000001
27
Relay_Master_Log_File slave-bin.000001
33
Replicate_Ignore_Table
34
Replicate_Wild_Do_Table
35
Replicate_Wild_Ignore_Table
50
Seconds_Behind_Master #
51
Master_SSL_Verify_Server_Cert No
56
SELECT * FROM t1 ORDER BY a;
62
SELECT * FROM t1 ORDER BY a;
70
Master_Port MASTER_PORT
72
Master_Log_File master-bin.000001
76
Relay_Master_Log_File master-bin.000001
82
Replicate_Ignore_Table
83
Replicate_Wild_Do_Table
84
Replicate_Wild_Ignore_Table
99
Seconds_Behind_Master #
100
Master_SSL_Verify_Server_Cert No