InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it provides a significantly better overall performance and an improved database failure recovery in comparison to the default engine used by the MySQL database management system – MyISAM. InnoDB is endorsed by a lot of developers that write scalable software apps, because it works much more efficiently with enormous data volumes, while it keeps the server load at a minimum. Moreover, it locks only a single database row in case any information should be edited, while many other engines lock the entire database table and therefore need more time to carry out multiple consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed successfully for whatever reason, the action is rolled back to avoid confusion or the loss of data. Magento and the latest releases of Joomla are two instances of widely used script-based web apps which have switched to InnoDB.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated packages support InnoDB and you’ll be able to get the most out of all the features of this database storage engine with any PHP script-powered app that needs it. It is among the engines that are available on our cloud hosting platform, so the one that will be picked depends on the given app’s prerequisites. You won’t need to do anything manually in order to activate InnoDB, as it will be set as the default engine when you install an application – whether manually or using our single-click app installer. To avoid any risk, we’ll carry out daily backups of all your MySQL databases, so if anything goes wrong following an update or if you remove some data by accident, we will be able to restore the database the way it was on any of the previous seven days.