Thread: MySQL Web Hosting

There are several versions of MySQL web hosting. However, if you are using MySQL web hosting for the first time, it is better to opt for version 4.1 as it is default on most web hosting for MySQL systems. The following are the MySQL versions that are commonly used at this time.

* MySQL 4.0: This version is the old stable release and hardly any MySQL web hosting provider uses them. Though new releases are issued, they only help to fix extremely critical bugs.
* MySQL 4.1: This stable release has been followed by several new releases so as to fix the critical bugs and other security problems. The features of this series include subqueries, Unicode support, faster binary client/ server protocol, Create Table, MyISAM storage engine, Archive storage engine, Blackhole storage engine and many more.
* MySQL 5.0: This is the current stable release that follows the SQL: 2003 syntax. This MySQL web hosting can even return multiple result sets in a single invocation. New releases are also issued to fix the bugs.

Yes MySQL is very flexible and very cost efficient. You'll get a database threshold in the hundreds compared to a Windows MsSQL database threshold. I used both Windows and Linux on my host before (and currently still do) and the difference is noticeable. Windows is powerful in its own way though.

Most of the users prefer to choose MYSQL 4.1 if they are starters. The new issues will fix the critical bugs.

I dunno, i muchly prefer MySQL 5. The Object-Oriented features make it very useful and a lot quicker to code.

Dom

MySQL 5 is pretty common now. Almost any web host will have it installed on their servers.