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

Choosing between MyISAM and INNODB – MySQL Storage Engines

Kedar
January 1, 2009

After reading at a lot of places for the the single repeatative question, “What engine shall I choose – MyISAM or Innodb?”, this is what I’ve got. Following are points…

View Post

Perl Script for Analyze – Optimize – Repair Mysql Databases

Kedar
January 1, 2009

The perl script is mainly created to avoid manual Mysql Server Maintenance. The script uses Perl module DBI. You need to provide access credentials and database name(optional). Regarding Analyse, Optimize…

View Post

Using MySQLTuner – MySQL Optimization Tool

Kedar
January 1, 2009

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about…

View Post