Shulou(Shulou.com)06/01 Report--

This article shows you what the shine of database selection is like in application development. The content is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

As soon as I went to work today, there was a phone call asking me about the excpetion timeout of MYSQL. After I learned about it, I told me how to solve such a problem, as well as the causes of such a problem, and so on, because I encountered such a pit a few years ago, and there was a mature solution at that time.

I can think about it for a moment. I had to ask about this project, because it was the first time I heard that after finding out the origin of the project, I sent out an "alas" on the phone. Because this project uses MYSQL.

Today's system developers are busy every day, and the recent trouble with ICU is also the pressure for programmers to talk about their work. In fact, a mature data architect should, to some extent, track the project at the beginning of the project, looking for a time-saving and labor-saving database system for the project and programmers, and good for operation and maintenance, so that there are fewer complaints and make the system more reliable.

Because after listening to the programmer talk about this project, I immediately responded to a point, this is solved with MONGODB, no matter from the time of development, the difficulty of development, and the later maintenance, etc., it is much better than using MYSQL, programmers waste a lot of effort, in fact, they are solving the problem that another database is inherently supported.

"Why didn't you say it earlier? why didn't you say it earlier?" This project actually grabs the information from the traditional database, then stores it in the database, and in batch generates the information in JSON format, and sends the message queue to another micro-service. Because the amount of data is a little large (in fact, it is only less than 20 million in half a year), but this also involves regular filing and regular cleaning in the later stage of operation and maintenance, and our general operation here is to complete this kind of work through procedures to minimize the workload of operation and maintenance and avoid mistakes in the work.

So we use the method of regular sub-table, and MYSQL is more dependent on the program than ORALCE SQL SERVER, and other databases, so the use of MYSQL requires programmers to spend more effort.

In the afternoon and the development director on the phone, in fact, they are also "regret", if I had known that MONGODB could accomplish such a thing, it would not have to be revised now, it would be another package. We don't know how much BUG we will encounter, and we also have to consider the amount of data and the operation of sub-tables.

The above content is what the shine of database selection is like in application development. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.