InnoDB is a storage engine for MySQL relational databases, which is used by popular script-driven applications like Joomla 3.x and Magento. It is perfect for scalable applications, since it works exceptionally well when processing immense amounts of data. Rather than locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can process much more operations for the same period of time. Besides, InnoDB offers a much faster crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and modifications should be treated. In case a given task has not been entirely completed for any reason, the action will be rolled back. In this way, the information in the database will stay intact and will not be partially merged with newly added content.

InnoDB in Web Hosting

While InnoDB is either not offered or it is a paid upgrade with other hosting providers, it’s an essential part of the default set of features that we are offering with our web hosting plans. In case you would like to make use of an open-source script-powered web app that needs InnoDB in particular, in order to be activated and to work correctly, you won’t encounter any difficulties since the MySQL storage engine is available on our custom cloud hosting platform. Regardless of whether you set up a new database and install an app manually or take advantage of our single-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular app needs it instead of MyISAM. Besides the excellent crash recovery that InnoDB is offering, we also perform regular backups of all databases, so that we can quickly recover any MySQL database in your shared account.