InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it offers a significantly better overall performance and a faster database crash recovery in comparison to the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is used by a lot of devs that write highly scalable software applications, due to the fact that it works better with large volumes of data, while it keeps the server processing load at a minimum. Also, it locks only a single row in the database if any info should be updated, while lots of other engines lock the entire table and hence need much more time to complete multiple consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification process cannot be completed successfully for whatever reason, the action is rolled back to avoid confusion or data loss. Magento and the newest versions of Joomla™ are two instances of famous open-source script-driven software apps that have shifted over to InnoDB.
InnoDB in Cloud Hosting
Every PHP script-driven web app that requires InnoDB will function impeccably on our innovative cloud platform and the MySQL storage engine is offered with all our cloud hosting packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected in accordance with the app’s prerequisites without having to configure any setting in your shared account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to make the most of its full capacity. We’ll keep regular content backups, so in case you accidentally delete a database that’s important to you or you overwrite certain parts of it, we will be able to restore your content the way it was only a few hours ago.