Category: Cluster-HA

MySQL 5.7 Multi-Source Replication – Automatically Combining Data From Multiple Databases Into One

MySQL’s multi-source replication allows you to replicate data from multiple databases into one database in parallel (at the same time). This post will explain and show you how to set up multi-source replication. (WARNING: This is a very long and detailed post. You might want to grab a sandwich and a drink. Continue reading

Advertisements

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