InnoDB is a very popular storage engine for MySQL. It is an alternative to the default MyISAM engine and it has plenty of strong sides that make it the preferred engine for lots of PHP-powered software apps, such as Magento and Joomla, which have moved to InnoDB for good. For example, importing large amounts of data will be much faster with InnoDB, due to the fact that it locks only one row to complete a particular operation, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the information is treated. Put simply, appending new or updating existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case any problem occurs during the process, therefore the content that remains in the database won’t be lost.

InnoDB in Cloud Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting providers, it’s an integral part of the default set of services that we offer with our cloud web hosting packages. In case you wish to use a script-based web application that needs InnoDB particularly, in order to be installed and to work correctly, you will not encounter any problems since the InnoDB storage engine is available on our in-house developed cloud Internet hosting platform. Regardless of whether you create a new database and activate an app manually or make use of our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the given app needs it instead of MyISAM. In addition to the exceptional database failure recovery offered by InnoDB, we also carry out daily backups of all databases, so that we can quickly recover any database in your shared website hosting account.