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...
by Hamish Oscar Lawrence | Feb 18, 2009 | Apache, MySQL, PostgreSQL, Server Administration
A Web Host has to actively monitor all the services running on each of its Internet Servers. Customers assume that the services advertised by the host are available 24/7, and hence Internet servers monitoring takes a high priority in the Web Hosting business world. 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...
by admin | Mar 25, 2007 | Apache, Litespeed, MySQL, Server Administration, SQLServer
LLMP is a better LAMP . It is fast and stable. Lighty+php is 25% faster than Apache+mod_php . An LLMP server will provide 2 to 3 times faster than a LAMP. Lighttpd webserver is under BSD license so that you can configure it as you wish. “Light is life,Lighty is...
by admin | Mar 15, 2007 | MySQL, Server Administration
This article describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (say we can call it as slave), and all updates to the database on the master server are...
Recent Comments