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

II. Platform introduction

Archer

Automatic SQL operating platform based on inception, supporting work order, audit, authentication, mail, OSC and other functions.

Github address: https://github.com/jly8866/archer

If you decompose archer, I think it can be divided into inception and django.

Inception is internal and responsible for auditing.

Django is external and is responsible for presentation.

Ps: I don't know if the original author will be very depressed about this kind of understanding,

Inception

A MySQL automated operation and maintenance tool that integrates audit, execution, backup and generation of rollback statements

Github address: https://github.com/mysql-inception/inception

Django

Django is an open source Web application framework written by Python. The frame pattern of MT'V is adopted, that is, model M, template T and view V.

Third, secondary development

Some simple secondary development has also been done on the basis of archer:

Block single sign-on

Repair email sending bug

Show full name in Chinese

Assign the specified database instance to the engineer

Next, more features are planned to be integrated into archer:

MSDB

Data archiving

Database backup

Performance report

Inspection report

IV. Summary

At present, archer has been deployed to the production environment, and the DB script has been successfully released for a newly launched x project.

Generally speaking, I think the effect is still ok. At least I have taken a step forward in database automation and DevOps. Compared with the manual audit of SQL two years ago, I have summed up two experiences that I have felt most deeply:

Be sure to use automation tools / platforms, pure labor efficiency is really low

Be sure to find a suitable audit point for everyone to comply with, for SQL audit, it is necessary to control the authority of DB operation in the hands of DBA, not open to the outside world, this point must be strangled! Yes, strangled to death, be cruel! Ha ha

Installation and use of archer

Https://riverdba.github.io/2017/04/15/archer-install/

Https://riverdba.github.io/2017/04/15/archer-install/

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.