InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it provides a better overall performance and a faster database crash recovery in comparison to the default engine used by the MySQL database management system – MyISAM. InnoDB is preferred by a lot of developers that run scalable software applications, since it works much more effectively with immense amounts of data, while it keeps the server load low. Also, it locks only a single row in the database if any information should be modified, whereas many other engines lock the entire table and hence require much more time to accomplish several successive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification cannot be completed for any reason, the action is rolled back to avoid confusion or data loss. Magento and the latest Joomla™ versions are two instances of popular open-source script-based web applications which have moved to InnoDB.
InnoDB in Hosting
While InnoDB is either a paid upgrade or it is not available at all with many website hosting service providers, it’s an essential part of the default set of services that we offer with our hosting plans. In case you’d like to make use of an open-source script-driven app that requires InnoDB specifically, in order to be activated and to work correctly, you won’t face any difficulties since the InnoDB database storage engine is available on our custom cloud web hosting platform. Irrespective of whether you set up a brand new MySQL database and activate an application manually or use our single-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective app requires InnoDB instead of MyISAM. In addition to the amazing crash recovery that InnoDB is offering, we also keep daily backups of all databases, so that we can easily restore any database in your shared web hosting account.