Maxscale问题
来源:

爱学习的程序员2019
2016-09-07
老师您好,在练习使用Maxscale过程中,执行如下命令:
[root@host12 etc]# maxscale --config=/etc/maxscale.cnf Syslog logging is disabled.
然后执行:
[root@host12 ~]# maxadmin --user=admin --password=mariadb MaxScale> list servers Servers. -------------------+-----------------+-------+-------------+-------------------- Server | Address | Port | Connections | Status -------------------+-----------------+-------+-------------+-------------------- server1 | 192.168.1.107 | 3306 | 0 | Auth Error, Down server2 | 192.168.1.111 | 3306 | 0 | Auth Error, Down server3 | 192.168.1.112 | 3306 | 0 | Auth Error, Down -------------------+-----------------+-------+-------------+--------------------
请教一下,上表中"Auth Error, Down"是什么意思?我的三台MySQL都是运行着的,没有Down,为何会提示Down呢?
我的配置文件如下:
[maxscale] threads=auto #开启线程个数,默认为1.设置为auto会同cpu核数相同 ms_timestamp=1 #timestamp精度 syslog=1 #将日志写入到syslog中 maxlog=1 #将日志写入到maxscale的日志文件中 log_to_shm=0 #不将日志写入到共享缓存中,开启debug模式时可打开加快速度 log_warning=1 #记录告警信息 log_notice=1 #记录notice log_info=1 #记录info log_debug=0 #不打开debug模式 log_augmentation=1 #日志递增 #相关目录设置 logdir=/maxscale/log/ datadir=/maxscale/data/ libdir=/usr/lib64/maxscale/ cachedir=/maxscale/cache/ piddir=/maxscale/pid/ execdir=/usr/bin/ [MySQL Monitor] type=monitor module=mysqlmon servers=server1,server2,server3 user=scalemon passwd=654321 monitor_interval=1000 #backend_connect_timeout= #backend_read_timeout= #backend_write_timeout= #detect_replication_lag= #detect_stale_master= #[qla] #type=filter #module=qlafilter #options=/tmp/QueryLog #[fetch] #type=filter #module=regexfilter #match=fetch #replace=select #[hint] #type=filter #module=hintfilter #[Read Connection Router] #type=service #router=readconnroute #servers=server1,server2,server3 #user=myuser #passwd=mypwd #router_options=slave [RW Split Router] type=service router=readwritesplit servers=server1,server2,server3 user=maxscale passwd=654321 max_slave_connections=100% #[Debug Interface] #type=service #router=debugcli [CLI] type=service router=cli #[Read Connection Listener] #type=listener #service=Read Connection Router #protocol=MySQLClient #address=192.168.100.102 #port=4008 #socket=/var/lib/maxscale/readconn.sock [RW Split Listener] type=listener service=RW Split Router protocol=MySQLClient port=4006 #socket=/var/lib/maxscale/rwsplit.sock # 读写分离端口,应用连接这个端口 # #[Debug Listener] #type=listener #service=Debug Interface #protocol=telnetd #address=127.0.0.1 #port=4442 [CLI Listener] type=listener service=CLI protocol=maxscaled port=6603 # MaxScale后台管理端口 [server1] type=server address=192.168.1.107 port=3306 protocol=MySQLBackend [server2] type=server address=192.168.1.111 port=3306 protocol=MySQLBackend [server3] type=server address=192.168.1.112 port=3306 protocol=MySQLBackend
劳烦老师帮忙解答一下,多谢!
写回答
2回答
-
sqlercn
2016-09-07
看一下maxscale和数据库之间的权限是否有问题,在做测试时最好按课程中的步骤来设置相关权限。
00 -
宇晨PHP培训
2017-05-17
[MySQL Monitor]
type=monitor
module=mysqlmon
servers=server1,server2
user=scalemon
passwd=123456
monitor_interval=10000
这里用户名和密码的问题你修改为 root 的账户和密码就可以了
00
相似问题