What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, because it provides a better overall performance and a faster database failure recovery compared to the default engine used by the MySQL DBMS – MyISAM. InnoDB is used by numerous web developers that build highly scalable software applications, because it works much more efficiently with huge volumes of data, while it keeps the server load at a minimum. In addition, it locks only a single database row in case any information should be edited, whereas many other engines lock the entire database table and thus need more time to complete multiple successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed for any reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest versions of Joomla™ are two instances of famous script-powered software apps which have shifted over to InnoDB.
InnoDB in Cloud Web Hosting
InnoDB is offered with all our Linux cloud web hosting by default, not upon request or as a paid upgrade, so you can install and manage any PHP script-driven application which requires the MySQL database storage engine without encountering any difficulty as soon as you activate your account. InnoDB will be selected automatically as the default engine for a certain database during the app activation process, regardless of whether you use our 1-click installer or create the MySQL database and set up the app manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We’ll keep regular MySQL database backups, so you can be sure that you’ll never lose any content in case you delete a database accidentally or you overwrite some crucial info – you’ll simply need to contact us and we will restore your data the way it was.