InnoDB is a popular database storage engine for MySQL. It is an alternative to the default engine – MyISAM, and it has a number of strong sides which have made it the preferred engine for numerous PHP-driven applications, including Magento and Joomla, which have switched to InnoDB for good. For example, importing immense data volumes will be much faster with InnoDB, due to the fact that it locks only a single row to carry out a given operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is tackled. Simply put, importing new or updating existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back if a given problem occurs in the meantime, therefore the content that remains in the database won’t be damaged.

InnoDB in Cloud Web Hosting

While InnoDB is either not available or a paid upgrade with other hosting service providers, it is part of the default set of features that we offer with our cloud web hosting packages. In case you’d like to make use of a PHP script-powered application that needs InnoDB in particular, in order to be installed and to work correctly, you won’t come across any difficulties because the database storage engine is available on our in-house developed cloud hosting platform. Irrespective of whether you create a brand new MySQL database and install an application manually or take advantage of our one-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the given app requires InnoDB instead of MyISAM. Besides the incredible database failure recovery that InnoDB offers, we also perform regular backups of all databases, so we can easily restore any MySQL database in your shared web hosting account.