Category: Cluster-HA

How to install and configure MariaDB Galera as master to master replication cluster on Ubuntu 16.04 LTS

How do I install and configure MariaDB Galera master to master cluster on Ubuntu Linux 16.04 LTS server to get both read and write scalability?

MariaDB Galera Cluster is an open source and free synchronous multi-master cluster for MariaDB database. It is available on Linux only and only supports the XtraDB/InnoDB storage engines. There is experimental support for MyISAM, but it is not well tested. Starting with MariaDB 10.1, the wsrep API for Galera Cluster is included by default. Continue reading

Setting up a Load-Balancing Cluster with Heartbeat and Ldirectord

We will be setting up a load balancer with Heartbeat and Ldirector on CentOS 6.
Note
Ldirectord has been removed from RHEL 6 default repository and replaced with Piranha.
As of RHEL 6.6, Red Hat provides support for HAProxy and keepalived in addition to the Piranha load balancing software.
Piranha has been removed from RHEL 7 default repository and replaced with HAProxy and keepalived. Continue reading

Setting up a Load-Balancing HAProxy Cluster with Keepalived

We will be setting up a load balancer using two main technologies to monitor cluster members and cluster services: Keepalived and HAProxy. Keepalived uses LVS to perform load balancing and failover tasks on active and passive LVS routers, while HAProxy performs load balancing and high-availability services to TCP and HTTP applications. Continue reading