InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and an improved crash recovery in comparison with the default engine used by MySQL – MyISAM. InnoDB is endorsed by numerous programmers that build highly scalable apps, because it works more effectively with enormous amounts of data, while it keeps the server processing load at a minimum. Additionally, it locks only a single database row if anything should be modified, while many other engines lock the entire table and therefore need more time to carry out multiple consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification cannot be completed successfully for some reason, the operation is rolled back to prevent scrambling or data loss. Magento and the newest Joomla versions are two instances of widespread PHP script-powered web apps which have moved to InnoDB.
InnoDB in Shared Website Hosting
InnoDB is available with all our Linux shared website hosting by default, not as a paid upgrade or upon request, so you can activate and manage any script-powered software app that requires the MySQL database engine without any impediments once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation, irrespective of whether you make use of our 1-click installer or create the database and install the application manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We will maintain regular backups of all your MySQL databases, so you can be certain that you will never lose any content if you erase a database by mistake or you overwrite some important info – you simply have to alert us and we will restore your database the way it was.