by Visakh S | Nov 7, 2015 | MySQL, Server Management
For a website owner or a web host, a hard disk crash is one of the most upsetting things that can happen to their business. It means service downtime, loss of business and valuable time spent on data restoration. To minimize such catastrophe, many server owners keep...
by Hamish Oscar Lawrence | Dec 8, 2010 | MySQL, Server Administration
Most of us are familiar with LAMP, the most popular free/open source solution stack in use today. There is an, not as popular, alternative that database intensive site owners might be interested in: LAIP. While LAMP stands for Linux, Apache, MySQL and PHP; LAIP swaps...
by Hamish Oscar Lawrence | Nov 22, 2010 | MySQL, Server Administration
The MySQL replication team have been hard at work improving the features of MySQL replication. In this part, I’ll be talking about a few more features included in MySQL 5.5 Automatic Relay Log Recovery If this features is enabled, when a Slave recovers from a...
by Hamish Oscar Lawrence | Nov 19, 2010 | MySQL, Server Administration
There have been many advancements in MySQL 5.5, a majority of them have been towards improving performance and scalability. InnoDB is now the default storage engine, which provides higher levels of performance and reliability than MyISAM. InnoDB 1.1 that is, a...
by Hamish Oscar Lawrence | Jul 2, 2007 | MySQL, Server Administration
MySQL is the most widely used multi-user, multi-threading SQL database management system. To optimize MySQL performance, a DBA should have reasonable knowledge of MySQL system variables. This article covers the basics of MySQL server optimization. We will first...
