What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it offers a better overall performance and an improved database failure recovery in comparison with the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by plenty of devs that write highly scalable web applications, as it works much better with huge data volumes, while it keeps the server processing load at a minimum. Also, it locks only one database row if any information should be edited, whereas lots of other engines lock the entire database table and thus require much more time to process several successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification process cannot be completed successfully for some reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla™ versions are two instances of widespread PHP-based web applications that have shifted over to InnoDB.
InnoDB in Cloud Web Hosting
While InnoDB is either not available or a paid upgrade with other hosting service providers, it’s part of the standard set of features that we’re offering with our cloud web hosting plans. In case you want to use a PHP script-based web app that needs InnoDB particularly, in order to be installed and to function correctly, you won’t encounter any difficulties because the storage engine is available on our custom-built cloud web hosting platform. Regardless of whether you set up a new database and install an application manually or take advantage of our 1-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the given application requires it instead of MyISAM. Besides the exceptional crash recovery offered by InnoDB, we also generate daily database backups, so we can quickly restore any database in your shared web hosting account.