MySQL Replication: Types, Architecture, and Best Practices
Introduction MySQL replication is a powerful tool for building high-availability systems and scaling read-heavy workloads. Replication allows for multiple copies of the database to be maintained, providing redundancy and distributing read traffic across multiple servers. In this blog post, we’ll discuss MySQL replication, including types, architecture, and best practices. Types of Replication MySQL supports several […]
Backup Streaming using Percona Xtrabackup from Master to Slave for MySQL 5.6
Backup using xtrabackup does not lock the database, which can be performed online with very minimal disruption to the production database. The database server should be operating like normal, with a bit higher load due to data copying/streaming/compressing which depending on the backup command and database size. We can use xtrabackup to re-sync our replication […]
Backup Streaming using MySQL 8.0 Clone Plugin to Slave
For MySQL 8.0, we should use the clone plugin to clone InnoDB tables to another server without blocking. While cloning is happening, the source server can operate normally (nothing is blocked except DDL), with a bit higher load due to data copying/streaming/compressing (depending on the clone command). Consider the following 2-node MySQL 8.0 Replication setup: […]
Installing Galera Cluster 8.0 on SUSE Linux Enterprise Server 15
SUSE Linux Enterprise Server (SLES) is not a new distro in the market. It has been existed for the past 21 years ago, where the first release was based on Red Hat Linux (version 5.1) and KDE 1 in July 1998. It had since moved away from Red Hat’s distribution and became a completely separate […]
MariaDB MaxScale Offline Installation for CentOS 8
For offline installation, a number of things have to be configured in the first place: SELinux is disabled, or set permissive mode. A mysql client is optional but recommended to test out the client connectivity from MaxScale server. This requires local repository to be configured correctly. In this example, we are going to deploy our […]