MySQL的主从配置+SpringBoot的MySQL读写分离配置

MySQL的主从复制

---

点击前往查看MySQL的安装

1、主库操作

vim /etc/my.cnf

添加如下配置

log-bin=mysql-bin #[必须]启用二进制日志
server-id=128     #[必须]服务器唯一id

保存后重启MySQL

systemctl restart mysqld
mysql -uroot -pczx123
mysql> grant replication slave on *.* to 'czx'@'%' identified by 'root@czx123';
mysql> flush privileges;
mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000001 |      740 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

主节点别操作，从库slave进行配置

---

如果grant添加用户报错ERROR 1819 (HY000): Your password does not satisfy the current policy requirements，执行下面两个命令即可再添加即可

mysql >  set global validate_password_policy=LOW; #设置密码复杂度为低
mysql > set global validate_password_length=4; #密码长度为4

---

2、从库操作

注意这是另一台子节点的虚拟机的操作

vim /etc/my.cnf

添加如下配置并保存。

server-id=129     #[必须]服务器唯一id

保存成功厚要重启MySQL

systemctl restart mysqld
mysql -uroot -pczx123
mysql> change master to master_host='192.168.64.128',master_user='czx',master_password='root@czx123',master_log_file='mysql-bin.000001',master_log_pos=740;
Query OK, 0 rows affected, 2 warnings (0.09 sec)
# 其中master_host为主库IP地址，master_log_file和master_log_pos为主库执行“show master status;”查找到的
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status;
+----------------+----------------+-------------+-------------+---------------+------------------+---------------------+----------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+--------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------+-----------------------------+------------------+-------------+----------------------------+-----------+---------------------+--------------------------------------------------------+--------------------+-------------+-------------------------+--------------------------+----------------+--------------------+--------------------+-------------------+---------------+----------------------+--------------+--------------------+
| Slave_IO_State | Master_Host    | Master_User | Master_Port | Connect_Retry | Master_Log_File  | Read_Master_Log_Pos | Relay_Log_File             | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Table | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table