Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
1.4.1
-
None
Description
Hi,
I have setup a 4+1(unweighted backup ndoe)+1 arbitrator galera cluster and MaxScale with a readconnroute router. When I execute SELECT @@hostname it always gives me the master.
Any idea what I did wrong, is there a bug?
# Generated by OceanDBA Configurator 0.5 Date:2016-04-13.
|
# https://www.oceandba.com/configurator/
|
#
|
# The configuration file is available at the following URL:
|
# https://www.oceandba.com/configurator/dl/genconf/0001-0afb650a-570e0e7e-ce5a-de71bb52/maxscale.cnf
|
#
|
# Copy the content in /etc/maxscale.cnf or any preferred location.
|
# Create maxscale user and monitoring user in your databases
|
# Default maxadmin password is: mariadb
|
# Logs can be found in /var/log/maxscale
|
#
|
[maxscale]
|
threads=4
|
|
[Galera Monitor]
|
servers=db01,db02,db03,db04
|
type=monitor
|
module=galeramon
|
user=mariadb_monitor
|
passwd=monitor_pass
|
monitor_interval=1000
|
available_when_donor=1
|
# disable_master_failback=0
|
|
[Master Connection Router]
|
servers=db01,db02,db03,db04
|
type=service
|
router=readconnroute
|
localhost_match_wildcard_host=1
|
user=maxscale_user
|
passwd=maxscale_pass
|
router_options=master
|
|
[Master Connection Listener]
|
type=listener
|
service=Master Connection Router
|
protocol=MySQLClient
|
port=3309
|
|
[Slave Connection Router]
|
servers=db01,db02,db03,db04
|
type=service
|
router=readconnroute
|
localhost_match_wildcard_host=1
|
user=maxscale_user
|
passwd=maxscale_pass
|
router_options=slave
|
|
[Slave Connection Listener]
|
type=listener
|
service=Slave Connection Router
|
protocol=MySQLClient
|
port=3312
|
|
[RW Split Router]
|
servers=db01,db02,db03,db04
|
type=service
|
router=readwritesplit
|
localhost_match_wildcard_host=1
|
user=maxscale_user
|
passwd=maxscale_pass
|
max_slave_connections=100%
|
router_options=master_accept_reads=0,slave_selection_criteria=LEAST_GLOBAL_CONNECTIONS
|
disable_sescmd_history=1
|
|
[RW Split Listener]
|
type=listener
|
service=RW Split Router
|
protocol=MySQLClient
|
port=3310
|
|
[CLI]
|
type=service
|
router=cli
|
|
[CLI Listener]
|
type=listener
|
service=CLI
|
protocol=maxscaled
|
port=6603
|
address=127.0.0.1
|
|
[db01]
|
type=server
|
address=db01
|
protocol=MySQLBackend
|
port=3306
|
|
[db02]
|
type=server
|
address=db02
|
protocol=MySQLBackend
|
port=3306
|
|
[db03]
|
type=server
|
address=db03
|
protocol=MySQLBackend
|
port=3306
|
|
[db04]
|
type=server
|
address=db04
|
protocol=MySQLBackend
|
port=3306
|