Yes we did, Repostor uses (at least the version we tested) mysql tools to backup and restore the database, the backup-impact and restore performance of the tool doesn't suite this customer environment. Now, let me be clear, I don't want to be negative about Repostor data protector because it worked great and is very easy to setup and use, it's just that the very high amount of transactions that are done at this site eliminate this tool as a solution.
I will for sure advise Repostor data protector solutions when the demands are not so extreme as they are at this site. On Tue, Sep 4, 2018 at 11:20 AM Uwe Schreiber <uwe.h.schrei...@t-online.de> wrote: > Hi Stefan, > > did you have a look on Repostor DATA Protector? > > Regards Uwe > > > Am 04.09.2018 um 09:49 schrieb Stefan Folkerts < > stefan.folke...@gmail.com>: > > > > 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 >
