InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it provides a better overall performance and a faster database failure recovery in comparison to the default engine used by MySQL – MyISAM. InnoDB is endorsed by a lot of devs that build scalable apps, as it works more effectively with immense data volumes, while it keeps the server load at a minimum. In addition, it it locks only one row in the database if anything should be modified, whereas many other engines lock the entire table and hence require more time to fulfill several consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for some reason, the action is rolled back to avoid scrambling or losing data. Magento and the newest Joomla™ editions are two instances of famous PHP script-driven software applications which have moved to InnoDB.
InnoDB in Hosting
InnoDB is available with all our hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and run any PHP-driven software application which needs the InnoDB storage engine without any problem once you order your account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation process, regardless of whether you make use of our single-click installation tool or create the database and set up the application manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We will carry out regular backups of all your databases, so you can be certain that you will never lose any data if you erase a database by accident or you overwrite some essential information – you will simply need to alert us and we will restore your data the way it was.