stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; DROP DATABASE IF EXISTS tpcb; Warnings: Note 1008 Can't drop database 'tpcb'; database doesn't exist CREATE DATABASE tpcb; CREATE TABLE tpcb.account (id INT, bid INT, balance DECIMAL(10,2), filler CHAR(255), PRIMARY KEY(id))ENGINE='falcon'; USE tpcb; INSERT INTO tpcb.account VALUES (1, 2, 1.2, "FRESH ACCOUNT"); INSERT INTO tpcb.account VALUES (2, 5, 1.2, "FRESH ACCOUNT"); INSERT INTO tpcb.account VALUES (3, 2, 1.2, "FRESH ACCOUNT"); INSERT INTO tpcb.account VALUES (4, 2, 1.2, "FRESH ACCOUNT"); UPDATE tpcb.account SET balance = 3.5 WHERE id = 3; UPDATE tpcb.account SET filler = 'Updated' WHERE id = 2; UPDATE tpcb.account SET balance = 9.2, bid = 21, filler = 'Updated' WHERE id = 4; select "Table on Master:" as ""; Table on Master: select * from tpcb.account; id bid balance filler 1 2 1.20 FRESH ACCOUNT 2 5 1.20 Updated 3 2 3.50 FRESH ACCOUNT 4 21 9.20 Updated select "Table on Slave:" as ""; Table on Slave: select * from tpcb.account; id bid balance filler 1 2 1.20 FRESH ACCOUNT 2 5 1.20 Updated 3 2 3.50 FRESH ACCOUNT 4 21 9.20 Updated