We do this with PostgreSQL - take a snapshot and mount it with a preschedulecmd, run an incremental backup on the snapshot, and then unmount and destroy it with a postschedulecmd. The complication for Stefan would be that he would have to restore the entire snapshot in order to have a usable database, which might take too long for his restore objective. PostgreSQL also supports continuous backups of the WAL (journal)[1] which allow for more fine-grained point-in-time restores, but I'm not sure if MySQL/MariaDB have an equivalent solution.
[1] https://www.postgresql.org/docs/current/static/continuous-archiving.html On Tue, Sep 04, 2018 at 05:29:18PM +0200, Remco Post wrote: > 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 -- -- Skylar Thompson (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine
