InnoDB is a database storage engine for MySQL databases, which is used by widely used PHP-driven apps such as Magento and Joomla 3.x. It’s ideal for scalable apps, since it works stunningly well when managing enormous data volumes. Instead of locking the whole table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can complete much more operations for the same length of time. Plus, InnoDB offers a much better database failure recovery and supports database transactions and foreign keys – a set of rules that prescribe how data inserts and updates should be treated. In case a specific operation has not been thoroughly completed for some reason, the action will be rolled back. In this way, the content in the database will be preserved intact and will not be partially merged with new content.

InnoDB in Cloud Hosting

Any open-source script-driven web app that needs InnoDB will function flawlessly on our innovative cloud web hosting platform and the MySQL database storage engine is available with all our cloud hosting plans. Each time you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected based on the app’s requirements without the need to update any setting in your shared account. InnoDB will be chosen automatically for any app that requires this particular engine and you’ll be able to take advantage of its full capacity. We will carry out daily content backups, so if you accidentally delete a database that is important to you or you overwrite specific parts of it, we will be able to restore the database the way it was only a couple of hours ago.