InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a better overall performance and an improved database crash recovery in comparison with the default engine used by the MySQL DBMS – MyISAM. InnoDB is endorsed by many web developers that write scalable software applications, since it works better with large amounts of data, while it keeps the server load at a minimum. Moreover, it locks only a single database row if any info should be updated, whereas lots of other engines lock the entire database table and therefore need much more time to fulfill several sequential tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification cannot be completed for any reason, the operation is rolled back to avoid confusion or data loss. Magento and the latest releases of Joomla™ are two examples of famous open-source script-based applications which have shifted over to InnoDB.
InnoDB in Cloud Hosting
You’ll be able to run any PHP script-powered application that needs InnoDB in case you’ve got a Linux cloud hosting with us, as the storage engine is available on our leading-edge cloud hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly in case this engine is needed. You can install applications that need the MyISAM engine without having any problem as well and, once again, the engine will be selected automatically, so you will not have to change anything manually at any point. On top of that, we’ll also generate regular backups of all the MySQL databases that you’ve got in the shared account, so in case you erase or overwrite anything, we can swiftly restore it the way it was on any of the past 7 days.