Skip to content

Instantly share code, notes, and snippets.

@jayjanssen
Created July 10, 2015 12:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jayjanssen/bcdc33f8ae52f4ecfa69 to your computer and use it in GitHub Desktop.
Save jayjanssen/bcdc33f8ae52f4ecfa69 to your computer and use it in GitHub Desktop.
MaxScale + PXC with RW splitting
[maxscale]
threads=4
[PXC Monitor]
type=monitor
module=galeramon
servers=node1,node2,node3
user=maxscale
passwd=maxscale
monitor_interval=1000
disable_master_failback=1
[Reads Router]
type=service
router=readconnroute
servers=node1,node2,node3
user=maxscale
passwd=maxscale
router_options=synced
[RW Split Router]
type=service
router=readwritesplit
servers=node1,node2,node3
user=maxscale
passwd=maxscale
router_options=synced
[Debug Interface]
type=service
router=debugcli
[CLI]
type=service
router=cli
[Read Connection Listener]
type=listener
service=Reads Router
protocol=MySQLClient
port=4306
[RW Split Listener]
type=listener
service=RW Split Router
protocol=MySQLClient
port=5306
#socket=/tmp/rwsplit.sock
[Debug Listener]
type=listener
service=Debug Interface
protocol=telnetd
#address=127.0.0.1
port=4442
[CLI Listener]
type=listener
service=CLI
protocol=maxscaled
#address=localhost
port=6603
[node1]
type=server
address=172.28.128.3
port=3306
protocol=MySQLBackend
[node2]
type=server
address=172.28.128.4
port=3306
protocol=MySQLBackend
[node3]
type=server
address=172.28.128.5
port=3306
protocol=MySQLBackend
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment