InnoDB is a storage engine for MySQL relational databases, which is used by popular PHP script-based applications such as Joomla™ 3 and Magento. It’s perfect for scalable applications, because it performs astonishingly well when managing enormous data volumes. Rather than locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same period of time. Additionally, InnoDB offers an improved database crash recovery and supports transactions and foreign key constraints – rules that prescribe how data inserts and modifications should be handled. In case a given task has not been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will be preserved intact and will not be partially mixed with newly entered content.
InnoDB in Shared Hosting
Any open-source script-powered application that requires InnoDB will run flawlessly on our innovative cloud hosting platform and the MySQL storage engine is available with all our shared hosting
plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected based on the app’s prerequisites without having to configure any setting in your shared account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to get the most out of its full capacity. We’ll make regular content backups, so if you unintentionally erase a MySQL database that you need or you overwrite some part of it, we will be able to restore your content the way it was only a few hours ago.