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.
* 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.
If you want to use a MY-SQL database, than you should opt for a Linux based hosting plan. There are various versions of MY-SQL available like MySQL 5.0 , MySQL 4.0 and different varients of them like MySQL 5.0.51 and many more. Its a Open source and can be downloaded for free.
MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is officially ("My S-Q-L"), but is often ("Micey Quell") or ("My Sequel"). You can use Mysql databse both Windows and linux hosting. There are many version available of Mysql.
__________________ █ ServerSea – Low Cost High Quality Hosting & Designing
█ Free Domain, 99.9% Uptime, Super Fast Servers, Backups, True 24/7 Support
█ Money Back Guarantee, Special Discounts
MySQL is a leading open source relational database management system. It is largely SQL-compliant and runs on a wide variety of operating systems. MySQL is part of the popular LAMP server configuration, Linux Apache MySQL PHP/Perl/Python. Today, it is undoubtedly the most popular and widely used database management system for building database driven websites. It provides a solid backend foundation for millions of websites globally.
MySQL is a database management system that is written in Structured Query Language (SQL). It is both multi-threaded (can execute multiple commands at the same time) and multi-user (more than one user at a time can run commands). MySQL is a very popular system, with millions of installations worldwide.
__________________ █ ServerSea – Low Cost High Quality Hosting & Designing
█ Free Domain, 99.9% Uptime, Super Fast Servers, Backups, True 24/7 Support
█ Money Back Guarantee, Special Discounts
__________________ █ ServerSea – Low Cost High Quality Hosting & Designing
█ Free Domain, 99.9% Uptime, Super Fast Servers, Backups, True 24/7 Support
█ Money Back Guarantee, Special Discounts
MySQL should be better in future because Oracle take it under control. I think guys from Oracle will made changes for faster MySQL. It is best option for shared hosting sites and PHP web sites. With Cpanel it cames by default so I will recommend everyone to use MySQL in start.
Alex Davies wrote:
> Romain wrote:
> > with mysql cluster?... What do you use to do
> load
> > balancing of mysql queries?
>
> Right. Typical setup:
>
> 1X Loadbalancer forwarding requests to
> 2X API Nodes with apache and the PHP scripts
> connecting to "localhost". API nodes connected to
> 2X Storage nodes
>
> You don't have to loadbalance SQL. Loadbalance
> your web requests (easy to do) and use local SQL
> nodes.
In fact, my MySQL and apache server aren't the same server. I have an apache cluster which is working with LVS clustering system. And I wonder if I can use lvs to do an other cluster with only MySQL server.
Finally a PHP scripts could tell the MySQL loadbalancer and the loadbalancer redirect the mysql query to the mysql server which works the least.
I think it's possible but I would like some opinion of this solution and if it's performant
>
> Alex
>
Romain,
I hope that you can understand my messages...
Now a these Many good companies offers Free Mysql database with their hosting plans. If you require such hosting tell me i will suggest good hosting providers.
__________________ █ ServerSea – Low Cost High Quality Hosting & Designing
█ Free Domain, 99.9% Uptime, Super Fast Servers, Backups, True 24/7 Support
█ Money Back Guarantee, Special Discounts