Author: @Carsten Revision: v1.0 Tested with: Icinga 2 v2.10.2-1 MariaDB 10.3.10 Table of Contents Galera Cluster for IDO-Mysql and more Requirements SELinux & Firewall Nodes Install & configure Galera Cluster Enable Mariadb Repository Install MariaDb & Galera cluster filesets Firstime star…

HAProxy for IDO-MySQL (or more) HAProxy will keep an eye on which MariaDB node is up and can be connected for you. We can also do a litle manual load balancing for connectios from Icingaweb2, Director, Grafana etc. We want to keep connections as short (or fast) as possible, so from each HAProxy we…

This is just awesome! I was preparing something very similar in most of the parts. Deviations would be: everything is hosted at DigitalOcean and I use keepalived to trigger a failover of the floating IP additional vrrp_scripts to do a mysql query (basically functional check of haproxy & a get to …

Howtos are always opinionated, and it doesn’t hurt to have more of them following different setup requirements. I’d appreciate yours too :slight_smile: Cheers, Michael

Just make sure that round robin is used for read queries mostly and stick write queries to one of the cluster nodes.

hi, we use Consul and a services to create our HAproxy configuration. So, if one node goes down, Consul (and the haproxy consul template) removes the dead node out of the balancer pool. I had also a nice effect with the Mariadb part: My primary MariaDB was running out of diskspace very quickly, be…

Had the same learning regarding the binlogs. Just 2 notes how we handled it: 1st: adapt the configuration parameter expire_logs_days in the MySQL configuration to your environments and needs 2nd: You might want to store the bin logs on a dedicated device which can be helpful as part of the disast…

hi, I had both set: expire_logs_days = 7 (I used than 1) and device also different one, but MariaDB has written several GB per day(!) :smiley:

Icinga Community

Galera MySQL cluster with VIPs and HAProxy for IDO-Mysql and more

Meta Icinga Tutorials and Guides