For doing development, we have a separate development database server used for testing where data can be modified or erased or added to freely but the system gains over 500,000 new records a day coming from systems in the field.
To be able to test effectively, it is important that our test DB has data that is fairly fresh (within the last 15 minutes to an hour depending on what we are doing).
The test systems are completely segregated from the live system, so create a replication slave doesn’t seem ideal, especially since we would like to be able to change data without effective the live system.
I thought it might make sense to use Xtrabackup to help copy data from the live system to the test system periodically and maybe even on demand at the click of a button.
I was thinking about doing incrementals and then using rsync to copy the data from the live to the test system (we don’t care if the test system goes down now and again for updates).
I was just wondering if this makes sense or if anyone has done something similar and had some wisdom to share on the matter.
Thanks a lot.