Just a thought. This is a linux server, right? So you have linux LVM. I think it should be possible to make a consistent snapshot using MariaDB and LVM. Then you can backup the snapshot and in case of a disaster restore that. Now, I’ve never attempted this, and I don’t know how to do it, but it seems to be the only viable acceptable solution.
> Op 4 sep. 2018, om 09:49 heeft Stefan Folkerts <stefan.folke...@gmail.com> > het volgende geschreven: > > 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 -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622
