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; email@example.com