MySQL-MySQL tutorial

Introduction to the technical architecture of MySQL: Hello, everyone! I'm Jin Pu, the technical application editor of SCID. Today, Mr. David Axmark and Mr. Zhou are on the road. it is expected that they will meet with their friends later. Now we invite Ms. Chen Hui to introduce herself.

Chen Hui: I am Chen Hui, a Wanli open source system engineer.

Jin Pu: because David Axmark and Zhou have not come yet, I heard you give a speech when MySQL was founded at the Chinese R & D center the day before yesterday, I also talked about the technical architecture of MySQL, including future development directions. Let's talk to netizens today.

Chen Hui: We are the only proxy for MySQL in China. we are a development platform based on Linux and a vendor based on Linux open source software. We are familiar with TurboLinux. our cooperation with MySQL hopes to learn some advanced experience from the more advanced open-source software in advanced countries, we hope to build a better enterprise-level server platform through cooperation with them.

The following describes the main technical features of MySQL. As an open-source database, MySQL is its biggest feature because all its original code is published to the public. There are more than 50 thousand downloads on the MySQL website every day, so many users use MySQL, in addition, if you find bugs during use or have some improvements, you can quickly report them to MySQL so that you can further optimize the product.

In addition, MySQL has been making continuous efforts in three aspects: first, its performance. MySQL is a very fast database system. The second is its reliability, because it is open-source and hopes to enhance its reliability through open-source methods. The third is the ease-of-use of MySQL. MySQL can ensure that anyone who has no access to the database will learn to use MySQL within 15 minutes, which is very easy to use.

There is also a special feature in the MySQL architecture, where storage exists as a pluggable storage engine. We all know that it is not so easy to create a large and comprehensive database system, because each user may have different requirements, and the database performance is not as important as other aspects. MySQL's pluggable storage engine has this feature. For example, the commercial version supports better Myizm, inodb, Ndb, and different storage engines. for example, Myizm is faster, you can select different storage engines based on your needs, and the configuration is flexible.

Jin Pu: I heard that MySQL has three versions in China at the last press conference. can you tell me the technical and application layer differences between these three versions?

Chen Hui: Currently there are three products in China, one is PRO, which is an enterprise-level database with the copy function and data processing function. basically, all the database functions are complete, it is a single machine. The second is the CLUSTER version. CLUSTER is the CLUSTER version. when the standalone version of the database cannot meet the requirements of enterprise-level applications, we need to improve the concurrency and performance by balancing the load of multiple servers. The third Maxdb is a database that cooperates with SAP. its main application is a special application in SAP. Its development and maintenance teams are available in both Maxdb and SAP.

Jin Pu: are these three commercial or individual editions?

Chen Hui: Maxdb is an open-source database. the open-source community has a separate version, but its functions are exactly the same as those of the commercial community. However, the community edition does not include the product, yes. The commercial version is divided into CLUSTER and PRO.

Jin Pu: the three versions have different focuses. I am a user who has a naive idea. can I bring the characteristics of these three databases into the most powerful full version?

Chen Hui: there is no problem between Maxdb, PRO, and CLUSTER, because the downloaded community version, if you have bought a CLUSTER that already contains the PRO function, so that the business perspective is different, maxdb was first developed by SUN and later cooperated with Maxdb. SUN is a technology that combines with applications. Maxdb mainly provides some database support technologies. In fact, it is different from Maxdb databases. Jin Pu: Does the cooperation between SAP and MySQL mean to compete for the market with Orocle?

Chen Hui: I think each has its own market.

Jin Pu: for example, the storage system you mentioned may reduce the speed of the database. in this case, how does MySQL ensure its previous development philosophy during the development process?

Chen Hui: You want the database to become more reliable, and some performance needs to be reduced. For example, a MySQL engine called Myzim does not support data processing. It is not just a database, but also other software that operates, with a balance in terms of performance, reliability, security, and so on. MySQL tries its best to maintain fast performance after new features are added. Because it has an optimizer in the database for optimization. With regard to clusters, we should say that clusters can improve MySQL performance, including our tests. users in China can configure clusters reasonably faster than those in the standalone version.

Jin Pu: The performance is increasing, including the support, which will make the database very complex. the more complicated the structure, the more stability it will be affected. how can this be balanced?

Chen Hui: the MySQL architecture is relatively stable and concise. MySQL is a database that came out in 1990s. the entire architecture draws on some of the above excellent features and gets rid of the bad ones. The overall architecture is still relatively good. In addition, the shell insertion method is also to avoid the situation you mentioned, that is, flexible, not to say that it is a fixed structure. In the future, I will develop a new engine that may have high availability and mature performance. it can completely replace the original one without affecting the existing architecture. this is its flexibility.