by Visakh S | Jun 30, 2015 | MySQL, Server Management
Server crashes could leave databases in inconsistent states. While there are many tools available to repair MYISAM tables in MySQL, InnoDB repair is not always so straightforward. MySQL could refuse to start up, leaving you with in-determinate downtime. If your MySQL...
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 | Jun 7, 2010 | MySQL, Server Administration
MySQL is an important service in the Web-Hosting industry. Almost 80% of websites on the Internet are database driven. In a shared hosting environment, the availability of this service is critical. Many times, I have come across the problem of some particular database...
Recent Comments