InnoDB is a storage engine for MySQL relational databases, which is used by popular open-source script-based web applications such as Magento and Joomla 3.x. It is perfect for scalable applications, since it performs really well when managing huge data volumes. Instead of locking the whole table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can handle a lot more tasks for the same length of time. In addition, InnoDB offers a much better crash recovery and supports database transactions and foreign keys – a set of rules that specify how data inserts and updates should be treated. In case a given task has not been fully completed for some reason, the action will be rolled back. Thus, the database content will be kept undamaged and won’t be partially mixed with newly added content.

InnoDB in Cloud Website Hosting

While InnoDB is either not offered or it is a paid upgrade with other hosting service providers, it’s included in the standard set of features offered with our cloud website hosting plans. If you would like to use a PHP script-based web application that needs InnoDB in particular, in order to be activated and to function properly, you won’t experience any impediments since the InnoDB storage engine is available on our custom-developed cloud hosting platform. Irrespective of whether you create a brand-new database and activate an app manually or make use of our single-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective app needs InnoDB instead of MyISAM. Besides the incredible crash recovery that InnoDB offers, we also carry out regular backups of all databases, so that we can quickly recover any MySQL database in your shared web hosting account.