mysql Êý¾Ýͬ²½

  Êý¾Ýͬ²½ÎÊÌâÖÕÓÚ½â¾ö£º
תÌû£ºA·þÎñÆ÷£º host 192.168.1.101 port 3306 B·þÎñÆ÷£º host 192.168.1.102 port 3306 1,ÊÚȨÓû§£º A·þÎñÆ÷ mysql>grant replication slave,file on *.* to 'repl9'@'192.168.1.102' identified by '1234569'; Query OK, 0 rows affected (0.01 sec) mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) B·þÎñÆ÷ mysql>grant replication slave,file on *.* to 'repl8'@'192.168.1.101' identified by '1234568'; Query OK, 0 rows affected (0.01 sec) mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) 2,ÅäÖÃÎļþ A·þÎñÆ÷ log-bin=mysql-bin server-id = 1 binlog-do-db=test binlog-ignore-db=mysql replicate-do-db=test replicate-ignore-db=mysql log-slave-updates slave-skip-errors=all sync_binlog=1 auto_increment_increment=2 auto_increment_offset=1 master-host = 192.168.1.102 master-user = repl8 master-password = 1234568 master-port = 3306 B·þÎñÆ÷ log-bin=mysql-bin server-id = 2 binlog-do-db=test binlog-ignore-db=mysql replicate-do-db=test replicate-ignore-db=mysql log-slave-updates slave-skip-errors=all sync_binlog=1 auto_increment_increment=2 auto_increment_offset = 2 master-host = 192.168.1.101 master-user = repl9 master-password = 1234569 master-port = 3306 Æô¶¯·þÎñÆ÷¾ÍokÁË -------------------------------------------------- Q: µ±ÔÚÁíһ̨»úÆ÷ÉϵǼMySQLʱ³öÏÖÈçÏ´íÎó£º ERROR 2003 (HY000): Can't connect to MySQL server on 'x.x.x.x' (111) A: Ô­ÒòÊÇMySQL¿¼Âǵ½°²È«ÒòËØ£¬Ä¬ÈÏÅäÖÃÖ»Èôӱ¾µØµÇ¼ ´ò¿ª /etc/mysql/my.cnf Îļþ£¬ÕÒµ½ bind-address = 127.0.0.1 ÐÞ¸ÄΪ bind-address = 0.0.0.0 ÖØÆômysql : sudo /etc/init.d/mysql restart ======================================== 101 Ôö¼Ó£¬102²»Í¬²½ £¿£¿£¿£¿£¿£¿£¿£¿£¿ mysql -h192.168.1.102 -urepl8 -p1234568 ok 102 Ôö¼Ó£¬101 ͬ²½ mysql -h192.168.1.101 -urepl9 -p1234569 ok ±È½ÏÁ½×éµÄshow slave status\G; 102 Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_Do_DB: test Replicate_Ignore_DB: mysql sudo /etc/init.d/mysql restart sudo service mysql restart ÒÔºó¾Í±ä³É£ºlave_IO_Running: YES ³öÏÖµÄÎÊÌ⣨¶àÖ÷×ÔÔö³¤