Shulou(Shulou.com)05/31 Report--

This article will explain in detail the example analysis that MySQL no longer supports Berkeley DB but adds plug-ins. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

In the latest version 5.1.12, MySQL will remove the Berkeley DB (BDB) storage engine from the list of supported database engines. Some observers believe the move is related to Oracle's acquisition of Sleepycat, and InnoDB could be the next one to be moved out. However, Brian Brian Aker, head of MySQL architecture, said they would not give up on InnoDB and that the Berkeley engine was abandoned this time for technical reasons. Brian Achor also announced that MySQL will release a new memcache storage engine plug-in for MySQL.

The relationship between this and Oracle's acquisition of Sleepycat and Innobase is obvious. Some people think that Oracle is to destroy the business of MySQL and the decision to give up support for the BDB engine. But Achor says that's not the case.

MySQL and Oracle have their own words.

If it's not for Oracle, why give up BDB? One possibility is that the BDB engine is not widely used. Achor said that Debian should be the only MySQL partner with BDB support, and "the way MySQL's main program enables it is also strange." I believe the actual number of installations is numbered. It's not that the BDB engine itself is bad, but mainly because InnoDB is supported by a more active development team. In the open source world, active code is the main reason for widespread use. "

Rex Wang, vice president of embedded systems marketing at Oracle, said it was actually the Berkeley DB development team that asked to cancel the support. "as far as we know, MySQL almost no longer uses Berkeley DB, so there is no conflict among our (Oracle) user base."

Although BDB is not widely used, Achor said that BDB will not disappear from MySQL 5.0 and previous versions. So users who have MySQL 4.x or MySQL 5.0.x installed and use BDB need not worry about this. Achor also stressed that "MySQL has never provided commercial support for BDB, so there is no need for any changes."

MySQL didn't say too much about giving up BDB, but it was written into the 5.1.12 MySQL update instructions. Version 5.1 has always been considered a beta, and 5.1.12 has not been released yet, so it is not surprising that MySQL has not issued an official statement on this matter.

Some special analysts complain that this is one of the manifestations of MySQL's lack of communication with users, and think that the next "disaster" will probably be InnoDB.

Achor said that abandoning BDB does not mean that the next challenge will be directed against InnoDB, nor does it mean that MySQL will abandon the InnoDB storage engine after InnoDB is acquired by Oracle. " My dog always thinks all squirrels are thieves. I spent a few hours last week sorting out the code for the InnoDB interface. I found that there is still new code added by Heikki. A few months ago I was talking to people about how to extend the SQL syntax in MySQL to balance full-text search support in InnoDB. There is no indication that InnoDB is going to disappear or that Oracle stops supporting it. " And what is the reason for MySQL to abandon InnoDB? Many of our users are still using it. I also need to use it when I make a website, so I personally hope it will run smoothly. "

Rex Wang, vice president of embedded systems marketing at Oracle, pointed out that Oracle will continue to support InnoDB storage engine for MySQL. "InnoDB is currently the most widely used transactional data storage engine in MySQL, while Oracle will continue to provide InnoDB support to MySQL, including promoting updates and comprehensive support. So there is no need for MySQL and Oracle to continue to support a second transactional storage engine, Berkeley DB." He stressed that BDB was MySQL's first transactional engine, but InnoDB has developed rapidly and has become the first choice for users. "because InnoDB fully supports the only user MySQL, while Berkeley DB has to face a series of users and open source communities. MySQL uses a modified version of BDB, and the driver itself is not optimized for it for many years. InnoDB has been optimizing for MySQL and is now mature and stable."

Plug-in: Plugins anyone?

The advantage of open source is that anyone who needs it can choose to use it. If the open source community is interested in continuing to support BDB, Achor thinks it's easy to make BDB a storage engine plug-in. It also gives examples of engines that add MySQL in the form of plug-ins without integration, such as PrimeBase XT's MySQL transactional engine and Solid Information Technology's MySQL storage engine.

Achor also mentioned the memcache storage engine plug-in he developed, which can add Memcached functions directly to MySQL without having to run Memcached separately. Memcached is a tool for high-traffic websites such as LiveJournal to improve performance by allowing visitors to access memory information without having to access disk. Achor says using Memcache as the storage engine makes it easier for developers. "the round-trip cost of data will be controlled because the data can be transferred directly from the database. You can also simply use the select statement to compare the difference between memcache and database content. Easier to use, easier to integrate, less round-trip data... it's a great idea to take it all into account."

This plug-in is still in early development. Achor calls it the "pre-Alpha version," so some SQL statements may not run in memcache yet. Achor said that SELECT, UPDATE, DELETE and INSERT statements can all be run, while some statements such as ORDER BY, REPLACE and so on can not be run.

Will Memcache become a mainstream component of MySQL? "it depends on demand and use," Achor said. "it's faster to develop memcache outside the MySQL mainline at the moment. I believe they can be merged one day."

On "MySQL no longer supports Berkeley DB to add plug-ins example analysis" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.