Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What do Internet database administrators need to do?

2025-02-21 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article mainly explains "what does the Internet database administrator need to do", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn what the Internet database administrator needs to do.

1. Strong monitoring system (supervision + control):

Monitoring is our eyes, and we can't keep an eye on our DB 24 hours a day, so we need a monitoring system to help us keep an eye on it. In case of an anomaly, monitoring not only notifies us, but also requires control. For example, when MySQL goes down from the library, we automatically take it offline through monitoring.

Synchronization from the library fails, and synchronization can be repaired automatically. Moreover, with the increase of machines and instance daemon, we will find that our mobile phone alarms will increase sharply. In order to have a good night's sleep, how can we lower our alarms?

For example: which SMS, which email, and whether the disk space alarms of all machines can be integrated after reporting? This is what our monitoring system must consider.

2. Automatic audit system:

There are many developers and many projects, but the habits of development are inconsistent, which may cause us to overlook the structure of the audit table. In order to ensure online unity, not to be hurt by the magic SQL of development, and not to be overwhelmed by more than N project audits, we must have an automatic table audit.

System, we define some rules, such as: the reserved field cannot be used, the primary key must be INT,BIGINT, etc., then develop the table structure that is ready to go online, and then give suggestions through the system automatic audit, audit pass, automatic launch, audit failure.

3. Slow log analysis system:

With the launch of the automatic audit system, we may miss some SQL whose indexes are not well used, so we need the slow log subsystem to help us. When designing this system, we need to consider whether to grab the slow log in real time, or to push the slow log regularly every day.

Whether to push it to the developer immediately or automatically after analysis, give suggestions to developers, slow logs also consider whether some SQL needs to be filtered, because it may be daily statistics, of course, these are automatic, after the design, there is no need for human intervention

4. Statistical system:

We must clearly know the overall operation of the online DB, the changes in the number of visits, the changes in the number of writes, and the graph is dead, and he will not deceive anyone; we can know through access statistics whether there is malicious access, whether it needs to be optimized, and whether there is a need to increase nodes to withstand more pressure.

5. Backup system:

Believe it or not, I believe that cold backup is always our lifesaver. No matter how well we do, there will always be failures and drop database will also occur. Therefore, a complete backup system is imperative, whether our backup is normal, whether the backed-up data can be recovered and restored.

How much time it takes is what we need to consider in our backup system.

6. Management system:

We have as few as hundreds of machines, or as many as thousands of machines. How to know clearly how many daemon,DB Proxy machines are running on each machine, and how to distribute scripts to master and slave machines separately? we all need a management system to help us complete.

7. Middle layer:

It is a double-edged sword, it can bring us good extensions, such as dynamically adding slave library, master library failure detection, etc.; but it brings the complexity of DBA management, brings more fault points, brings more bug, if DB Proxy performance is not good, it is even worse, and for

To solve the problem of client transparency, we must consider a lot of things, such as connection maintenance, such as character set, last_insert_id, use dbname, etc. If we have human development and maintenance, then I believe Proxy will bring us joy.

At this point, I believe you have a deeper understanding of "what the Internet database administrator needs to do". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.

Views: 209

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report