Since you said that the back-up itself is only around 5 minutes, is that timeframe the part that is impacting the site?
The critical timeframe for backup consistency is those 5 minutes, give or take a few seconds. That said, do keep in mind that running a backup does use CPU and memory resources while backing up, as well as bandwidth resources when uploading the backup archive. On lower end servers you MAY observe performance degradation during that time. You're hosted on a fairly decent host so I don't expect this to happen. Your (very limited) impact will be mostly concentrated on those 5 minutes the backup generation takes to complete.
I'm also wondering what is causing the current problem. Compared to my last hosting provider, my new VPS has 4 times the RAM (4 GB), 2 CPUs plus 150 GB disk space. Should I have deleted Akeeba and started over?
Good Lord, no! Reinstalling is voodoo. It rarely solves anything except reset any user errors. We have already established that you don't have any. Reinstalling will only set you back since you'll have to start from scratch, therefore making it more possible that you make new mistakes which we will both be none the wiser about. The end result will be one unhappy client who has no working backup and one frustrated developer who's called to fix a different problem than the one he was presented with. Bad idea. Let's not go there.
Please read the
documentation page on the basic configuration of cloud backups, namely its last paragraphs after the image. As you can see the thing is how much data you can push through the connection between your server and Dropbox. If it takes a lot of time the process will time out and die. Since you can't change the connection performance or the timeout limit of your server the only thing left to change is the amount of data you have to push.
Less data = less time. You can visualize it very easily. It's like transferring water between two containers using a drinking straw. A glass of water will transfer twice as fast as a pint which transfers twice as fast as a quarter gallon bottle. (I hope I got my units of measurement right; I'm used to metric units!) Water is data. Containers are server. Drinking straw is the connection between the servers.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!