InnoDB is a popular database engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has numerous advantages which have made it the engine of choice for numerous PHP-driven software apps, among them Magento and Joomla, which have shifted over to InnoDB for good. For example, importing immense volumes of data will be faster with InnoDB, as it locks only a single row to execute a specific operation, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the data is treated. Simply put, adding new or modifying existing data will either be entirely completed, or will be aborted and the procedure will be rolled back in case a given problem occurs in the meantime, thus the content that remains in the database won’t be damaged.

InnoDB in Cloud Hosting

Any PHP-based app that requires InnoDB will run flawlessly on our advanced cloud hosting 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 tool creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected based on the app’s specifications without the need to configure any setting in your hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you will be able to make the most of its full potential. We will perform daily content backups, so if you unintentionally remove a database that is important to you or you overwrite specific parts of it, we’ll be able to restore your data the way it was just a couple of hours ago.