Ö÷´Ó¸´ÖƲ»¾ÍÊǶą̀·þÎñÆ÷Â£¬Ò»¸ö¸Ä±äÁíÒ»¸öÒ²¸Ä±äÀ²£¬ÄÚÈÝÆäʵ¶¼Ò»Ñù£¡
ÔÀí£º
¶ÔÊý¾Ý¿â½øÐвÙ×÷»áÉú³ÉÒ»¸öÎļþ£¬binlog£¨¶þ½øÖÆÎļþ£©£¬´Ó·þÎñÆ÷ÅäÖÃrelaylogÎļþ£¬ÓÃÀ´¶ÁÈ¡masterÀïÃæbinlog£¨ÓбØÒª¿ªÆôbinlog£¬Ï൱ÓÚ±¸·Ý£©£¬µ±È»ÒªÓÐȨÏÞ¶ÁÈ¡ÊÇ°É£¬Õâ¾ÍÐèÒªÓõ½ÉϴεÄȨÏÞÅäÖÃÀ²£¡ºÍÆÕͨµÇ¼ûʲô²î±ð¡£
Ö÷×ö³öʲô¶¯×÷£¬´ÓÒ²×ö³öʲô¶¯×÷¡£
Õâʱ¾ÍÐèҪעÒâÖ÷ÅäÖÃÎļþÀïÃæbinlog-format £¬ÀïÃæ值Ϊrow£¬¶þ½øÖƼǼÊÇ´ÅÅ̱仯£»值Ϊstatusment£¬´ËʱÈç¹ûÊÇÖ´ÐÐÁËupdateÓï¾ä£¬´Ó·þÎñÆ÷Ò²»á¼Ç¼updateÓï¾ä
Èç¹ûÓï¾ä³¤¶ø´ÅÅ̱仯С£¬Ò×ÓÃrow
Èç¹ûÓï¾äÉÙ¶ø´ÅÅ̱仯´ó£¬Ò×ÓÃstatusment
»¹ÓÐÒ»ÖÖmixed£¬´ËʱÓÉϵͳ·ÖÎö¾ö¶¨
1 ´ò¿ªÖ÷·þÎñÆ÷ÀïÃæÅäÖÃÎļþ
2 ÅäÖôӷþÎñÆ÷
3·ÖÅäȨÏÞ£¬²¢²é¿´master״̬¡£¼ÇÏÂFILE¼°PZ†·Ÿ"http://www.Bkjia.com/kf/ware/vc/" target="_blank" class="keylink">vc2l0aW9utcQmIzIwNTQwO6Os1eK49tTauvPD5sXk1sO007f+zvHG97XEyrG68tKq08O1vTwvcD4KPHA+PGltZyBzcmM9"http://www.2cto.com/uploadfile/Collfiles/20141114/2014111409192627.png" alt="\">
4 ´Ó·þÎñÆ÷ÉÏͨ¹ýÖ¸¶¨Òª¸´ÖƵÄÖ÷·þÎñÆ÷
mysql>change master to aster_host="192.168.1.201',master_user='repl',master_password='q123456',
master_log_file='mysql-bin.,000001',master_log_pos=106;
5 ¼ì²é´Ó·þÎñÆ÷µÄ¸´ÖÆ״̬
Slave_IO_Running: Yes //´Ë״̬±ØÐëYES
Slave_SQL_Running: Yes //´Ë״̬±ØÐëYES
¾Í´ËokÁË£¬ºÜ¼òµ¥£¡
ËùνµÄ¶Áд·ÖÀ룬¾ÍÊÇsqlÓï¾äµÄÅжÏÀ²£¬Í¨¹ý³ÌÐò¾Í¿ÉÒÔʵÏÖ¡£