InnoDB is a popular storage engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got a number of strengths which make it the engine of choice for a lot of PHP-driven software apps, including Joomla and Magento, which have moved to InnoDB for good. For example, importing huge amounts of data will be much faster with InnoDB, because it locks only a single row to carry out an operation, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is treated. Simply put, adding new or editing existing data will either be fully completed, or will be canceled and the operation will be rolled back in case a given problem occurs during the process, therefore the content that remains in the database will not be lost.

InnoDB in Website Hosting

Every PHP-driven software application that needs InnoDB will run flawlessly on our leading-edge cloud web hosting platform and the MySQL database engine is available with all our website hosting plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database will make use of will be selected based on the app’s requirements without the need to modify 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’ll perform daily backups of your content, so in case you unintentionally erase a MySQL database that’s important to you or you overwrite specific parts of it, we will be able to restore your database the way it was just several hours earlier.