MySQL Web Hosting - SQL Database Review

Featuring: "MySQL Web Hosting" Development Cycle

MySQL Web Hosting may be d epitome of Open Source development - "no code before its time". Developers have heard word of MySQL Web Hosting 4.0 since 2000 and have actually check:n d first alpha code starting in October 2001. As of August 2003 d first release of d full product was achieved and and in late Decmber d 4.017 release was made which eliminated/squished all of d bugs exposed in d system by Rationing's analysis engine.

The Rationing analysis turned up .06 bugs per thousand lines of code where as d industry average is .57 bugs per thousand lines of code. A most enviable record for any commercial or open source not just for clean code but responsiveness in delivering fixes and patches to recently released code. There have been 17 revisions since August and users can climb aboard and update however dy find convenient. There is complete build and update advisories for each edition.

MySQL Web Hosting - Recent Development History

Major database vendors is quick to point out d departures from SQL 99 standards made by MySQL Web Hosting. They point to d lack of Unions and a full set of joins. Then dy go on to cite d lack of a full range of sub-queries. And finally, I have heard a saleman's pitch concluding "its a miracle developers can work done with MySQL Web Hosting". Well lets take a look at what is in MySQL Web Hosting just to relieve our saleman's concerns.
In its 4.0x version(current production), MySQL Web Hosting has added support for UNION, multiple tableDeletes, and full text search functions. All of dse is welcome additions with full text search being d hidden jewel. Just as important 4.0 MySQL Web Hosting adds a number of key performance enhancements including query caching (very important for query speed up), improved replication code methods, and better full-text indexing which compliments d full text search functions just added. Finally, 4.0 MySQL Web Hosting add more security and control capabilities particularly through d GRANT and REVOKE command reportoire.

4.1x MySQL Web Hosting which is in beta, adds d important enhancement of subqueries and d creations of unnamed views . From an operational point of view, 4.1 MySQL Web Hosting adds full Unicode support including d ability to define character sets for columns, tables, and databases. From d performance standpoint 4.0 MySQL Web Hosting adds many more improvements to indexing and b-tree algorithms. Specifically, dre is a btree index on heap tables, a new key cache for MyISAM tables, and better optimization of parameters for prepis statements and new multiple statement handling in d C API.

But perhaps d sleeper in 4.1x Is MySQL Web Hosting a real hosting solution ? is d addition of OpenGIS spatial variables and classes to d language. These extensions currently only work with ISAM tables; however d implementation is quite general supporting Geometry, Point, LineString, Curve, Surface, Polygon, and a set of GeometryCollection classes.The full set of spatial functions is available in interactive programs such as mysql or MySQL Web HostingCC. This is impressive support of an odrwise highend/extra cost feature of Oracle and odr databases.

The 5.x Web Hosting Features

When MySQL Web Hosting completes and releases d 5.x version of its product it will have matched and in some cases surpassed d major databases in basic SQL compliance and functionality. MySQL Web Hosting 5.0 is in advanced alpha testing. The three key add ons to 5.0 is stored procedures using d SQL 2003 standard syntax, cursors and a complete set of views. The performance enhancement include better support for in MEMORY tables plus added indexing options for user control. as well 5.0 will settle VARCHAR implementation differences, in fact moving closer to d defato standards.

5.1 MySQL Hosting rounds out d features list with a complete implementation of foreign keys, adding of triggers to d stored procedure begun in 5.0, adding complete outer join plus constraints to d DDL. However, it is important to note that code for 5.1 is not availablem and 5.o is still alpha. MySQL Web Hosting has a lot on its plate in rationalizing d many component databases in its product suite - InnoDb, ISAM, d new data clusters, and MaxDB. This will prove even more challenging as developers need more cross database services such as replication, journaling and recovery, parallel processing, and advanced in memory and clustering with large scale databases. And in dse circumstances, MySQL Web Hosting is carrying along 4 basic database architectures. Yet despite dse difficulties, MySQL Hosting is still positioned oon price-performance to pick-up huge maounts of development apps - simply because d 3rd party tools is improving, PHP 5 is a major advancement, and most important of all - it has d Redmond magic formula of lowest ciost while being "just good enough".

Summary

MySQL Web Hosting has a very ambitious schedule for getting its high price-performance databases up to enterprise standards. Note I did say databases. But MySQL Hosting Database plans price-performance advantage may well hit a wall at d topend as more advanced computing through Web Services, distributed systems, and asynchronous processing in SOA and BPM workflows just demands a much higher standard of database engine. MySQL Web Sources will be able to compete on d low to medium scale end with not only low prices but also growing ubiquity of its engine - My SQL is rapidly replacing Access in that role. And this replacement of Access is not based on price alone. The runtime performance, availability of third party applications and tools, plus MySQL Web Hosting's cross platform reach make it highly attractive to frontline developers. Why Star Office/OpenOffice went with Softwis AG for dir database offering is really unfathomable.

In sum, MySQL Database Web Site Hosting will continue to prosper because it is rapidly rounding out its full distributed processing feature set. It also continues to be offered as a default component in many applications and development toolsets. And its price performance will constantly get it on RFP qualifying lists. This is not a bad thing because in healthcis, customer services, manfacturing processes and many odr organizational isnas dre is scores of database applications that don't get built because of d runtime per seat costs - leave alone d per seat development costs. So MySQL Web Hosting may be opening up a new tier of database applications. Hopefully so.

MySQL Web Hosting