PDA

View Full Version : NuSphere to contribute Row-Level Locking for MySQL 4


Chris Schreiber
Mon 30th Oct '00, 6:18pm
NuSphere is developing Row-level (record) locking for the next major release of MySQL

http://www.nusphere.com/releases/103000.htm


BEDFORD, Mass.—October 30, 2000 — NuSphere, provider of NuSphere MySQL™, the leading packaged software product for the open source database marketplace, announced today that it is partnering with the MySQL open source database community to develop a row-level locking capability for the MySQL database. Code-named "Gemini," this project will be part of MySQL Version 4, targeted for release in the spring of 2001.

Gemini is an important contribution to MySQL because it will allow database programmers to use familiar database programming techniques to expand the business application possibilities of the open source database. With Gemini, MySQL will acquire a robust transactional storage engine that will provide row-level locking. MySQL is the No. 1 open source database, embraced by developers for the speed with which it performs the authentication, authorization and personalization functions of Web applications. With Gemini, developers will also be able to build MySQL-based solutions that handle transaction-sensitive applications, including financial applications. In addition, the fine-grain locking will enable a higher level of concurrency, making it an option for enterprise-level deployments with high user counts.

"We are excited about the Gemini project on multiple levels," said D. Britton Johnston, chief technology officer at NuSphere. "It's an opportunity to participate in the evolution of MySQL, which has already proven to be a great open source alternative to traditional databases, and it's a way to support, and contribute to, the open source community."

NuSphere has also worked closely with the MySQL development community to make the more than 650 pages of documentation for MySQL available in print. The initial shipment of NuSphere MySQL contained the first-ever release of the MySQL Reference in printed form. NuSphere MySQL is a multi-platform, integrated distribution of Apache, Perl, PHP and MySQL. Designed for Linux, Unix, and Windows platforms, the packaged solution has been available since September of 2000 from NuSphere.

"We're convinced that NuSphere will play an important role in the future of MySQL," said Michael "Monty" Widenius, chief technology officer of MySQL AB. "Their contribution will provide an enhancement that is often requested, and much needed. Gemini is another example of NuSphere's commitment to MySQL and the entire open source community."

"NuSphere's initiative to see a row-level locking capability added to the MySQL database should attract an entirely new group of end users," said Wayne Kernochan, managing vice president, Platform/Infrastructure Solutions, Aberdeen Group, Inc. "Until now, this popular open source database has been mainly restricted to Web content management. With row-level locking, MySQL will be able to substantially increase its business value."

Freddie Bingham
Mon 30th Oct '00, 6:37pm
Yea we can commit() and rollback() now :)

Chris Schreiber
Mon 30th Oct '00, 6:50pm
Yes it looks that way :) I am sure many people have been waiting a long time for this, and those PostgreSQL people won't be able to say they have this advantage over MySQL anymore ;)

I'm very excited to see what neat features will all be available when MySQL 4 is released... it's nice to have a large company with enterprise database support helping to develop new features like these into MySQL.

-Chris

eva2000
Mon 30th Oct '00, 8:07pm
well i am excited that your excited... :D

Chris Schreiber
Mon 30th Oct '00, 9:05pm
Originally posted by eva2000
well i am excited that your excited... :D

LOL :)

etones
Tue 17th Jul '01, 7:18am
any ideas when this will be available, im seriously thinking about moving to PostgreSQL.. unless these changes appear :)

Chris Schreiber
Wed 18th Jul '01, 12:39am
NuSphere just lanuched a new web site, www.mysql.org and have placed MySQL+Gemini 3.23.29 available for download. Go to http://www.mysql.org/listfile3.php?cat_id=MySQL-3.23 to download it.

dwh
Thu 19th Jul '01, 4:12am
How hard is it to upgrade mysql? Will it mess up existing vb?

What does gemini help us practically speaking? Does vb take advantage of row locking? Does this mean that it'll speed up vb? So if you reply to a thread for example, it'll wait for that thread ROW to be available instead of waiting for the whole table? So simultaneous posters will post faster? Am I getting the gist or way off mark? Thx

Chris Schreiber
Thu 19th Jul '01, 4:36am
There are a few people already using NuSphere's Gemini tables with vBulletin.... it's a new (faster) database server backend, but it doesn't effect the client or application at all.

Yes your assumption is correct... with MyISAM tables, everything is locked at the table level... so if someone is, let's say making a new post, it will lock the entire post table while that update is occuring, not allowing anyone else to update it. So if you have a large number of users, it can really slow things down while people are just waiting for a table lock.

Gemini uses row-locking, so just the records you are updating are locked, leaving all the other records available for others to update at the same time.