Introduction to MySQL Technology architecture

Jin Pu: Everybody good friends! I'm Sadie network Technology application editor Jin Pu, who was supposed to be here today, Mr. David Axmark and Zhou are on their way, expecting to meet some friends later. Now we ask Ms. Chenhui to make a self-introduction.

Chenhui: I am an open-source system engineer Chenhui, very happy to be a guest Sadie network.

Jin Pu: Because David Axmark and weeks have not come, the day before yesterday when MySQL was established in China Research and Development Center, I heard you make a speech, also said the MySQL technology architecture, including the future direction of development and so on. Let's talk about it with net friends today.

Chenhui: Our open source is MySQL's only agent in China, we are based on Linux platform for Development, based on Linux open source software provider. We are more familiar with the turbolinux, our cooperation with MySQL hope that on the one hand to the advanced countries more advanced open source software to learn some advanced experience, hope that with their cooperation to establish a more complete enterprise-Class Server platform.

Let me introduce you to the main technical features of MySQL. MySQL as an open source database, open source is its biggest feature, because all of its original code is published in the public. There are more than 50,000 downloads per day on the MySQL website, there are so many users with MySQL, and everyone in the use of the process if found bugs or some need to improve the place can quickly feedback to the MySQL company, so that can help the product to have a further optimization.

In addition, MySQL has been in three aspects of continuous efforts, first of all its performance. MySQL is a very fast database system. The second is its reliability, because it is open source and hopes to enhance reliability with the help of open source. The third is the ease of use of MySQL, MySQL can ensure that any person who has not contacted the database in 15 minutes to learn the MySQL, is very simple to ease.

There is also a special place from the MySQL architecture, where the storage exists as a pluggable storage engine. You know it's not easy to make a all-inclusive database system, because each user needs may not be the same, value the performance of the database and other aspects are not the same value of the database features place is not the same. The MySQL pluggable storage engine has this feature. For example, like the business version of the support of better myizm, there are inodb,ndb, different storage engine features are not the same, such as Myizm speed faster, users can choose different storage engine according to different requirements, configuration can be very flexible.

Jin Pu: The last time I heard about MySQL in China now has three versions, can you introduce these three versions on the technical level, the application level of what is different?

Chenhui: Now there are three products in China, one is pro, it is an enterprise-class database, with the copy function, data processing function, is basically the database complete function has, it is a stand-alone. The second is the cluster version is cluster,cluster when the stand-alone version of the database can not meet the requirements of enterprise applications, we need to balance the load through multiple servers to improve concurrency and performance, this is the cluster. The third maxdb, which is a database of collaboration with SAP, is a very special application in SAP. Its development team, maintenance team not only in MaxDB, but also in SAP.

Jin Pu: Are these three commercial or personal editions?

Chenhui: MaxDB is an open source database, the open source community has a separate version, but the function is the same as the business, but in the community version does not have the product that product, you can download. The business edition is divided into cluster and pro.

Jin Pu: Three versions have different focus, I am a user has a more naïve idea, can you put the characteristics of these three databases to the most powerful full version?

Chenhui: MaxDB and Pro and cluster are no problem, because the community version of the download, if bought cluster already contains the pro function, so the business point of view is that MaxDB was first developed by Sun from the database system, and later with the MAXDB cooperation, Sun is a technology that combines with applications, and maxdb mainly provides some techniques for database support. In fact, it is different from the MAXDB database. Jin Pu: Is the collaboration between SAP and MySQL the meaning of trying to compete with orocle for the market?

Chenhui: I think each has its own market.

Jin Pu: For example, the storage system you mentioned may reduce the speed of the database, so how is MySQL in the development process to ensure that the concept of their previous development?

Chenhui: You want the database to do more and more reliably, and there may be some aspects that need to degrade some of the performance. For example, there is an engine in the middle of MySQL called Myzim (sound) is not supported data processing. Not only the database, the operation of other software is the same, in terms of performance, reliability, security, and so there is a balance. MySQL wants to be able to maintain fast performance after adding new features. Because it has an optimizer in the database to optimize. With regard to clusters, it should be said that clustering can improve MySQL performance, including our testing, in China, the user through a reasonable configuration of the cluster faster than the stand-alone version.

Jin Pu: Performance is increasing, including what is supported can make the database very complex, if the structure more complex stability will be affected, how to balance it?

Chenhui: Now look at the MySQL architecture is relatively stable, relatively concise. MySQL is the 90 generation of the database, the entire framework is to absorb some of the excellent characteristics of the front, but also to exorcise the bad place, the whole structure is still relatively good. And the way of the shell is to avoid the situation you mentioned, is flexible, not to say that a fixed on a structure. Later I developed a new engine may have a front and the availability, but also a very mature performance, it can replace the original without affecting the existing architecture, which is its flexibility.