InnoDB
Discover what a database engine is, what exactly are the pros of the InnoDB engine and why it's gaining that much popularity.
InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it offers a better overall performance and a faster database crash recovery compared with the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by plenty of devs that run highly scalable software apps, due to the fact that it works much more efficiently with large volumes of data, while it keeps the server load low. Moreover, it uses row-level locking if any info should be updated, whereas many other engines lock the entire table and hence require much more time to handle several successive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for some reason, the action is rolled back to avoid confusion or losing data. Magento and the latest versions of Joomla™ are two examples of widespread PHP script-driven software applications which have shifted over to InnoDB.
-
InnoDB in Shared Website Hosting
You will be able to make use of any open-source script-based application that needs InnoDB if you have a
shared website hosting plan with our company, as the MySQL database engine is present on our avant-garde cloud web hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is required. You can run apps that use the MyISAM engine without the need to deal with any difficulty as well and, again, the engine will be pre-selected, so you will not need to modify anything manually at any moment. On top of that, we’ll also make regular backups of all the MySQL databases that you have in your shared hosting account, so in case you erase or overwrite anything, we can quickly restore it the way it was on any of the previous seven days.