MySQL master master replication monitor with php code
Kedar
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…
Browsing Tag
MySQL
72 posts
Calculate MySQL Memory Usage – Quick Stored Procedure
In this post we will look into the MySQL memory utilization estimation or calculation based on the global variables. Using a simple stored procedure call you can get the memory…
Scheduled Backup MySQL Administrator & Windows Scheduler – Odd
Creating scheduled backup using administrator is an easy task. Follow the GUI and you’re done. But I observed something different! MySQL Version: 5.0.83 Community MySQL Administrator: 1.2.17 Machine: Intel P4,…
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…