Skip to content

Instantly share code, notes, and snippets.

@osheroff
Created February 26, 2015 23:26
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 osheroff/aa933553b045cb68a881 to your computer and use it in GitHub Desktop.
Save osheroff/aa933553b045cb68a881 to your computer and use it in GitHub Desktop.
[maxscale]
threads=4
log_debug=1
[top service]
type=service
router=readconnroute
servers=master,slave
user=admin
passwd=123456
filters=shards
[top service listener]
type=listener
service=top service
protocol=MySQLClient
port=4406
[shards]
type=filter
module=shardfilter
shard_services=shard_2,shard_1
[shard_1]
type=service
user=admin
passwd=123456
servers=shard master,shard slave
router=readwritesplit
shards=20,21
[shard_2]
type=service
user=admin
passwd=123456
servers=master,slave
router=readwritesplit
shards=30,11
[test service monitor]
type=monitor
module=mysqlmon
servers=master,slave,shard master,shard slave
user=admin
passwd=123456
monitor_interval=8000
backend_connect_timeout=3
backend_read_timeout=1
backend_write_timeout=2
detect_replication_lag=0
detect_stale_master=0
[master]
type=server
address=mysql-account-master
port=3306
protocol=MySQLBackend
[slave]
type=server
address=mysql-account-slave
port=3307
protocol=MySQLBackend
[shard master]
type=server
address=mysql-shard-master
port=3316
protocol=MySQLBackend
[shard slave]
type=server
address=mysql-shard-slave
port=3317
protocol=MySQLBackend
shard_ids=55
[Debug Service]
type=service
router=debugcli
[Debug Listener]
type=listener
service=Debug Service
protocol=telnetd
port=4442
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment