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 TABLE IF EXISTS TestMe.TestNumberOne;
Warnings:
Note	1051	Unknown table 'TestNumberOne'
DROP DATABASE IF EXISTS TestMe;
Warnings:
Note	1008	Can't drop database 'TestMe'; database doesn't exist
** Master Values ** 
show variables like '%case%';
Variable_name	Value
lower_case_file_system	OFF
lower_case_table_names	0
STOP SLAVE;
** Slave Values **
show variables like '%case%';
Variable_name	Value
lower_case_file_system	OFF
lower_case_table_names	0

** Create Database on Master **
CREATE DATABASE TestMe;
use TestMe;

** Create Tables on Master **
CREATE TABLE TestNumberOne (TestID int AUTO_INCREMENT KEY,
TestChar varchar(10) not null);

** Show Tables on Master **
show tables;
Tables_in_TestMe
TestNumberOne

** Show databases on The Slave **
show databases;
Database
information_schema
cluster
mysql
test

** Start Slave **
slave start;
show databases;
Database
information_schema
TestMe
cluster
mysql
test

** Show databases on The Slave **
show databases;
Database
information_schema
TestMe
cluster
mysql
test

use TestMe;
** Show Tables on Slave **
show tables;
Tables_in_TestMe
TestNumberOne

** Insert Data on Master **

** Select Count from Master **
SELECT COUNT(*) FROM TestNumberOne;
COUNT(*)
20

use TestMe;
** Select Count from slave **
SELECT COUNT(*) FROM TestNumberOne;
COUNT(*)
20

** Insert Data on Master **

** Select Count from Master **
SELECT COUNT(*) FROM TestNumberOne;
COUNT(*)
40

use TestMe;
** Select Count from slave **
SELECT COUNT(*) FROM TestNumberOne;
COUNT(*)
40

DROP TABLE IF EXISTS TestMe.TestNumberOne;
DROP DATABASE IF EXISTS TestMe;