` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL DEFAULT '',
`creatime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
2. 插入数据
Insert into web_user2 (`name`) values ('first'),('test'),('showb'),('blood');
Select * from `web_user2`;
3. 进入Slave查看是否同步正常
Show tables;
Select * from web_user;
4. 在master的控制台上查看复制的事件-Binlog events
Flush logs;
Show binlog events;
日志比较长，这里只截取了前两条：
htmlhttp://blog.itpub.net/7607759/viewspace-719707/