MySQL performance tuning and Architecture Design recommendation order-From Region revitalization

Four years ago, when I first came into contact with MySQL, the version was 4.1. At that time, I felt how this database was"

Four years ago, when I first came into contact with MySQL, the version was 4.1. At that time, I felt how this database was"

Four years ago, when I first came into contact with MySQL, the version was 4.1. At that time, I felt that the database was so "small": the installation file was small, with less than 20 mb. It had fewer support functions and was not even supported by basic views, processes, partitions, and other functions; it is easy to get started and can be used in almost one day. Not only that, but it also feels weird to use. When creating a table, you must specify a strange "storage engine" such as "MyISAM" and "InnoDB". The table name must be case sensitive. For myself who were used to ORACLE as a "large" database, it was like returning to the Old Stone Age. I thought that although it was free, could such a database be used?

As the work needed, I gradually learned more about MySQL, and some of the original concepts gradually changed: Although there are few functions, the disk space is small, in addition, for development and use, the main functions are basically available, especially after MySQL5.0 is released, some common functions are more complete, and for ORACLE with a huge function, nearly a GB of installation files may often use up to 20% of the features. Although you need to specify a variety of "storage engines" for use, these storage engines are everywhere, each has its own "Shentong". In different use cases, we can flexibly choose On-Demand options to optimize our database performance as much as possible; especially for open-source MySQL strategies, mySQL is becoming increasingly popular. First, MySQL can be freely downloaded and commercially available under the GPL protocol, which greatly reduces the cost of enterprise informatization construction, which is also one of the reasons for the rapid development of the Internet industry in recent years. Second, the open-source features allow everyone to make some personalized modifications to the database source code to improve database performance or add new features. These improvements in turn allow more users to benefit from them.

Currently, MySQL is widely used in the Internet industry, but related materials and books have been lacking. There are only a handful of MySQL-related Chinese books that have been published, especially MySQL books. A year ago, I worked with several colleagues to write a book < <深入浅出mysql> > At that time, the original intention of writing a book was to record some experience in using MySQL at work, hoping that more MySQL beginners would not take any detours. After the publication, the market response was somewhat unexpected, with a high degree of attention. The reason may be that there were too few Chinese books and materials to systematically introduce MySQL. Many readers have put forward a lot of criticism and suggestions after reading this article. Most of them are the lack of MySQL Architecture Design and Optimization content. Readers familiar with MySQL generally know that the biggest problem with MySQL is that it differs significantly from commercial databases in large data volumes and high concurrency environments, therefore, the optimization of MySQL is not about the database itself, but about the architecture design, that is, how to rationally allocate access pressure to the database through technologies such as table sharding, database sharding, replication, and Cache. How to Design the architecture is more dependent on the experience of the designer, and the relevant information on the market is rarely seen, and this book just makes up for this blank.

Although I have never met anyone, I have already learned that I am writing a masterpiece of MySQL, which focuses on MySQL architecture design and optimization. I am lucky to see some of the original articles in advance. I feel that the writing is smooth, the thinking is rigorous, and the pictures are illustrated. The most important thing is that the content is very practical. I believe that the publishing of this book will bring a lot of GAINS to Internet friends!

One day before writing this article, there was an astonishing purchase in the industry. ORACLE will acquire SUN for $7.4 billion, this also makes ORACLE and MySQL, two important competitors in the database field, one in the past. As a result, the database market structure will change significantly, can MySQL bring more surprises to everyone under the guidance of a company like ORACLE that has a deep understanding of the database system? Let's wait and see!

Renewal and revitalization
Netease high-level DBA
Author of MySQL
Blog: http://zhaizhenxing.blog.51cto.com/

Note: The copyright of this referral order belongs to to revitalize all

Original article address: MySQL performance tuning and Architecture Design recommendation order-From Region revitalization, thanks to the original author for sharing.