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 […]
Creating Vagrant Box
A vagrant box is a pre-packaged virtual machine image that can be used with Vagrant to create and configure virtual development environments. A box typically includes an operating system and any additional software or configuration settings needed for a specific project or development environment. These boxes can be easily shared with other developers, allowing them […]
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 […]