Relay log read failure | 2 many dots can break your replication only once
Kedar
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,…
Browsing Tag
replication
8 posts
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…
Install 2 MySQL Server instances replication on Windows
At times you need to install multiple MySQL instances on same machine. This article is a brief step-by-step tutorial on the subject task which is divided into the following main…
Replication slave lag monitoring using heartbeat and windows batch scripts
“Show Slave Status” command has a last column “Seconds_Behind_Master”, which gives us idea about how much time slave is lagging behind master. It is an important to be considered parameter…
MySQL Master Master Replication and auto_increment_increment / auto_increment_offset
In this post we will see importance of replication related variables auto_increment_increment & auto_increment_offset with respect to MySQL Master Master setup. Consider we’ve already set a master-master replication. Now create…
Recent Comments