![\"\"](\"..\/..\/upload\/2017_03\/170302194240461.png\")
<\/p>\u4e3bip\uff1a192.168.1.1<\/p>
\u4eceip\uff1a192.168.1.2<\/p>
\u4e3b\uff1a#vim? \/etc\/my.cnf<\/p>
? ? ? \u6dfb\u52a0\uff1abinlog-do-db=charlesdb? ? ##\u81ea\u5df1\u521b\u5efa\u7684\u540c\u6b65\u6570\u636e\u5e93\uff0c\u8fd9\u91cc\u662fcharlesdb
? ? ? ? ? ? ? ? binlog-ignore-db=mysql<\/p>
? ? ? \u4fee\u6539\uff1aserver_id=1? ? ? ? ? ? ? ? ? ? ? ? ##server_id\u8981\u4e0d\u540c<\/p>
<\/p>
#service mysqld restart? ? ? ? ? ? ? ? ? ? ? ##\u91cd\u542fMySQL\u670d\u52a1\u4f7f\u914d\u7f6e\u6587\u4ef6\u751f\u6548<\/p>
#mysql -u root -p\u5bc6\u7801<\/p>
>create? database charlesdb;<\/p>
>use mysql<\/p>
>insert into mysql.user(Host,User,Password)? values('localhost','charles',password('redhat'));<\/p>
>grant replication slave on? *.*? to? 'charles'@'192.168.1.2'? identified by? 'redhat';<\/p>
>flush privileges;<\/p>
>show master status;<\/p>
>exit<\/p>
#mysqldump -u root -p charlesdb > ~\/root\/charlesdb.sql<\/p>
\uff1a\u8f93\u5165\u672c\u673a\u5bc6\u7801<\/p>
#scp charlesdb.sql root@192.168.1.2:\/root<\/p>
:yes<\/p>
:1.2\u5bc6\u7801<\/p>
\u4ece\uff1a#vim? \/etc\/my.cnf<\/p>
? ? ? \u6dfb\u52a0\uff1abinlog-do-db=charlesdb? ? ? ? ? ?
? ? ? ? ? ? ? ? binlog-ignore-db=mysql
? ? ? \u4fee\u6539\uff1aserver_id=2<\/p>
![\"\"](\"..\/..\/upload\/2017_03\/170302194240463.png\")
<\/p>
#service mysqld restart<\/p>
#mysql -u root -p\u5bc6\u7801<\/p>
>create database charlesdb;<\/p>
>use charlesdb;<\/p>
>source charleddb.sql;<\/p>
>slave stop;<\/p>
>change master to<\/p>
? ? ? master_host='192.168.1.1',<\/p>
? ? ? master_user='charles',<\/p>
? ? ? master_password='redhat',<\/p>
? ? ? master_log_file='1.1\u4e0a\u7684\u504f\u79fb\u91cf'\uff0c<\/p>
? ? ? master_log_pos=1.1\u4e0a\u7684\u7aef\u53e3\u53f7;<\/p>
>slave start;<\/p>
>show slave status\\G;<\/p>
![\"\"](\"..\/..\/upload\/2017_03\/170302194240462.png\")
<\/p>