Alternative to R1Soft that doesn't slow down

We had similar problem with slow lag due to long backups and it was related to MySQL and how large it can get when most users are packing wordpress sites now.

So that one file can become the whole backup routine in R1soft since on a shared server you have 1 instance of mysql and only privileges to it, so wordpress and mysql and R1 = slow server and long backups in our experience.

We're only now starting to look into WHM and their options about mysql and backup, there's 3 and ours is probably set to 1 big file, then there are many files and both.

It may just be that if we use the selection about many mysql it will allow multiple instances.

I only recently saw that was part of whm and I was under the impression you could only have 1 mysql running, but IF that is the way whm allows mysql to work now with multiple instances, then R1 won't choke on the 1 big mysql we've seen it choking on in our case.

So while exploring our own backup needs I saw your issue with R1 and imo that is the only real backup that works.

We had raid and when our HD started to corrupt the mysql the whole raid failed so baremetal restore took 2 days for the techs to give in and order new hw

Now our contracts say first sign of hd failure the noc must baremetal within X hours to keep our SLA's in order.

HW fails and raids can get corrupt so unless you have a redundant mirror you manually update to prevent corruption I don't see any way to keep anything up that long now.

Anyway, one big file usually mysql is the reason R1 chokes

If anyone knows about the multiple choices now in whm for mysql backup I read about, can you clarify that it is creating multiple instances of mysql on the server, if not, then what is it doing, chopping up mysql for bu purposes only?

 

They was I was reading the OP thread was within whm there was a selection for backup individual mysql whole mysql

So it looked to me as IF mysql was running more than 1 instance which I don't 'believe' is possible

So maybe the thread was discussing within whm the ability to allow a backup of 1 users mysql or maybe it was doing something I was told was not possible, to have more than 1 instance of mysql on a server running

Anyway, I'm still trying to figure out the best way to allow backups for a shared server outside of our catastrophic R1 we do, which doesn't do mysql as 'users' only the server wide instance which means the whole db has to be restore is a corruption happens

So 'backup' is still part of what I have to figure out on a new server we have that is thus far just doing R1 for the whole server and the way it is setup now, I don't see any individual mysql info in whm but inside users cpanels I'm a little familiar with exporting mysqal for that account

Oh, we recently started to use backupguard on lots of wp users as a way to do partial mysql backup for that 1 account should they mess something up and need to restore a full data recover of just their data and mysql info

So I can't vouch yet for if backupguard works but thus far it is creating an archive of that users data

Soon we will take a new site with minor data and a theme and do some changes then try to 'restore' within backupguard to the original settings

If it works, then that will be our 'user level' backup
So backupguard with server wide R1 and then maybe a 2nd drive to mirror data and /var only might be our final solution
,
Backup has always been an issue with me, since I'm old school, 40+ years ago the first 3 words my dad taught me about computers were
backup
backup
backup

So I've always had redundant backup until the net and in the early days without wordpress it was easy, since html was created remotely and then ftp'd into the server so at least data was always remotely held

But wordpress changed that and then we relied on a raid and R1 and when a corrupt drive ruined a whole raid and only R1 saved us, I realized how vulnerable all these mysql intensive cms programs like wordpress are

Anyway, when I saw that whm info about a, b and c as mysql choices I thought hmmm, I don't see that on my whm and then I saw the thread was old and the refer link was dead so now I'm asking about exactly how is mysql options in whm done to allow a user ability to 'backup' other than the usual export in phpadmin stuff in cpanel most users should have access
Anyway, with mysql intensive users we are now installing backupguard as part of our management of their wp