MySQL adding transaction support to database

MySQL AB, maker of the identically named open-source database, is adding transactional support to its database, company officials said.

In a recent announcement, MySQL announced that transactional support will be added to MySQL Pro, the version of the company’s database that is intended for corporate deployment. Transactional support had been in MySQL Max, an experimental version of the product.

“This takes the edge out of the argument that MySQL is not suitable for enterprise use,” said MySQL CEO Marten Mickos.

MySQL now includes the InnoDB transactional storage engine, intended for high performance and high scalability when processing large data volumes under high-concurrency conditions.

Other features of the product include full transaction support with commit, rollback, and crash recovery capabilities to ensure full data consistency, MySQL said. Also featured is advanced row-level locking without requiring lock escalation, for read/write concurrency without compromising lock integrity.

A multi-versioning function provides concurrency while maintaining data integrity. Non-locking reads, meanwhile, enable fast reads even when the database is engaged in heavy updates, according to MySQL.

MySQL costs US$395 per server, with no extra per-user or per-processor charges.