InnoDB is a database engine for MySQL relational databases, which is used by popular PHP-based web applications like Magento and Joomla 3. It is ideal for scalable applications, as it performs incredibly well when handling large amounts of data. Rather than locking the whole database table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same period of time. Plus, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – a set of rules that indicate how data imports and modifications should be handled. If a specific operation hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the content in the database will remain undamaged and will not be partially mixed with new content.

InnoDB in Cloud Website Hosting

Every script-driven application that requires InnoDB will run flawlessly on our cutting-edge cloud hosting platform and the MySQL database storage engine is offered with all our cloud website hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will use will be selected in accordance with the app’s requirements without the need to modify any setting in your shared hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you will be able to get the most out of its full capacity. We’ll perform daily backups of your content, so in case you unintentionally erase a database that’s important to you or you overwrite a certain part of it, we’ll be able to restore the database the way it was only a couple of hours earlier.