We are running a 3 node Percona MySQL XtraDB Cluster for our enterprise client. I want to schedule hourly, daily, weekly & monthly backups of all databases on these cluster. Is there any shell script available??
Can anyone put some thoughts on below tools configuration in detail.
You don’t need any shell script really to make a backup. A simple full backup is very easy to make using Xtrabackup tool. Of course if you want to automate the whole process, you can use cron, write your own scripts or use third party scripts. I first encourage you to become well familiar with the base Xtrabackup tool first though, so that you are aware of it’s numerous features and usage. Check the documentation, where you’ll find also lot of example recipes.