InnoDB is a database engine for MySQL relational databases, which is used by well known PHP-powered software applications such as Magento and Joomla 3. It’s ideal for scalable applications, since it works unbelievably well when handling immense data volumes. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can complete much more tasks for the same length of time. Moreover, InnoDB offers a faster database crash recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data inserts and updates should be handled. If a certain task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the database content will stay safe and sound and will not be partially merged with newly added content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosting providers, it’s an essential part of the default set of services that we offer with our cloud hosting plans. In case you want to use an open-source script-based software application that requires InnoDB in particular, in order to be installed and to operate correctly, you will not face any difficulties since the InnoDB database engine is available on our in-house developed cloud web hosting platform. Irrespective of whether you set up a brand new database and install an application manually or take advantage of our 1-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the respective app requires it instead of MyISAM. Besides the exceptional database crash recovery offered by InnoDB, we also store daily backups of all databases, so that we can easily restore any MySQL database in your shared website hosting account.