InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it offers a significantly better overall performance and an improved database crash recovery in comparison with the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is preferred by many web developers that write scalable apps, since it works much more effectively with huge volumes of data, while it keeps the server load low. Additionally, it it locks only one row in the database if any information should be updated, while many other engines lock the entire database table and therefore need much more time to fulfill multiple sequential tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for some reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest versions of Joomla™ are two instances of widely used PHP script-based web apps which have switched to InnoDB.
InnoDB in Hosting
Every open-source script-based web application that requires InnoDB will function flawlessly on our advanced cloud hosting platform and the MySQL database storage engine is available with all our hosting plans. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected in accordance with the app’s prerequisites without having to change any setting in your shared hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you will be able to make the most of its full potential. We will carry out regular content backups, so if you unintentionally erase a MySQL database that’s important to you or you overwrite a certain part of it, we will be able to restore everything the way it was just a few hours earlier.