> 100.000.000 transactions/year is a little over 3 transactions per second.
With transaction I mean payment, not a single database transaction, I don't know how many database transactions a single payment creates. What I do know is that they are running a high database load, especially during peak hours. I'm sure there are databases doing many many more transactions than this but it's enough to rule out the mysqldump backup solution for them knowing what they know about how it operates. On Tue, Sep 4, 2018 at 1:12 PM Loon, Eric van (ITOPT3) - KLM < eric-van.l...@klm.com> wrote: > Hi Stefan, > Just out of curiosity: 100.000.000 transactions/year is a little over 3 > transactions per second. I would not call that heavily used, are these > figures correct? > Kind regards, > Eric van Loon > Air France/KLM Storage Engineering > > -----Original 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, 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 > > > ******************************************************** > For information, services and offers, please visit our web site: > http://www.klm.com. This e-mail and any attachment may contain > confidential and privileged material intended for the addressee only. If > you are not the addressee, you are notified that no part of the e-mail or > any attachment may be disclosed, copied or distributed, and that any other > action related to this e-mail or attachment is strictly prohibited, and may > be unlawful. If you have received this e-mail by error, please notify the > sender immediately by return e-mail, and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its > employees shall not be liable for the incorrect or incomplete transmission > of this e-mail or any attachments, nor responsible for any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > ******************************************************** >
