搭建MySQL和Tomcat集群
1、MySQL集群
1.1、MySQL主从复制
vim /etc/my.cnf
- master
server-id=1
log-bin=mysql-bin
log-slave-updates
slave-skip-errors=all
- slave1
server-id=2
log-bin=mysql-bin
log-slave-updates
slave-skip-errors=all
- slave2
server-id=3
log-bin=mysql-bin
log-slave-updates
slave-skip-errors=all
systemctl restart mysqld
mysql -u root -p
show VARIABLES like 'server_id';
show master status;
change master to
master_host='192.168.31.11',
master_user='root',
master_password='123456',
master_log_file='mysql-bin.000001',
master_log_pos=154;
start slave;
stop slave;