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

This article introduces the special functions of Percona server of Mysql and how to think from multiple angles. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.

DBER users of MYSQL are interested in big transactions and expire_log_days about BINLOG or updated Binlog_expire_logs_seconds (MYSQL8)

The retention and control of BINLOG in China are more or less uncertain.

problem

1 is there a direct relationship between the number of days retained by BINLOG and how much BINLOG SIZE is actually stored?

2 I set up a shorter expire_log_days whether there will be the problem of database down machine caused by the surge of binlog.

3 how can I guarantee that even if there is a big business and business surge caused by BINLOG soaring in time to ensure that the business does not stop, automatically first solve the storage warning line of BINLOG.

OK if you have an official version of MYSQL installed, you can skip this article because the following methods may not work. If you happen to be like me, the MYSQL deployed by the company is the version of PERCONA, then you are here, the following text will certainly help you.

This problem has actually been reflected by customers. PERCONA has already typed a PATCH on the related mysql 5.7.23 to clear the log SIZE after the restricted date, which looks like nothing but is actually a very useful function.

Let's take a look at the actual situation.

The machine demonstrated below is a test machine, and the BINLOG growth of the test machine is irregular, so I can set the storage time as short as possible, but the disk capacity of the general test machine is not very large, so if the test carries on the software performance test, it is easy to burst the disk.

The screenshot below shows the current situation of the server at this time. The log is about 15G, but what if we want to keep only 5G of logs?

We add binlog_space_limit = 5G

Then from the server that started MYSQL, OK

Looking at the figure below, after MYSQL SERVICE starts up, check the amount of data retained by BINLOG again, you can see that most of the data logs have been automatically deleted.

Recently, another place where I feel that I have improved is that the original idea of most of the time is to think about software development, or software architecture, with the idea of a DBER, while I went to the development department of a new company and transformed it into a database architecture. I have learned a lot about how to integrate database and development ideas to think about problems. For example, it was previously thought that the function of verifying the data entered by the CHECKER users of the software should be placed at the front end, and when the user mistakenly entered the data and caused the back end, or even the database to generate fields that were inconsistent with the type of input data, the first thought was what the front end was doing and whether there was any work. After the development department, I reversed my thinking, even if the front end did all the work it was supposed to do. However, it is easy to find the front-end loopholes in the browser, then break through the front-end detection, and directly send the wrong data to the back-end, so the back-end data CHECKER must not be less, which breaks my original inherent mode of thinking. It seems that if people stay in an environment for a long time, there will be some problems of thinking patterns, and living in their own thinking patterns for a long time will be "hypoxia".

About the special functions of Percona server of Mysql and multi-angle thinking is shared here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it 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.