InnoDB is a storage engine for MySQL databases, which is used by well known script-driven apps such as Magento and Joomla™ 3. It’s perfect for scalable apps, because it performs remarkably well when processing immense volumes of data. Rather than locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can execute much more operations for the same period of time. Plus, InnoDB offers a much faster crash recovery and supports transactions and foreign key constraints – rules that determine how data imports and updates should be treated. If a particular operation has not been entirely completed for some reason, the action will be rolled back. Thus, the information in the database will be retained undamaged and will not be partially merged with new content.
InnoDB in Shared Website Hosting
InnoDB is offered with all our Linux shared website hosting by default, not upon request or as a paid upgrade, so you can install and run any open-source script-based web application that needs the storage engine without encountering any obstacle once you activate your shared account. InnoDB will be selected automatically as the default engine for a particular database during the app activation process, regardless of whether you take advantage of our one-click installation tool or create the MySQL database and activate the application manually, as long as the app requires InnoDB instead of the more popular MyISAM engine. We will keep regular database backups, so you can rest assured that you’ll never lose any content if you erase a database by mistake or you overwrite some essential info – you simply need to alert us and we will restore everything the way it was.