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

Demo address http://fander.asuscomm.com:8008/sqlops_approve/login.html

Ordinary online account: guest, password: 123456

Administrator approval account: admin, password: 123456

Thank my good friend Chen Juncong for providing the cloud host.

In order to liberate DBA from the tedious daily work, developers can be launched through the SQL self-help platform. After the developers submit SQL, they will automatically return optimization suggestions without re-examination by DBA, thus improving the online efficiency and conducive to the establishment of database development specifications.

Draw lessons from the idea of Inception of Qunar Network and integrate SQLAdvisor (Index Optimization suggestion) of Meituan Network, and combine the 40 military rules of DBA written before into the audit rules, which is realized by PHP. It is currently used in our company.

SQL automatic audit mainly accomplishes two purposes:

1. Prevent SQL with poor performance from entering the production system, resulting in a decline in overall performance.

2. Check whether the index designed by the development is reasonable and whether the index needs to be added.

The idea is actually very simple:

1. Obtain the SQL submitted by the developer

2. Analyze the SQL to be executed and touch the pre-defined rules to determine whether the SQL can be approved automatically. Those that fail to pass the audit need to be handled manually.

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.