Aug 18, 2023 |
Insight for DBAs, MySQL
This blog describes how to configure systemd for multiple instances of MySQL. With package installations of MySQL using YUM or APT, it’s easy to manage MySQL with systemctl, but how will you manage it when you install from the generic binaries? Here, we will configure multiple MySQL instances from the generic binaries and manage them […]
Apr 21, 2023 |
Insight for DBAs, MySQL
In this article, we will discuss errant Transaction /GTID and how we can solve them with the Orchestrator tool. Orchestrator is a MySQL high availability and replication management tool that runs as a service and provides command line access, HTTP API, and Web interface. I will not go into the details of the Orchestrator but […]
Jan 23, 2023 |
Insight for DBAs, MySQL
A couple of days ago I was creating an index on the source and when I checked the replica side it was not replicated, so I just wanted to explain how the replication filter may increase the complexity of your DBA operations. Replication occurs by reading events from the binary log of the source and […]
Dec 06, 2022 |
Insight for DBAs, MySQL, Percona Software
What is a Delay Replica and how does it help? MySQL Replication is useful, easy to set up, and used for very different purposes. For example: split reads and writes run data mining or reporting processes on them disaster recovery To learn more, check out How Does MySQL Replication Work? It’s important to mention that […]