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.

Would you recommend this article?


Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.

Jim Love, Chief Content Officer, IT World Canada

Featured Download

Featured Articles

Cybersecurity in 2024: Priorities and challenges for Canadian organizations 

By Derek Manky As predictions for 2024 point to the continued expansion...

Survey shows generative AI is a top priority for Canadian corporate leaders.

Leaders are devoting significant budget to generative AI for 2024 Canadian corporate...

Related Tech News

Tech Jobs

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

Tech Companies Hiring Right Now