InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it provides a better overall performance and an improved crash recovery in comparison to the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is used by a lot of web developers that create highly scalable software apps, as it works much more efficiently with enormous amounts of data, while it keeps the server load low. Also, it uses row-level locking if anything should be updated, whereas lots of other engines lock the entire table and thus need more time to complete several consecutive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the latest releases of Joomla are two examples of popular PHP-based software platforms which have shifted over to InnoDB.
InnoDB in Web Hosting
InnoDB is offered with all our Linux web hosting packages by default, not as a paid upgrade or upon request, so you will be able to activate and manage any PHP script-powered software app which needs the MySQL database storage engine without any obstacles once you activate your account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app installation, no matter if you make use of our one-click installer or create the database and install the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll make regular backups of all your MySQL databases, so you can be certain that you will never lose any data if you erase a database accidentally or you overwrite some key information – you just have to notify us and we’ll restore your data back to normal.