InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and an improved crash recovery compared to the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by numerous programmers that run highly scalable web apps, because it works much more effectively with huge data volumes, while it keeps the server processing load at a minimum. Moreover, it locks only a single row in the database if anything should be edited, whereas many other engines lock the entire table and thus need more time to handle multiple sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the entire data modification cannot be completed for any reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla releases are two examples of widespread PHP script-based software platforms that have shifted over to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting providers, it’s an integral part of the standard set of features that we offer with our cloud hosting plans. If you wish to use a script-powered software application that requires InnoDB specifically, in order to be activated and to perform correctly, you will not need to deal with any impediments as the database storage engine is available on our custom-developed cloud Internet hosting platform. Irrespective of whether you set up a brand-new database and install an application manually or take advantage of our 1-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the respective application requires InnoDB instead of MyISAM. In addition to the outstanding crash recovery that InnoDB offers, we also keep daily backups of all databases, so that we can quickly restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you’ll be able to take full advantage of all the features of this storage engine with any PHP script-driven web application that requires it. It’s one of the engines that we have on our cloud website hosting platform, so the one that will be selected depends on the requirements of the given application. You will not need to do anything manually to enable InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our single-click app installer tool. To avoid any risk, we will maintain regular backups of all your databases, so if anything goes wrong after an upgrade or if you delete some data unintentionally, we will be able to restore your database the way it was on any of the previous seven days.

InnoDB in VPS Servers

In case our custom-built Hepsia Control Panel is selected during the signup process for a new VPS hosting plans , InnoDB will be activated on the Virtual Private Server together with other essential pieces of software, so you won’t have to do anything if you choose to use PHP-based web applications that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated too. You can set up a new MySQL database and start the app installation manually or using our single-click installer. The system will detect the engine that the particular app needs and will assign it to the specific database, so the installation will continue flawlessly and the application can enter its content into that database. Therefore, you can run applications with different requirements regarding the MySQL engine without making any changes on your VPS server.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom Hepsia Control Panel come with a software package that’s pre-installed and besides everything else, you will get the InnoDB database storage engine, so you won’t need to install it manually if you want to use PHP scripts that require it. All it takes to use such a script is to create a new MySQL database and to initiate the installation process – as soon as the installation wizard gains access to the database in question and begins importing content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You will also be able to activate scripts that need the other very popular MySQL engine, MyISAM, so you will not need to modify any settings on the server. This will allow you to activate various scripts on a single physical server and to use it to its fullest capabilities.