What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a popular storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has a lot of strong sides which make it the preferred engine for a lot of PHP-powered software applications, among them Joomla™ and Magento, which have switched to InnoDB for good. For example, adding large data volumes will be faster with InnoDB, as it locks only a single database row to accomplish a specific task, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is handled. In simpler words, importing new or updating existing data will either be entirely completed, or will be annulled and the operation will be rolled back if a certain issue shows up in the meantime, hence the content that remains in the database won’t be lost.
InnoDB in Web Hosting
While InnoDB is either not available or a paid upgrade with other web hosting providers, it’s an essential part of the standard set of features that we offer with our web hosting packages. If you want to make use of a PHP-powered application that needs InnoDB specifically, in order to be activated and to function correctly, you will not encounter any problems as the storage engine is available on our in-house developed cloud platform. Irrespective of whether you set up a brand new MySQL database and activate an app manually or use our 1-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the given application needs InnoDB rather than MyISAM. Besides the amazing crash recovery that InnoDB is offering, we also maintain regular database backups, so we can quickly recover any database in your shared hosting account.