master的ip为192.168.1.10
slave1的ip为192。168.1.20
slave2的ip为192.168.1.30
首先在三台机上上分别通过yum install mysql mysql-server -y 进行安装mysql
在master配置/etc/my.cnf 如下
vim /etc/my.cnf
[mysqld]
server_id = 1
log-bin=binlog
log-bin-index=binlog.index
后保存退出,并重启Mysql
server mysqld restart
进入mysql进行创建用户
mysql> GRANT replication slave ON *.* TO 'haha'@'192.168.1.20' identified by '123';
mysql> GRANT replication slave ON *.* TO 'hehe'@'192.168.1.30' identified by '123';
flush privileges;
然后再slave1上配置/etc/my.conf
vim /etc/my.conf
server_id = 2
relay_log = /var/lib/mysql/mysql-relay-bin
relay_log_index=/var/lib/mysql/mysql-relay-bin.index
log-bin=binlog
log-slave-updates
保存退出,
cd /var/lib/mysql
rm -fr *
并重启Mysql服务
进入mysql
mysql> change master to master_host='192.168.1.10', master_port=3306, master_user='haha', master_password='123', master_log_file='binlog.000003',master_log_pos=307;
mysql> show slave status \G
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
在slave2上进行配置
vim /etc/my.conf
server_id = 22
relay_log = /var/lib/mysql/mysql-relay-bin
relay_log_index=/var/lib/mysql/mysql-relay-bin.index
保存退出,cd /var/lib/mysql
rm -fr *
server mysqld restart
mysql> change master to master_host='192.168.1.10', master_port=3306, master_user='hehe', master_password='123', master_log_file='binlog.000003',master_log_pos=307;
mysql> start slave;
mysql> show slave status \G
Slave_IO_Running: Yes
Slave_SQL_Running: Yes