Support

Pre-sales

#23989 Is Akeeba good for large DBs?

Posted in ‘Pre-sales and Account Questions’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

user67910
 Hello, some of my websites have quite large databases (around 1GB). Will Akeeba Backup be good for them too? I'm asking this because I see that Akeeba relies (as far as I know) on php MyAdmin own Export feature to create DB backups (gzip), while I found it to be inefficient for large databases and was also advised by the hosting provider to use the terminal for DB backups.
Using the terminal is a bit awkward, so I was wondering whether ABU can handle the backup of large DB's.

Thank you

nicholas
Akeeba Staff
Manager
Nope, Akeeba Backup DOES NOT reply on phpMyAdmin's code! The database backup engine was written by yours truly from scratch. I have identified all the issues regarding long running processes in PHP and working around them using a methodology that I invented and which is being used by other developers now. It's essentially the stepping algorithm that chops the process into multiple page loads which do not time out or run out of memory.

Furthermore I have seen the ill effects of trying to create a MASSIVE single database dump file and then try to gzip it – it takes 2.3x as much memory as its own size for PHP to handle it. That's why the database backup is chopped into roughly 0.5Mb parts which are seamlessly restored in the correct order by our restoration script (ANGIE).

Basically, I've spent nine years of my life working around the problems you are facing with phpMyAdmin and a lot of issues you've never thought of. And, yeah, an SSH command prompt is nice but GUIs are so much easier to use. That's why I've focused on improving our UX and UI.

Back to your question, a 1Gb database isn't all that big. It mostly depends on what kind of data you have in your database. If you are storing very large BLOBs, in the order of Mb per object, you might end up with a memory issue unless you increase PHP's memory_size. If you have millions of tiny records, in the order of less than 512b per row, the backup will take a substantial amount of time because MySQL can only go that fast. If you are on a host with severe CPU usage limitations the backup may fail at first but we can make it work – but it will work MUCH slower to circumvent the CPU limitations.

Just give Akeeba Backup Core a try. It's free of charge and I bet that you'll see why it has been winning a JOSCAR every year, is the most downloaded Joomla! extension and people trust it already for nine years ;)

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!

user67910
Thank you for the deailed and thorough reply! Read it a few times, so absorb all the information.
I definitely tried Akkeba core for the smaller websites and was highly satisfied with it.

Will try it in the larger websites, before moving to the Pro.
Thank you again

nicholas
Akeeba Staff
Manager
You're welcome!

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!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!

Summer vacations: Our support will be closed for replies and new tickets from August 6th to August 21st, 2022 due to summer vacations.