一.优点
减缓数据库服务器压力
二.步骤:
1.安装软件 2.修改配置文件 授权用户 3.起服务 4.51 52 主从结构
三.配置
#rpm -ivh maxscale… #vim /etc/maxscale.cnf Threads=auto [server1] 192.168.4.51 Port=3306 [server2] 192.168.4.52 Port=3306 Service=server1, server2 User=maxscalemon Password=123qqq…A User=maxscalerouter Password=123qqq…A #[read-lony] Read-write port=4006 Admin port=4016 51 mysql>grant replication slave,replication client on . to maxscalemon@”%” identified by “123qqq…A”; mysql>garnt select on mysql.* to maxscalerouter@”%” identified by “123qqq…A”; #maxslace -f /etc/maxslace.cnf #maxadmin -uadmin -pmariadb -P4016 mysql>craete database gamedb; mysql>craete table gamedb.t1(id int); mysql>grant select,insert on gamedb.* to yaya@”%” identified by “123qqq…A”; #mysql -h192.168.4.57 -p4000 -uyaya -p123qqq…A 52>insert into gamedb.t1 values(100); 如果yaya能看见就证明读写分离成功
