InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it provides a much better overall performance and an improved database failure recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is used by lots of programmers that build scalable software apps, due to the fact that it works better with enormous amounts of data, while it keeps the server load low. Moreover, it locks only a single row in the database in case any info should be modified, while many other engines lock the entire table and therefore require much more time to complete multiple successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification cannot be completed for whatever reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the latest Joomla™ versions are two examples of widely used open-source script-based apps that have moved to InnoDB.
InnoDB in Website Hosting
You will be able to activate any open-source script-based web app that needs InnoDB if you have a website hosting with our company, as the MySQL database engine is present on our innovative cloud website hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is needed. You can run apps that need the MyISAM engine without the need to deal with any problem as well and, again, the engine will be pre-selected, so you will not need to change any setting manually at any time. What’s more, we’ll also perform regular backups of all the databases that you have in the shared web hosting account, so if you delete or overwrite something, we can easily restore it the way it was on any of the past 7 days.