Details
Major Description
maxscale.cnf
[maxscale]
|
threads=auto
|
auto_tune=all
|
users_refresh_time=1m
|
skip_name_resolve=yes
|
admin_host = 0.0.0.0
|
admin_port = 8989
|
admin_secure_gui=false
|
|
|
|
|
[node1]
|
type=server
|
address=ip1
|
protocol=MariaDBBackend
|
port=3306
|
proxy_protocol=yes
|
persistpoolmax=100
|
persistmaxtime=28700s
|
|
|
|
|
[node2]
|
type=server
|
address=ip2
|
protocol=MariaDBBackend
|
port=3306
|
proxy_protocol=yes
|
persistpoolmax=100
|
persistmaxtime=28700s
|
|
|
[node3]
|
type=server
|
address=ip3
|
protocol=MariaDBBackend
|
port=3306
|
proxy_protocol=yes
|
persistpoolmax=100
|
persistmaxtime=28700s
|
|
|
[MariaDB-Monitor]
|
type=monitor
|
module=galeramon
|
servers=node1,node2,node3
|
user=maxscale-user
|
password=maxscale-pass
|
monitor_interval=2s
|
|
|
[Hints]
|
type=filter
|
module=hintfilter
|
|
|
[Galera]
|
type=service
|
router=readconnroute
|
router_options=master,synced,running
|
servers=node1,node2,node3
|
user=maxscale-user
|
password=maxscale-pass
|
enable_root_user=false
|
|
|
[Cluster-Listener]
|
type=listener
|
service=Galera
|
protocol=mariadbprotocol
|
port=3307
|
|
|
[Galera-Split]
|
type=service
|
router=readwritesplit
|
user=maxscale-user
|
password=maxscale-pass
|
servers=node1,node2,node3
|
filters=Hints
|
master_accept_reads=false
|
|
|
transaction_replay=yes
|
transaction_replay_max_size=2
|
transaction_replay_attempts=3
|
transaction_replay_timeout=10s
|
reuse_prepared_statements=yes
|
|
|
lazy_connect=1
|
|
|
[Cluster-SplitListener]
|
type=listener
|
service=Galera-Split
|
protocol=mariadbprotocol
|
port=3306
|
============
Errors on backend
mysql mysqld[120205]: 2025-03-27 17:18:54 2697615951 [Warning] Aborted connection 2697615951 to db: '<dbname>' user: '<user>' host: '<host>' (Got an error reading communication packets)
|
mysql mysqld[120205]: 2025-03-27 17:18:54 2697603315 [Warning] Aborted connection 2697603315 to db: '<dbname>' user: '<user>' host: '<host>' (Got an error reading communication packets)
|
mysql mysqld[120205]: 2025-03-27 17:18:54 2697601337 [Warning] Aborted connection 2697601337 to db: '<dbname>' user: '<user>' host: '<host>' (Got an error reading communication packets)
|
mysql mysqld[120205]: 2025-03-27 17:18:54 2697660869 [Warning] Aborted connection 2697660869 to db: '<dbname>' user: '<user>' host: '<host>' (Got an error reading communication packets)
|
mysql mysqld[120205]: 2025-03-27 17:18:54 2697601215 [Warning] Aborted connection 2697601215 to db: '<dbname>' user: '<user>' host: '<host>' (Got an error reading communication packets)
|
mysql mysqld[120205]: 2025-03-27 17:20:01 2697702609 [Warning] Aborted connection 2697702609 to db: '<dbname>' user: '<user>' host: '<host>' (Got an error reading communication packets)
|
mysql mysqld[120205]: 2025-03-27 17:20:02 2697702639 [Warning] Aborted connection 2697702639 to db: '<dbname>' user: '<user>' host: '<host>' (Got an error reading communication packets)
|
mysql mysqld[120205]: 2025-03-27 17:21:04 2697709112 [Warning] Aborted connection 2697709112 to db: '<dbname>' user: '<user>' host: '<host>' (Got an error writing communication packets)
|
================
Wihtout persistpool options in [SERVER] section maxscale.cnf, errors do not appear on the backend.