江苏龙网

  1. 主页 > 生活百科 > >

MaxScale 关于Linux下MySQL主备集群负载均衡之读写分离( 八 )

读写分离

┌──[root@vms155.liruilongs.github.io]-[~]└─$mysql -h192.168.26.152 -P4006 -uliruilong -pliruilong -e'use liruilong_db;insert into user values(152,now());'┌──[root@vms155.liruilongs.github.io]-[~]└─$mysql -h192.168.26.153 -uliruilong -pliruilong -e'use liruilong_db;select * from user;'| id | create_date || 1 | 2022-09-29 00:22:36 || 1 | 2022-09-29 11:08:38 || 1 | 2022-09-29 13:43:09 || 1 | 2022-09-29 13:51:33 || 1 | 2022-09-29 13:54:41 || 2 | 2022-09-30 13:29:59 || 152 | 2022-09-30 13:34:26 |┌──[root@vms155.liruilongs.github.io]-[~]└─$mysql -h192.168.26.154 -uliruilong -pliruilong -e'use liruilong_db;select * from user;'| id | create_date || 1 | 2022-09-29 00:22:36 || 1 | 2022-09-29 11:08:38 || 1 | 2022-09-29 13:43:09 || 1 | 2022-09-29 13:51:33 || 1 | 2022-09-29 13:54:41 || 2 | 2022-09-30 13:29:59 || 154 | 2022-09-30 13:32:18 || 152 | 2022-09-30 13:34:26 |┌──[root@vms155.liruilongs.github.io]-[~]└─$博文参考
《高性能Mysql》第三版(High Performance MySQL,Third Edition)
https://mariadb.com/docs/deploy/topologies/primary-replica/enterprise-server-10-6/




推荐阅读


上一篇：Macbook同时访问内外网

下一篇：聊聊软件开发，Java介绍和运行机制