×÷Õß: juanbic
2008-10-11 00:09:10
mysql·þÎñÆ÷µÄÖ÷´ÓÅäÖ㬱¾À´ÊÇÒ»¼þºÜ¼òµ¥µÄÊÂÇ飬ÎÞÄβ»ÊÇ´ÓÁ㿪ʼ£¬×ÜÊÇÔÚ±ðÈËÒѾ°²×°ºÃµÄmysql·þÎñÆ÷Ö®ÉÏ £¬Õâ¾Í»áÇ£³¶µ½£¬mysqlµÄ°æ±¾£¬Æô¶¯Îļþ£¬µÈһЩÎÊÌâ¡£
²»¹ýû¹Øϵ£¬ÏÈÎÊÇå³þÁ½µã
1¡¢mysqlÅäÖÃÎļþmy.cnfµÄλÖÃ
2¡¢ÈçºÎÆô¶¯¡¢Í£Ö¹mysql£¬ÕÒºÃÆô¶¯Îļþ
¼ÙÉèÓÐÁ½Ì¨»úÆ÷£¬ÒѾ°²×°ºÃÁËmysql£¨¾¡Á¿Í¬°æ±¾£¬ÇÒÁ½Ì¨»úÆ÷ͬһÍøÂ磬¿ÉÒÔpingͨ£©
ÓÐÅóÓÑ˵£º¡°´Ó·þÎñÆ÷£¬²»ÄܵÍÓÚÖ÷·þÎñÆ÷µÄ°æ±¾¡±£¬²»¹ýÎÒÊǵÍÓڵģ¬Ã»ÓгöÏÖÎÊÌâ¡£
Ö÷»úA: 192.168.1.100
´Ó»úB:192.168.1.101
¿ÉÒÔÓжą̀´Ó»ú
1¡¢ÏȵǼÖ÷»ú A
mysql>GRANT REPLICATION SLAVE ON *.* TO ¡®backup¡¯@¡¯192.168.1.101¡® IDENTIFIED BY ¡®123456¡¯;
¸³Óè´Ó»úȨÏÞ£¬Óжą̀´Ô»ú£¬¾ÍÖ´Ðжà´Î
2¡¢ ´ò¿ªÖ÷»úAµÄmy.cnf£¬ÊäÈë
server-id = 1 #Ö÷»ú±êʾ£¬ÕûÊý
log_bin = /var/log/mysql/mysql-bin.log #È·±£´ËÎļþ¿Éд
read-only =0 #Ö÷»ú£¬¶Áд¶¼¿ÉÒÔ
binlog-do-db =test #ÐèÒª±¸·ÝÊý¾Ý£¬¶à¸öд¶àÐÐ
binlog-ignore-db=mysql #²»ÐèÒª±¸·ÝµÄÊý¾Ý¿â£¬¶à¸öд¶àÐÐ
3¡¢´ò¿ª´Ó»úBµÄmy.cnf£¬ÊäÈë
server-id = 2
log_bin = /var/log/mysql/mysql-bin.log
master-host =192.168.1.100
master-user =backup
master-pass =123456
master-port =3306
master-connect-retry=60 #Èç¹û´Ó·þÎñÆ÷·¢ÏÖÖ÷·þÎñÆ÷¶Ïµô£¬ÖØÐÂÁ¬½ÓµÄʱ¼ä²î(Ãë)
replicate-do-db =test #Ö»¸´ÖÆij¸ö¿â
replicate-ignore-db=mysql #²»¸´ÖÆij¸ö¿â
4¡¢Í¬²½Êý¾Ý¿â
ÓжàÖÖ·½·¨£¬ÎÒ˵×µÄÒ»ÖÖ£¬ÏÈmysqldumpµ¼³öÖ÷»úAµÄÊý¾ÝtestΪ test.sql
È»ºóÔÚ£¬´Ó»úBÉϽ¨Á¢Êý¾Ý¿âtest£¬mysqlµ¼Èë test.sqlµ½test¿âÖÐ
5¡¢ÏÈÖØÆôÖ÷»úAµÄmysql£¬ÔÙÖØÆô´Ó»úBµÄmysql
6¡¢ÑéÖ¤
ÔÚÖ÷»úAÖУ¬mysql>show master status\G;
ÔÚ´Ó»úBÖУ¬mysql>show slave status\G;
ÄÜ¿´µ½´óÖÂÕâЩÄÚÈÝ
File: mysql-bin.000001
Position: 1374
Binlog_Do_DB: test
Binlog_Ignore_DB: mysql
¿ÉÒÔÔÚÖ÷»úAÖУ¬×öһЩINSERT, UPDATE, DELETE ²Ù×÷£¬¿´¿´Ö÷»úBÖУ¬ÊÇ·ñÒѾ±»Ð޸ġ£