# 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