MySQL Archive
-
Monitor multiple mysql replication using php: Updated
Posted on November 11, 2009 | 11 CommentsMore...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... -
Quick Multi MySQL Server Installation with Master-Master Replication on Same Windows Box
Posted on November 4, 2009 | No CommentsMore...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... -
Replication slave lag monitoring using heartbeat and windows batch scripts
Posted on November 4, 2009 | No CommentsMore...“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... -
Search-find through all databases, tables, columns in mysql
Posted on October 29, 2009 | 3 CommentsMore...What will you do if one day some one ask you to find single string in all databases, all tables and in all columns? I just read such question and tried to find... -
Problem with Master Master Replication and Auto Increment
Posted on September 20, 2009 | 2 CommentsMore...Consider we’ve already set a master-master replication. Now create following table on Server1: CREATE TABLE `temp` ( `id` int(10) NOT NULL auto_increment, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;... -
Upload Image to MySQL using PHP
Posted on January 30, 2009 | No CommentsMore...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... -
Difference MyISAM and InnoDB Storage Engines Mysql
Posted on January 4, 2009 | No CommentsMore... 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... -
Choosing between MyISAM and INNODB – MySQL Storage Engines
Posted on January 1, 2009 | No CommentsMore...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... -
Perl Script for Analyze – Optimize – Repair Mysql Databases
Posted on January 1, 2009 | 1 CommentMore...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... -
Using MySQLTuner – MySQL Optimization Tool
Posted on January 1, 2009 | 2 CommentsMore...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...