InnoDB is a database engine for MySQL relational databases, which is used by popular open-source script-based software applications such as Magento and Joomla v3. It’s ideal for scalable applications, since it performs remarkably well when handling huge amounts of data. Instead of locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can handle a lot more operations for the same length of time. Besides, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – rules that determine how data imports and updates should be treated. If a specific operation has not been fully completed for any reason, the action will be rolled back. Thus, the content in the database will be kept safe and sound and won’t be partially merged with new content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with other website hosting service providers, it is part of the standard set of features offered with our cloud hosting packages. If you wish to use a PHP script-powered web application that needs InnoDB specifically, in order to be activated and to work properly, you will not have to deal with any obstacles since the InnoDB storage engine is available on our custom-built cloud platform. Irrespective of whether you set up a brand-new MySQL database and install an application manually or take advantage of our one-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the application needs it instead of MyISAM. Besides the amazing database crash recovery that InnoDB offers, we also carry out daily backups of all databases, so that we can quickly recover any MySQL database in your shared account.