mysql>selectversion();+-----------+|version()|+-----------+|5.5.20|+-----------+1rowinset(0.00sec)[root@manis-serverinit.d]#vim/etc/my.cnf[mysql]#replicationserver-id=2lo...
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.20 |
+-----------+
1 row in set (0.00 sec)
[root@manis-server init.d]# vim /etc/my.cnf
[mysql]
#replication
server-id = 2
log-bin = /var/log/mysql-bin.log
master-host = 172.0.0.1
master-user = replication
master-password = mysqlsync
master-port = 3306
master-connect-retry = 60
binlog-do-db = xw_sdc_db,minas
replicate-do-db = xw_sdc_db,minas
mysql> grant replication slave on *.* to 'replication'@'172.0.0.1' identified by 'mysqlsync';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
[root@manis-server init.d]# ./mysql restart
Shutting down MySQL.... SUCCESS!
Starting MySQL.. SUCCESS!
[root@manis-server init.d]#
mysql> flush tables with read lock;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 3
Current database: xw_sdc_db
Query OK, 0 rows affected (0.04 sec)
mysql> show master status \G
Empty set (0.02 sec)
mysql> unlock tables;
Query OK, 0 rows affected (0.00 sec)
mysql> change master to master_host='172.0.0.1', master_user='replication', master_password='mysqlsync', master_log_file='binlog.000001', master_log_pos=1;
Query OK, 0 rows affected (0.43 sec)
mysql> start slave;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO
我要怎么配置server为slave?请大侠指点,谢谢!
展开