InnoDB is a database engine for MySQL databases, which is used by widespread open-source script-powered software applications such as Magento and Joomla v3. It is perfect for scalable applications, as it works unbelievably well when processing enormous volumes of data. Rather than locking the entire table to append new information to a database like many other engines do, InnoDB locks only one row, so it can complete much more operations for the same length of time. Additionally, InnoDB offers a better database crash recovery and supports database transactions and foreign keys – a set of rules that indicate how data inserts and updates should be treated. In case a certain task has not been fully completed for whatever reason, the action will be rolled back. Thus, the information in the database will be preserved intact and won’t be partially mixed with newly imported content.

InnoDB in Shared Web Hosting

You’ll be able to run any PHP-based software app that needs InnoDB if you have a shared web hosting plan with our company, as the MySQL database engine is present on our cutting-edge cloud website hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is required. You can install apps that use the MyISAM engine without encountering any problem as well and, again, the engine will be selected automatically, so you will not have to edit anything manually at any point. What’s more, we will also make daily backups of all the databases that you have in the account, so in case you delete or overwrite something, we can swiftly restore it the way it was on any of the previous seven days.