# READ DATABASE CREATE t-1

**URL:** <https://forums.percona.com/t/read-database-create-t-1/32594>\
**Category:** MySQL & MariaDB\
**Created:** [August 26, 2024, 8:08am UTC](https://forums.percona.com/t/read-database-create-t-1/32594 "2024-08-26T08:08:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Omer\_Faruk\_Icen](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/omer_faruk_icen/32/17641_2.png) [@Omer\_Faruk\_Icen](https://forums.percona.com/u/Omer_Faruk_Icen)\
**Post date:** [August 26, 2024, 8:08am UTC](https://forums.percona.com/t/read-database-create-t-1/32594/1 "2024-08-26T08:08:58Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [August 26, 2024, 2:52pm UTC](https://forums.percona.com/t/read-database-create-t-1/32594/2 "2024-08-26T14:52:07Z")

</div>

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’.