InnoDB is a very popular database engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got many pluses that have made it the preferred engine for lots of PHP-based applications, among them Joomla and Magento, which have moved to InnoDB permanently. For instance, adding huge amounts of data will be much faster with InnoDB, as it locks only one database row to perform an operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is treated. In simpler words, importing new or editing existent data will either be entirely completed, or will be aborted and the operation will be rolled back in case a certain problem occurs in the meantime, thus the content that remains in the database won’t be lost.

InnoDB in Cloud Website Hosting

While InnoDB is either not available or a paid upgrade with many hosting companies, it is included in the standard set of services that we’re offering with our cloud website hosting packages. If you would like to make use of a PHP-based app that needs InnoDB particularly, in order to be installed and to perform correctly, you will not come across any impediments because the storage engine is available on our custom-developed cloud website hosting platform. No matter if you create a brand-new MySQL database and install an application manually or make use of our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the respective app requires it rather than MyISAM. In addition to the exceptional database crash recovery that InnoDB offers, we also carry out regular database backups, so we can swiftly recover any database in your shared website hosting account.