Monthly Archives: June 2010

MySQL Master / Master Replication Sync

IMPORTANT: ALWAYS make a backup of your databases before attempting the following procedures. The following is based under the assumption that your MySQL servers are already setup to be Master / Master. If you have have a MySQL Master / … Continue reading

Changing the Default Text Editor in Linux

By default, CentOS / RHEL 5.x ships with VIM as the default text editor. However if you prefer a different text editor you can easily modify the default text editor by changing the VISUAL environment variable.

Calculate MySQL Database Sizes Using SQL Query

Here is a quick and easy way to get the sizes of your databases in MySQL, useful when you don’t have PHPMyAdmin and just want to compare two databases (live and development for example).

The Importance of RAID

Redundant Array of Independent Disks (RAID) is a key technology to mission critical / business servers which aim for the highest possible uptime on their servers. While S.M.A.R.T. (Self-Monitoring, Analysis, and Reporting Technology) hard disk technology can warn of an … Continue reading

Restore Single MySQL Database from Full Backup

We’ve recently ran into a situation where a client accidentally deleted her database and only had a 10 GB mysqldump created with –all-databases. As you can imagine, trying to grab a single table out of a 10 GB mysqldump backup … Continue reading

Blog is powered by WordPress and designed by Chico Web Design