Sorry for not getting back to this sooner Remco & Skylar, we are looking into the SAP protect solution from Repostor that might be a good fit for this customers requirements, I will share the results once I have them with the features/limitations etc.
On Wed, Sep 5, 2018 at 1:54 AM Skylar Thompson <skyl...@uw.edu> wrote: > 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 >
