InnoDB is a popular database engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has numerous advantages which make it the preferred engine for many PHP-powered web apps, including Joomla and Magento, which have moved to InnoDB permanently. For example, importing enormous data volumes will be faster with InnoDB, as it locks only one database row to carry out a task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is handled. In simpler words, appending new or editing existent data will either be fully completed, or will be aborted and the procedure will be rolled back in case some issue shows up during the process, thus the content that remains in the database will not be damaged.

InnoDB in Cloud Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosting providers, it is an essential part of the default set of features offered with our cloud hosting packages. In case you would like to use a script-driven application that requires InnoDB particularly, in order to be installed and to work correctly, you will not have to deal with any obstacles because the MySQL database storage engine is available on our custom-built cloud website hosting platform. Irrespective of whether you create a brand new database and install an app manually or take advantage of our single-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the given application requires InnoDB instead of MyISAM. Besides the incredible database failure recovery offered by InnoDB, we also carry out daily backups of all databases, so that we can easily restore any database in your shared account.