Quick Multi MySQL Server Installation with Master-Master Replication on Same Windows Box

This article is a brief step-by-step tutorial on the subject task which is divided into the following main parts: Installing two MySQL Server Instances Setting up master-slave replication Setting up slave-master replication Let’s begin covering those points… Installing Two MySQL Server Instances on Windows: 1. Install MySQL: Download MySQL Binaries from dev.mysql.com. Install normal MSI […]

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 following table on Server1: `id` int(10) NOT NULL auto_increment, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; The table will will get replicated on Mysql […]

Using MySQLTuner – MySQL Optimization Tool

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 your MySQL installation and the areas where it can be improved. Downloading MySQLTuner: wget http://mysqltuner.com/mysqltuner.pl chmod +x mysqltuner.pl Using MySQLTuner Script for Lampp systems: Just […]