Hi all, I'm currently looking for the best backup option for a large and extremely transaction-heavy MariaDB database environment. I'm talking about up to 100.000.000 transactions a year (payment industry).
It needs to connect to Spectrum Protect to store it's database data, it is acceptable if this is a two stage backup solution but not for restores due to the duration of a two stage restore. We have looked at one option but that used the traditional mysqldump methods that have proven to be unusable for this customer because the restore is up to 8 times slower than the backup and during the backup all transactions are stored to be committed later, this is an issue with this many transactions. zmanda seems to offer newer backup mechanics for MariaDB, i'm wondering if anybody used this with Spectrum Protect that can share some experiences with this solution. Also, any other ideas for solutions that are officially supporting Spectrum Protect would be great. Thanks in advance, Stefan
