????-------------------------------------------
????????????????????????????
????------------------------------------------
????????????????????????????????????????????????
????# ?? B ????????????????????????????λ???
????SHOW MASTER STATUS;
????# ??? A ??????????  (????B??????????????)
????CHANGE MASTER TO MASTER_HOST='192.168.1.101'??MASTER_USER='master_slave'??MASTER_PASSWORD='master_slave123!@#'??MASTER_LOG_FILE='binlog.000001'??MASTER_LOG_POS=106;
????# ???? A ?????????????
????START SLAVE;
????# ???? A B ?????????????????????
????SHOW SLAVE STATUS;SHOW MASTER STATUS;
????# ???? A B ??????
????UNLOCK TABLES;
????# ??????????? A B ???????????????????????
????DROP TABLE IF EXISTS `test`;
????CREATE TABLE `test` (
????`id` int(11) NOT NULL AUTO_INCREMENT??
????`value` varchar(100) DEFAULT '0'??
????PRIMARY KEY (`id`)
????) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
????INSERT INTO `test` VALUES ('1'?? 'Hello');
???????
????1. ????????μ?master.info??????????????л?my.cnf??????????????????????????master.info
????2. my.cnf?е?master??????MySQL 6.0???????????????????????CHANGE MASTER
????3. ???????ignore-db???????do-db?????′????????????????????
????4. ????stop ??????????????????????????????????????????????????
???????????????????
????1. A B ??????????test?? ?????mysql??
??????????????????о??????binlog-do-db=test?? binlog-ignore-db=mysql??replicate-do-db=test??replicate-ignore-db=mysql
????2. A B ???????????test?????????????????′?????????????
??????????????????о??????binlog-do-db=test??replicate-do-db=test
????3. A B ???????????mysql?? ??????????????紴?????????????????
??????????????????о??????binlog-ignore-db=mysql??replicate-ignore-db=mysql
????4. A B ?????????????????????????????????
??????????????????о???????????????