InnoDB is a database engine for MySQL databases, which is used by famous PHP-based software apps such as Magento and Joomla™ 3.x. It’s ideal for scalable applications, as it performs stunningly well when handling huge data volumes. Instead of locking the entire database table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same length of time. What’s more, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – rules that specify how data inserts and updates should be treated. In case a particular operation has not been fully completed for whatever reason, the action will be rolled back. Thus, the information in the database will be retained safe and sound and won’t be partially mixed with newly inserted content.

InnoDB in Website Hosting

You’ll be able to install any open-source script-driven app that requires InnoDB in case you have a Linux website hosting with our company, as the MySQL database engine is available on our innovative cloud platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is needed. You can install applications that use the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be selected automatically, so you will not have to modify any setting manually at any moment. Furthermore, we’ll also perform regular backups of all the databases that you have in the shared hosting account, so if you erase or overwrite anything, we can easily get it back to the way it was on any of the previous seven days.