SQL automatic audit tool archer
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/
