InnoDB is a database storage engine for MySQL databases, which is used by widespread script-driven web applications like Magento and Joomla 3.x. It’s perfect for scalable apps, since it performs very well when processing large 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 database row, so it can complete much more operations for the same period of time. Moreover, InnoDB offers a much better database crash recovery and supports database transactions and foreign key constraints – a set of rules that indicate how data inserts and modifications should be handled. In case a specific task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the content in the database will be kept safe and sound and won’t be partially merged with newly entered content.
InnoDB in Cloud Hosting
Every PHP script-based app that needs InnoDB will run impeccably on our leading-edge cloud platform and the MySQL database storage engine is offered with all our cloud hosting plans. Each time you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database will use will be selected on the basis of the app’s requirements without having to change any setting in your web hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to make the most of its full capacity. We will create daily content backups, so in case you unintentionally erase a MySQL database that is important to you or you overwrite some part of it, we will be able to restore your database the way it was just a few hours earlier.