InnoDB is a database engine for MySQL relational databases, which is used by widespread script-based web applications such as Magento and Joomla 3. It’s perfect for scalable applications, because it works really well when processing immense data volumes. Instead of locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can perform a lot more tasks for the same length of time. Also, InnoDB offers an improved database failure recovery and supports transactions and foreign keys – a set of rules that determine how data inserts and updates should be handled. In case a certain task hasn’t been entirely completed for any reason, the action will be rolled back. Thus, the content in the database will remain undamaged and will not be partially mixed with newly added content.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosting providers, it is an essential part of the default set of features that we’re offering with our shared hosting plans. In case you wish to use a PHP-based web app that requires InnoDB specifically, in order to be installed and to operate properly, you won’t have to deal with any problems since the InnoDB storage engine is available on our custom-built cloud website hosting platform. Regardless of whether you create a brand new database and install an application manually or make use of our one-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the respective application needs it instead of MyISAM. In addition to the exceptional database failure recovery that InnoDB offers, we also maintain regular database backups, so we can swiftly recover any database in your shared web hosting account.