Our bike or scripts to facilitate the life of the admin

In the comments to one of the previous articles, there was a request to put on public display all our practices used in everyday life. Together, everything was collected, described and posted on github.
Under the cat link to the repository and a brief description of the scripts.


Repository link: github.com/olemskoi/centos-admin
Here is a brief description of the scripts and how to work with them.

1. admin.sh

use ./admin.sh <create | remove> [ip]
')
Creates a site under the template. That is, nginx apache configs, makes a reload of services and creates a mysql and / or postgresql database. Depending on the presence of the /root/.mysql file /root/.postgresql.
It also creates an FTP account based on pure-ftpd.
Information on access displays in STDOUT.

use ./admin.sh <mysql | postgresql> Creates a database. Information on access displays in STDOUT.

use ./admin.sh <change_root_pass> <mysql | postgresql>

Changes the superuser password.

2. apache-top.py, apachetop.sh

Script showing apache requests in real time.
Requires some nginx configuration:
location / apache-status {
proxy_pass 127.0.0.1 : 8080;
proxy_redirect off;
proxy_set_header Host $ host;
proxy_set_header X-Real-IP $ remote_addr;
proxy_set_header X-Forwarded-For $ proxy_add_x_forwarded_for;

proxy_read_timeout 300;
client_max_body_size 256m;

proxy_buffer_size 16k;
proxy_buffers 32 16k;
}
As well as apache settings:
ServerName localhost

<Location / apache-status>
SetHandler server-status

3. cacti-php-fpm.sh

Script for setting up web services for monitoring php-fpm in cacti

4. highload-report.sh

The script collects complete information about the system at a particular point in time and sends information to the mail:
*) process list, sorting by CPU
*) process list, sort by MEM
*) mysql query list
*) apache request list
*) nginx request list
*) list of netstat connections sorted by ip
*) total TCP / UDP sessions
*) mysql status

The script starts monit when la> X

5. httpd-restart.sh

Just restart apache, need for monit

6. maldet.sh

Script to check websites for viruses, uses maldet

7. mongodb-backup.sh

The mongoDB backup script. Made from mysql-backup.sh

8. mysql-backup.sh

Mysql backup Detailed description in this article.

9. mysql-slave-check.sh

The script checks the status of the mysql slave with the notification.

10. mysql-table-check.sh

Script Table Verification

11. php-cron.sh

Script for adding php cron tasks

12. postfix.sh

Stop / start postfix, need for monit.

13. postgresql-backup.sh

The postgresql backup script. It works in the same way as mysql-backup.sh with the exception of its special features.

14. redis-backup.sh

Script backup redis. It works in the same way as mysql-backup.sh with the exception of its special features.

15. redis-ping.sh

Script checking liveliness redis.

16. rstr-xtra-mysql.sh

The script to work with mysql xtrabackup

17. unicornstat.pl, unicornstat.sh

Script for getting statistics on unicorn work

18. vz-exec.pl

Script for governing openvz containers via ssh