InnoDB is a database engine for MySQL relational databases, which is used by famous open-source script-powered software apps such as Joomla™ 3.x and Magento. It’s ideal for scalable applications, because it performs amazingly well when managing immense volumes of data. Rather than locking the whole database table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same length of time. In addition, InnoDB offers a faster database failure recovery and supports transactions and foreign key constraints – rules that prescribe how data inserts and updates should be handled. In case a given task has not been fully completed for any reason, the action will be rolled back. In this way, the database content will be retained intact and won’t be partially merged with newly entered content.

InnoDB in Cloud Web Hosting

While InnoDB is either not available or a paid upgrade with other web hosting companies, it’s part of the standard set of features that we’re offering with our cloud web hosting plans. In case you want to make use of a PHP script-driven software app that needs InnoDB particularly, in order to be installed and to function correctly, you won’t have to deal with any problems since the storage engine is available on our in-house developed cloud hosting platform. Irrespective of whether you set up a new database and install an application manually or take advantage of our one-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the particular application requires it rather than MyISAM. Besides the remarkable database crash recovery that InnoDB offers, we also perform daily database backups, so we can easily recover any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated plans support InnoDB and you can take advantage of all the features of this MySQL storage engine with any PHP-driven software app that needs it. It is among the engines that we have on our cloud hosting platform, so the one that will be selected depends on the requirements of the particular application. You won’t have to do anything manually to enable InnoDB, since it will be set as the default engine when you install an app – whether manually or using our one-click app installer. To avoid any risk, we will generate daily MySQL database backups, so if anything goes wrong following an upgrade or if you erase some content unintentionally, we will be able to get your database back to the way it was on any of the previous seven days.

InnoDB in Dedicated Servers

When you purchase a new dedicated server, you will be able to choose one of the three hosting Control Panels that we are offering – DirectAdmin, Hepsia and cPanel. Any server ordered with Hepsia comes with InnoDB pre-installed, so you will not need to install this MySQL storage engine manually in order to be able to run script-powered web apps that need it. InnoDB is used by scalable apps and since a dedicated server will offer you all the server resources that you require to run large-size sites, it is rather possible that you’ll resort to InnoDB. You will be able to use other engines too, so in case a given app needs MyISAM rather than InnoDB, you won’t encounter any impediment while managing it. The engine that will be used will be automatically recognized once the app installation begins, so you won’t need to modify any settings manually at any time.