What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a MySQL database engine, which has been gaining in popularity lately, because it provides a significantly better overall performance and an improved database crash recovery in comparison with the default engine that is used by MySQL – MyISAM. InnoDB is preferred by a lot of devs that create highly scalable applications, as it works more effectively with immense volumes of data, while it keeps the server load low. What’s more, it locks only one database row in case any information should be modified, whereas many other engines lock the entire database table and hence need much more time to carry out multiple consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for some reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest releases of Joomla™ are two examples of widely used PHP script-powered web applications which have shifted over to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either a paid upgrade or it is not available at all with many other hosting companies, it’s an essential part of the default set of services offered with our shared hosting plans. If you’d like to make use of a PHP-based software app that requires InnoDB in particular, in order to be installed and to operate correctly, you won’t come across any obstacles since the MySQL database storage engine is available on our custom-built cloud Internet hosting platform. No matter if you create a brand new MySQL database and activate an app manually or take advantage of our 1-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the given app needs InnoDB rather than MyISAM. Besides the exceptional database crash recovery that InnoDB is offering, we also keep daily backups of all databases, so that we can quickly recover any database in your shared account.