MaxScale Service fails to start
Hi everyone,
I have installed MariaDB (10.4.13) and set up Galera (4-26.4.4-1) on Server A (CentOS 8).
From Server B (Debian 9) I have set up maxscale (2.4.11) and when I try to start it (systemctl start maxscale) the maxscale service fails and the logs show these errors:
--------------------------------------------------------
...
2020-08-28 11:34:26 notice : [MariaDBAuth] [Galera_Service] Loaded 5 MySQL users for listener 'Galera_Listener' from server 'prod_mariadb01' with checksum 0xb9df5159.
2020-08-28 11:34:26 error : Failed to bind on '10.35.0.201:3306': 99, Cannot assign requested address
2020-08-28 11:34:26 error : [Galera_Service] One or more workers failed to listen on '[10.35.0.201]:3306'.
2020-08-28 11:34:26 notice : Service 'Galera_Service' started (2/2)
2020-08-28 11:34:26 error : Failed to start service 'Galera_Service'.
2020-08-28 11:34:26 error : Failed to start all MaxScale services. Exiting.
...
--------------------------------------------------------
and the following is the maxscale.cnf file :
[maxscale]
threads=auto
log_debug=1
[prod_mariadb01]
type=server
address=10.35.0.152
port=3306
protocol=mariadbbackend
priority=1
[Galera_Monitor]
type=monitor
module=galeramon
servers=prod_mariadb01
user=maxscale
password=xxxx
monitor_interval=1000
use_priority=true
[Galera_Service]
type=service
router=readwritesplit
master_accept_reads=true
use_sql_variables_in=master
servers=prod_mariadb01
user=maxscale
password=xxxx
filters=Hint
[MaxAdmin_Service]
type=service
router=cli
[Galera_Listener]
type=listener
service=Galera_Service
protocol=mariadbclient
address=10.35.0.201
port=3306
[MaxAdmin_Listener]
type=listener
service=MaxAdmin_Service
protocol=maxscaled
socket=default
[Hint]
type=filter
module=hintfilter
Answer Answered by Markus Mäkelä in this comment.
The error you received almost always happens because something else is already listening on port 3306. Do you have a MariaDB server already running on the same machine?
