32.3.3 配置ProxySQL读写分离

32.3.3　配置ProxySQL读写分离

1．创建MySQL用户

在binghe151服务器的主库上创建ProxySQL连接MySQL的用户信息和监控MySQL的用户信息。

---

mysql> CREATE USER 'proxysql'@'192.168.175.153' IDENTIFIED BY 'proxysql123456'; 
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER 'proxysql'@'192.168.175.153' IDENTIFIED WITH mysql_native_password BY 'proxysql123456';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL ON *.* TO 'proxysql'@'192.168.175.153';      
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE USER 'monitor'@'%' IDENTIFIED BY 'monitor123456';
Query OK, 0 rows affected (0.10 se