READ DATABASE CREATE t-1

MySQL & MariaDB
1

Dear Percona Support Team,
l am currently managing a Percona XtraDB Cluster (pxc57) and need to set up a read-only database with a lag behind the cluster. Specifically, I require a database that is one time period behind, for example, T-1, to run reports on. I would like this read-only database to sync with the cluster twice a day.

how to achieve this setup?
Besides is there another way?

2

Create the replica, then CHANGE MASTER TO ... MASTER_DELAY=XXX where XXX is the number of seconds you want delayed.

If you want this to happen only 2 times a day, then you will need to create a cron job to ‘stop slave’, then ‘start slave’.