InnoDB is a database engine for MySQL databases, which is used by widely used PHP-based web apps like Joomla 3 and Magento. It’s excellent for scalable applications, because it works exceptionally well when handling large volumes of data. Rather than locking the entire database table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can complete a lot more tasks for the same period of time. Moreover, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – rules that prescribe how data inserts and updates should be treated. If a certain operation has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the content in the database will be retained safe and sound and won’t be partially merged with newly appended content.
InnoDB in Web Hosting
While InnoDB is either not available or a paid upgrade with other web hosting companies, it is part of the default set of features that we are offering with our web hosting packages. If you would like to use a PHP-driven application that requires InnoDB particularly, in order to be installed and to perform properly, you won’t have any problems because the MySQL database storage engine is available on our custom-built cloud platform. No matter if you set up a brand-new database and install an app manually or use our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular application needs InnoDB rather than MyISAM. In addition to the amazing crash recovery that InnoDB is offering, we also make regular database backups, so that we can easily restore any database in your shared web hosting account.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting come with InnoDB and you can get the most out of all the features offered by this MySQL database storage engine with any open-source script-based application that needs it. It’s among the engines that are available on our cloud platform, so the one that will be picked depends on the given app’s prerequisites. You will not need to do anything manually in order to activate InnoDB, as it will be set as the default engine when you install an app – whether manually or using our one-click application installer. To be on the safe side, we will store regular backups of all your databases, so if something goes wrong following some update or if you delete some data accidentally, we will be able to restore your database the way it was on any of the previous 7 days.