Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Cannot Reproduce
-
2.1.9
-
None
-
centos 7.4.1708
Description
maxscale : 2.1.9
centos 7.4.1708
1 core 1G memory
mariadb Galera cluster : Two mariadb in the cluster
maxscale.conf
[maxscale]
|
threads=auto
|
user=maxscale
|
ms_timestamp=1
|
syslog=0
|
maxlog=1
|
log_to_shm=0
|
log_warning=1
|
log_notice=0
|
log_info=0
|
log_debug=0
|
log_augmentation=0
|
logdir=/data/maxscale/logs/trace/
|
datadir=/data/maxscale/data/
|
libdir=/usr/local/maxscale/lib/maxscale/
|
cachedir=/data/maxscale/cache/
|
piddir=/data/maxscale/pid/
|
execdir=/usr/bin/
|
|
|
[server1]
|
type=server
|
address=172.100.10.7
|
port=3306
|
protocol=MySQLBackend
|
serv_weight=3
|
priority=2
|
|
|
[server2]
|
type=server
|
address=172.100.10.6
|
port=3306
|
protocol=MySQLBackend
|
serv_weight=3
|
priority=1
|
|
|
|
|
[Galera Monitor]
|
type=monitor
|
module=galeramon
|
servers=server1,server2
|
user=maxscale
|
passwd=password
|
monitor_interval=10000
|
use_priority = true
|
|
|
[Read-Write Service]
|
type=service
|
router=readwritesplit
|
servers=server1,server2
|
user=maxscale
|
passwd=password
|
max_slave_connections=100%
|
weightby=serv_weight
|
|
|
[MaxAdmin Service]
|
type=service
|
router=cli
|
|
|
[Read-Write Listener]
|
type=listener
|
address = 0.0.0.0
|
service=Read-Write Service
|
protocol=MySQLClient
|
port=4006
|
[MaxAdmin Listener]
|
address = 0.0.0.0
|
type=listener
|
service=MaxAdmin Service
|
protocol=maxscaled
|
port=6603
|
Under normal circumstances ：
# ss -tan|awk 'NR>1{++S[$1]}END{for (a in S) print a,S[a]}'
|
LISTEN 15
|
ESTAB 5371
|
FIN-WAIT-1 8
|
FIN-WAIT-2 904
|
TIME-WAIT 99
|
|
|
|
|
# ss -a|grep 4006|wc -l
|
1555
|
# ss -a|grep 3306|wc -l
|
3111
|
backend：
# mysql -uroot -p -A test -e "show processlist;"|wc -l
|
123
|
See the attachment for abnormal time monitoring
Problems caused by too many links？
When I restart maxscale, it returns to normal
