By Timothy Dyck  |  Posted 2001-03-05 Print this article Print

.23.33"> MySQL 3.23.33

Organizations that want to use MySQL to manage business-critical data can now do so with more confidence because MySQL ABs open-source database offers new transaction support. It still lacks important SQL language capabilities, however, and so it is not as suitable as a general-purpose database server as are some competitors.

SHORT-TERM BUSINESS IMPACT // Built-in replication makes it much easier to have a warm standby system in case of server failure.

LONG-TERM BUSINESS IMPACT // Transaction support means companies using MySQL for some less-critical tasks will now be able to use it for more-critical transactional applications as well.

Lightweight, fast database engine; transaction support with page-level locking; full-text indexing; one-way replication; open source; free.

Standard SQL features such as foreign keys, subselects and views are missing; no stored procedures, triggers or server-side cursors; full-text indexing doesnt support word stemming or Boolean search operators.

MySQL AB, Stockholm, Sweden;

Timothy Dyck is a Senior Analyst with eWEEK Labs. He has been testing and reviewing application server, database and middleware products and technologies for eWEEK since 1996. Prior to joining eWEEK, he worked at the LAN and WAN network operations center for a large telecommunications firm, in operating systems and development tools technical marketing for a large software company and in the IT department at a government agency. He has an honors bachelors degree of mathematics in computer science from the University of Waterloo in Waterloo, Ontario, Canada, and a masters of arts degree in journalism from the University of Western Ontario in London, Ontario, Canada.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel