Monitor multiple mysql replication using php: Updated

Kedar
November 11, 2009

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…

View Post

Install 2 MySQL Server instances replication on Windows

Kedar
November 4, 2009

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…

View Post

Replication slave lag monitoring using heartbeat and windows batch scripts

Kedar
November 4, 2009

“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…

View Post

how to search / find through all databases, tables, columns in MySQL

Kedar
October 29, 2009

What will you do if one day some one ask you to find single string in all databases, all tables and in all columns, In MySQL Database? This article presents a practical solution…

View Post

MySQL Master Master Replication and auto_increment_increment / auto_increment_offset

Kedar
September 20, 2009

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…

View Post

Difference MyISAM and InnoDB Storage Engines Mysql

Kedar
January 4, 2009

MyISAM InnoDB Default since version 3.23 Relatively newer Files storage: FRM: table definition, MYD: Actual Data MYI: Index File FRM: table definition .ibd file (concept of table space) or single…

View Post