How to MySQL Replication setup, Master GTID & SSL Encryption
Kedar
Setting up replication in MySQL is a common DBA task. The replication could be traditional binary log replication or based on GTID replication. This blog is a work log and…
Browsing Tag
replication
9 posts
Relay log read failure | 2 many dots can break your replication only once
Two or more dots in your relay log or binary log names can break replication; but worry not, it will only do it once. If you request to start again,…
Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY
In this post we will see a case study of a Galera Cluster migration to AWS Aurora and quick solution to the replication issue. A friend received an error in…
Fixing inconsistency on MySQL Slave of Galera Cluster
This blog post explores the syncing options for an inconsistent MySQL slave of Galera cluster node using pt-table-sync
MySQL master master replication monitor with php code
For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it 😉 Well this is fairly simple php code for…
Monitor multiple mysql replication using php: Updated
Monitoring a replication is an important aspect. As replication includes multiple nodes, it is essential to track activity and status across all mysql servers involved in replication. To monitor replication…