Previously i just shared the full backup script. Now we will take incremental backups using last_checkpoints. Basically, what this script will do is that …
Read More »Anil Joshi
Mysql Database Backup Using Percona Xtrabackup (Automated Bash Script)
Below is the simple script for taking non-blocking Mysql physical backup using percona xtrabackup toolkit. This backup is encrypted using AES256 algorithm. [crayon-66ff8718a2499279115796/] –extra-lsndir: save …
Read More »Mysql Physical Backup Using Percona Xtrbackup Tool
Percona Xtrabackup is open source backup solution for Percona & mysql server. It will not block the database or very minimal lock while performing …
Read More »Bash Script for Backup of Mysql Users & Privileges
Below is a simple script which backup Mysql users & grants into separate sql file. So,if you are taking particular database backup then this …
Read More »Bash Script for Mysql General Log Rotation
Below is the simple script for monitoring & auditing mysql general logs.This can be set as per the need(eg. daily,horly).It will help in capturing …
Read More »Bash Script for Mysql Error Log Rotation
Below is the simple script for monitoring mysql error logs. You can set the cron jobs as per your need(eg. daily,hourly) [crayon-66ff8718a2ae4492789746/] Hope this …
Read More »