InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it provides a much better overall performance and a faster crash recovery compared with the default engine used by MySQL – MyISAM. InnoDB is preferred by lots of programmers that write scalable apps, since it works better with large data volumes, while it keeps the server processing load low. What’s more, it locks only one database row if any info should be updated, whereas lots of other engines lock the entire table and therefore require much more time to carry out several sequential tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification process cannot be completed successfully for any reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the latest releases of Joomla are two instances of widely used PHP-powered web applications which have shifted over to InnoDB.
InnoDB in Shared Website Hosting
InnoDB is offered with all our Linux shared website hosting packages by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any PHP-powered software application that needs the database storage engine without having to deal with any difficulty as soon as you activate your shared website hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation process, regardless of whether you make use of our one-click installer or create the database and install the application manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We’ll keep regular MySQL database backups, so you can rest assured that you won’t ever lose any data in case you erase a database by mistake or you overwrite some essential info – you’ll just have to inform us and we will restore your content the way it was.