php

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 monitoring a master master replication setup. It requires a single shared login id available on both MySQL servers. It will display in tabular format following details: File: Present binary log Position: Binary log position Io run: Slave IO Thread Running status Sql run: SQL Thread Running status ErrorNum: Error number ErrorMeg: Error message You can easily stop / start each server’s slave (STOP SLAVE / START SLAVE) with a single...

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 we know commands like: Show slave status; Show master status; Refer: http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-replication.html But when it comes to non-gui interface, it becomes little tedious. With some efforts, I managed to make a php script to monitor mysql servers. It can: Get per second status of slaves. Start / Stop slave from any of the mysql servers in replication. Display error number along with description in case of error in replication. Shows...

Upload Image to MySQL using PHP

Upload Image to MySQL using PHP As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite simple code with two php files one to display and one to upload. For Image Upload code, I’ve added code download link upload-image-mysql-demo.zip at the end of the page. As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite simple code with two php files one to display and one to upload. For Image Upload code,...