InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it offers a much better overall performance and a faster database failure recovery compared with the default engine used by the MySQL DBMS – MyISAM. InnoDB is endorsed by a lot of programmers that build scalable applications, due to the fact that it works much more efficiently with enormous amounts of data, while it keeps the server load at a minimum. Additionally, it locks only one database row in case any information should be edited, while lots of other engines lock the entire database table and therefore need more time to process multiple successive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – in case the entire data modification process cannot be completed for some reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the latest releases of Joomla™ are two examples of widespread PHP-based software apps that have switched over to InnoDB.
InnoDB in Cloud Web Hosting
You’ll be able to make use of any open-source script-driven software app that needs InnoDB in case you’ve got a Linux cloud web hosting package with us, as the storage engine is available on our leading-edge cloud website hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is needed. You can activate applications which need the MyISAM engine without having any difficulty as well and, again, the engine will be selected automatically, so you won’t have to change anything manually at any moment. On top of that, we’ll also carry out daily backups of all the databases that you’ve got in the shared account, so if you erase or overwrite something, we can easily get it back to the way it was on any of the past seven days.