InnoDB is a database engine for MySQL databases, which is used by well known script-driven apps such as Joomla™ 3.x and Magento. It’s perfect for scalable applications, as it performs astonishingly well when managing enormous amounts of data. Rather than locking the whole table to append new information to a database as many other engines do, InnoDB locks only one row, so it can perform much more operations for the same period of time. Besides, InnoDB offers a better database failure recovery and supports transactions and foreign key constraints – rules that define how data inserts and modifications should be treated. If a given operation has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will remain safe and sound and won’t be partially merged with new content.

InnoDB in Website Hosting

You can use any PHP script-powered web app that requires InnoDB in case you have a Linux website hosting with us, as the MySQL storage engine is available on our leading-edge cloud platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is required. You can run apps which need the MyISAM engine without encountering any problem as well and, once again, the engine will be pre-selected, so you will not have to change anything manually at any moment. What’s more, we will also create regular backups of all the MySQL databases that you have in your shared hosting account, so if you erase or overwrite something, we can swiftly get it back to the way it was on any of the past 7 days.