This script is used to add a quiesced User Checkpoint to the Zerto Journal for a Linux basedMySQL server. The result is that MySQL will flush all pending writes to disk, and pause new writes long enough for Zerto to insert a checkpoint into the journal. Then it unlocks the tables and resumes normal operations
There are several pieces to this project. The script that does the work is placed on your Linux based MySQL server, while the helper script that finds your VPG ID can be ran from any Windows machine that has Zerto Powershell modules installed.
At a high level the process for a MySQL Journal Checkpoint looks like this:
- Cron (or some other scheduler) calls the ZertoMySQLCheckpoint.sh BaSH script
- The script connects to the Zerto REST API for authentication.
- The script then commands MySQL to lock tables and flush to disk.
- The script then calles the Zerto REST API to insert a checkpoint.
- The script then commands MySQL to unlock tables.
- Zerto PowerShell Module must be installed on the Windows Machine
- You must get the VPG ID (can be done by running the GetVPGID.ps1 powershell script.
Download or clone the git repository to your Linux MySQL server, then make the bash scripts (ZertoMySQLCheckpoint.sh) executable.
git clone https://www.github.com/zerto-ta-public/Zerto-MySQL-Checkpoints-Linux/
chmod +x ZertoMySQLCheckpoint.sh
Next, schedule the script to run as often as you would like. Remember that no application can talk to the database for the second or so that it takes to insert the checkpoint.
You can edit the cron file with crontab -e
crontab -e
For a full walkthrough of this project please see https://www.jpaul.me/
This script is considered the initial release and version 1.0.0
- Justin Paul - Initial work - recklessop - Blog
- Shannon Snowden - Script Review - shannonsnowden - Blog
This project is licensed under the GNU GPLv3 License - see the LICENSE.md file for details
- Zerto Documentation
- etc