Hi!
Trying to understand selective copy connected with database agents (mysql and psql). My config is :
- two storage polices (one from data and one for log)
- full aux copy from primary to secondary DC
- selective copy to tape (for both log and data SP; first full backup each week with 4 week retention, first full backup each month with 6 months extended retention)
What we see is not consistent across DBA agents and logs are not always copied as we would expect together with data ;
- postgres (FS based) write data and logs to separate storage polices, selective copy works as expected
- psql (with intelisnap) not execute log backup during full, logs are not copied to offsite copy, recovery need to based only on logs present on filesystem during snapshot
- mysql (by xtrybackup) is doing log backup to same SP during full, so logs are not in storage policy in what we expect to be and are not copied to offsite copy, during recovery only data is restored
Do we have any guidance on above? Or configuration is too complicated and i should use one storage policy for data and logs?