mysql 一直比较菜,今天尝试配置一个主从复制的集群。
环境:CentOS 6.3 x64
- # yum install mysql-server
- # cat /usr/share/mysql/my-large.cnf > /etc/my.cnf
- server-id = 1
- log-bin=mysql-bin
- sync_binlog = 1
- relay-log=mysql-master-relay-bin
- binlog-do-db=Syslog
- binlog_ignore_db=mysql
- server-id = 2
- log-bin=mysql-bin
- sync_binlog = 1
- relay-log=mysql-slave-relay-bin
- binlog-do-db=Syslog
- binlog_ignore_db=mysql
- read-only = 1
- # service mysqld restart
- # mysql_secure_installation
- [root@mysql-master ~]# mysql -u root -p
- mysql> GRANT REPLICATION SLAVE ON *.* TO 'joe'@'%' IDENTIFIED BY 'secret';
- mysql> FLUSH PRIVILEGES;
- [root@mysql-master ~]# mysqldump -u root --all-databases >master.sql
- [root@mysql-master ~]# scp master.sql root@192.168.1.42:/root/
- [root@mysql-slave ~]#mysql -u root -p
- mysql>STOP SLAVE;
- mysql>quit
- [root@mysql-slave ~]#mysql -u root -p < master.sql
- [root@mysql-slave ~]#mysql -u root -p
- mysql>START SLAVE;
- mysql> CHANGE MASTER TO
- MASTER_HOST='192.168.1.41',
- MASTER_USER='joe',
- MASTER_PASSWORD='secret',
- MASTER_PORT=3306,
- MASTER_CONNECT_RETRY = 10
- mysql>START SLAVE;
- mysql> SHOW SLAVE STATUS;
- mysql> SHOW PROCESSLIST;
- mysql> show master status;
- mysql> SHOW PROCESSLIST;
- # yum install rsyslog-mysql
- # cd /usr/share/doc/rsyslog-mysql-5.8.10/
- # mysql -u root -p <createDB.sql
注:最后一步尚未亲自验证。