Forum Discussion
Lobak_187587
Nimbostratus
Jun 14, 2016monitor for mariadb cluster
Mariadb 10 is using galera for multi-master setup
Before this I'm using haproxy installed in front of nginx like this article http://galeracluster.com/documentation-webpages/haproxy.html
How do ...
Yann_Desmarest
Cirrus
Jun 14, 2016Hi,
Yes, just see below my lab configuration
ltm virtual vs_mariadb {
destination 192.168.1.10:mysql
ip-protocol tcp
mask 255.255.255.255
persist {
source_addr {
default yes
}
}
pool pool_smtp
profiles {
fastL4 { }
}
source 0.0.0.0/0
source-address-translation {
type automap
}
translate-address enabled
translate-port enabled
vs-index 4
}
ltm pool pool_mariadb {
members {
192.168.1.1:mysql {
address 192.168.1.1
session monitor-enabled
state down
}
192.168.1.2:mysql {
address 192.168.1.2
session monitor-enabled
state down
}
192.168.1.3:mysql {
address 192.168.1.3
session monitor-enabled
state down
}
}
monitor tcp_half_open
}
You can also change the default tcp monitor by a custom mysql monitor :
ltm monitor mysql monitor_mariadb {
count 0
debug no
defaults-from mysql
destination *:*
interval 30
recv none
send none
time-until-up 0
timeout 91
username haproxy
}
Help guide the future of your DevCentral Community!
What tools do you use to collaborate? (1min - anonymous)Recent Discussions
Related Content
DevCentral Quicklinks
* Getting Started on DevCentral
* Community Guidelines
* Community Terms of Use / EULA
* Community Ranking Explained
* Community Resources
* Contact the DevCentral Team
* Update MFA on account.f5.com
Discover DevCentral Connects