Skip to content

Instantly share code, notes, and snippets.

@dome
Created July 1, 2017 06:52
Show Gist options
  • Save dome/7bf2974902128194e3cbf27c4d82f792 to your computer and use it in GitHub Desktop.
Save dome/7bf2974902128194e3cbf27c4d82f792 to your computer and use it in GitHub Desktop.
maxscale]
threads=4
[Galera Monitor]
type=monitor
module=galeramon
servers=svr_10095,svr_10096,svr_10097
user=maxadmin
passwd=jkdskjsdfkjlfdskjdsfkjsdjkf
monitor_interval=10000
disable_master_failback=1
[MyCache]
type=filter
module=cache
storage=storage_inmemory
soft_ttl=30
hard_ttl=45
cached_data=shared
max_size=500Mi
selects=assume_cacheable
[fetch]
type=filter
module=regexfilter
match=fetch
replace=select
[RW]
type=service
router=readwritesplit
servers=svr_10095,svr_10096,svr_10097
user=maxadmin
passwd=ioldskjlsdfjksdfjksdfjlksdfjksdfjklsdf
max_slave_connections=100%
router_options=slave_selection_criteria=LEAST_CURRENT_OPERATIONS
[RR]
type=service
router=readconnroute
router_options=synced
servers=svr_10095,svr_10096,svr_10097
user=maxadmin
passwd=kjdsjklsdfjksdfkjlsdfjksdfjksdfjksdfkl
filters=MyCache
[DebugInterface]
type=service
router=debugcli
[CLI]
type=service
router=cli
[RWlistener3308]
type=listener
service=RW
protocol=MySQLClient
address=0.0.0.0
port=3308
[RWlistener3309]
type=listener
service=RR
protocol=MySQLClient
address=0.0.0.0
port=3309
[RWlistener]
type=listener
service=RW
protocol=MySQLClient
address=0.0.0.0
port=4008
[RRlistener]
type=listener
service=RR
protocol=MySQLClient
address=0.0.0.0
port=4006
[Debug Listener]
type=listener
service=DebugInterface
protocol=telnetd
address=127.0.0.1
port=4442
[CLI Listener]
type=listener
service=CLI
protocol=maxscaled
address=127.0.0.1
port=6603
[svr_10095]
type=server
address=10.0.9.5
port=3306
protocol=MySQLBackend
[svr_10096]
type=server
address=10.0.9.6
port=3306
protocol=MySQLBackend
[svr_10097]
type=server
address=10.0.9.7
port=3306
protocol=MySQLBackend
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment