InnoDB is a popular database storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got plenty of strong sides which have made it the preferred engine for lots of PHP-powered software apps, including Magento and Joomla, which have switched over to InnoDB permanently. For example, adding immense amounts of data will be faster with InnoDB, since it locks only a single database row to perform a certain task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is handled. To put it simply, importing new or modifying existent data will either be fully completed, or will be aborted and the procedure will be rolled back in case some problem appears in the meantime, so the content that remains in the database won’t be lost.

InnoDB in Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many web hosts, it’s an essential part of the standard set of features that we offer with our web hosting packages. If you’d like to make use of a PHP script-driven app that needs InnoDB specifically, in order to be installed and to work correctly, you won’t need to deal with any obstacles as the MySQL database storage engine is available on our custom-built cloud web hosting platform. No matter if you set up a brand new database and activate an application manually or take advantage of our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application requires InnoDB instead of MyISAM. Besides the exceptional crash recovery that InnoDB offers, we also maintain daily database backups, so we can quickly restore any database in your shared web hosting account.