InnoDB is a storage engine for MySQL relational databases, which is used by famous PHP-based software apps like Joomla™ 3 and Magento. It is ideal for scalable apps, because it performs very well when managing huge volumes of data. Instead of locking the entire table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can process much more operations for the same period of time. Furthermore, InnoDB offers a much faster crash recovery and supports transactions and foreign keys – rules that specify how data inserts and updates should be handled. If a specific operation hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will be kept safe and sound and won’t be partially mixed with newly added content.

InnoDB in Shared Web Hosting

While InnoDB is either not available or a paid upgrade with many hosting service providers, it’s an essential part of the standard set of services that we’re offering with our shared web hosting plans. In case you’d like to use a PHP script-powered web application that needs InnoDB in particular, in order to be activated and to work correctly, you won’t need to deal with any problems as the MySQL database storage engine is available on our in-house built cloud Internet hosting platform. No matter if you set up a brand-new MySQL database and install an app manually or use our 1-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the particular application needs InnoDB instead of MyISAM. In addition to the amazing database failure recovery that InnoDB offers, we also keep daily backups of all databases, so that we can swiftly recover any database in your shared web hosting account.