Re: MariaDB backups using modern MariaDB methods and high performance restores

2018-09-12 Thread Stefan Folkerts
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

Re: MariaDB backups using modern MariaDB methods and high performance restores

2018-09-04 Thread Skylar Thompson
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

Re: MariaDB backups using modern MariaDB methods and high performance restores

2018-09-04 Thread Remco Post
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

Re: MariaDB backups using modern MariaDB methods and high performance restores

2018-09-04 Thread Stefan Folkerts
Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of > Stefan Folkerts > Sent: dinsdag 4 september 2018 11:29 > To: ADSM-L@VM.MARIST.EDU > Subject: Re: MariaDB backups using modern MariaDB methods and high > performance restores > > Yes we did

Re: MariaDB backups using modern MariaDB methods and high performance restores

2018-09-04 Thread Loon, Eric van (ITOPT3) - KLM
[mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Stefan Folkerts Sent: dinsdag 4 september 2018 11:29 To: ADSM-L@VM.MARIST.EDU Subject: Re: MariaDB backups using modern MariaDB methods and high performance restores Yes we did, Repostor uses (at least the version we tested) mysql tools to backup

Re: MariaDB backups using modern MariaDB methods and high performance restores

2018-09-04 Thread Stefan Folkerts
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

Re: MariaDB backups using modern MariaDB methods and high performance restores

2018-09-04 Thread Uwe Schreiber
Hi Stefan, did you have a look on Repostor DATA Protector? Regards Uwe > Am 04.09.2018 um 09:49 schrieb Stefan Folkerts : > > 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 >

MariaDB backups using modern MariaDB methods and high performance restores

2018-09-04 Thread Stefan Folkerts
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