??????????????

????????????????
???????????????????????????????д??????????? ???????????????￡?
????1).Slave?????IO??????????Master???????????????????????λ?????????????????????????????
????2).Master?????????Slave??IO????????????????????IO??????????????????????????λ???????????????????Slave ??IO?????????????г?????????????????????????????η????????????Master???bin-log????????????bin-log??λ???
????3).Slave??IO?????????????????????????????????????Slave???relay-log????????????????????Master??? bin-log?????????λ?ü????master-info????У??????????ζ??????????????????Master“??????????bin-log?????λ???????????????????????”??
????4).Slave??Sql??????relay-log????????????????????????relay-log??????????Master??????????????Щ????е????????????????С?
????????????
????????????CentOS6.3_x64
????????????master??192.168.0.202
???????????slave??192.168.0.203
???????mysql???????
????1????????mysql???汾???
????????????? mysql-5.5.30.tar.gz ???????…
????2?????master??slave??????
????master???????????
????vi /usr/local/mysql/etc/my.cnf
????[mysqld]
????server-id=202
????#???÷???????id???????1??????????ip????Σ?slave????203
????log-bin=mysql-bin
????# ????????????
????binlog-ignore-db = mysql??information_schema
????#????д??binlog???
????slave???????????
????vi /usr/local/mysql/etc/my.cnf
????[mysqld]
????server-id=203
????replicate-do-db = abc
????#????abc??
????slave-skip-errors = all
????#???????????????д???
????3???????????????mysql
????/etc/init.d/mysqld restart
????4?????????????????????????slave
????mysql> mysql -u root -p123.com
????mysql> GRANT REPLICATION SLAVE ON *.* to ‘sync’@‘192.168.1.2’ identified by ‘1234.com’;
????#replication:????