Install MySQL 5.7 on CentOS 8 / RHEL 8 Linux
Are you looking for a guide to help you install MySQL 5.7 on CentOS 8 / RHEL 8 Linux server / Workstation?. The CentOS / RHEL 8 AppStream repository only … Continue Reading →
Category: Mysql
Remove MySQL replication
There might be a time that you no longer need a MySQL slave in your replication setup. You can remove a mysql replication slave using the following instructions. Log in … Continue Reading →
How To Create Hot Backups of MySQL Databases with Percona XtraBackup on CentOS 7
Percona XtraBackup Introduction A very common challenge encountered when working with active database systems is performing hot backups—that is, creating backups without stopping the database service or making it read-only. … Continue Reading →
REPLICATION TROUBLESHOOTING – CLASSIC VS GTID
In previous posts, I was talking about how to set up MySQL replication, Classic Replication (based on binary logs information) and Transaction-based Replication (based on GTID). In this article I’ll summarize how to troubleshoot … Continue Reading →
Multiple Master on Single Slave MySQL
Multi-Source Replication Tutorials This section provides tutorials on how to configure masters and slaves for multi-source replication, and how to start, stop and reset multi-source slaves. Configuring Multi-Source Replication This … Continue Reading →