InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a significantly better overall performance and a faster crash recovery in comparison to the default engine that is used by MySQL – MyISAM. InnoDB is preferred by lots of devs that create scalable software applications, since it works better with huge volumes of data, while it keeps the server load low. Also, it locks only a single row in the database in case any information should be edited, while lots of other engines lock the entire database table and thus require more time to execute multiple sequential tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for any reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the newest releases of Joomla are two instances of widespread open-source script-driven software apps which have switched over to InnoDB.
InnoDB in Cloud Web Hosting
You will be able to install any PHP script-driven application that requires InnoDB if you’ve got a Linux cloud web hosting package with us, as the database engine is present on our advanced cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably in case this engine is required. You can install applications that require the MyISAM engine without encountering any difficulty as well and, again, the engine will be selected automatically, so you will not need to update anything manually at any moment. What’s more, we will also perform daily backups of all the databases that you’ve got in your shared web hosting account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the past 7 days.