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

This article mainly introduces what tools need to be considered in MySQL. It has certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let Xiaobian take you to understand it together.

Generally speaking, I have considered the following aspects, and the content has been appropriately deleted.

Operations Management Tools

Data Backup Recovery Tool

Database optimization tools

client tools

performance testing tool

Database version management tools

Database auditing tools

Let me tell you one by one, there are better tools and you are welcome to shoot bricks.

Operations Management Tools

Percona-toolkit, this tool has several highlights, such as master-slave delay detection, data repair, online DDL, etc.

Database Backup Recovery Tool

Mydumper, this tool is still popular, can make a good supplement to the original mysqldump. Tencent Cloud customizes mydumper as the default backup tool.

xtrabackup, a tool from Percona, good at doing physical backups, and more inclined to be a combination of full backup + backup, for the choice of version

mysqlpump, MySQL new version of the backup tool, but the effect is not as good as imagined, the biggest pain point should be the backup IO problem can not be greatly solved, because all in the last backup out of the file, there is no split.

Database optimization tools

This tool is divided into two levels: MySQL real-time state analysis and full log analysis

MySQL real-time status analysis:

1）innotop

2）orzdba

3)mytop

4)orztop

Full log analysis

1）pt-query-digest

2）Anemometer

3) Slow Query Analyzer Based on Network Layer

4. client tools

SQLyog

Navicator

workbench

The above three tools, the first two domestic more practical, the tool itself is no problem, hard injury or license, the third is Oracle provided, free, more comprehensive features, compared to data modeling, SQL development, data management, data migration and other functions, personal or more recommended.

5. performance testing tool

sysbench

tpcc-mysql

6. Database version management tools

Liquidbase is a tool that has to be carefully considered and is a little more difficult than expected.

7. MySQL Audit

MySQL audit, third-party open source

Thank you for reading this article carefully. I hope that Xiaobian's "What tools need to be considered in MySQL" article will help everyone. At the same time, I hope that everyone will support you a lot and pay attention to the industry information channel. More relevant knowledge is waiting for you 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.