InnoDB is a database storage engine for MySQL relational databases, which is used by well known PHP script-based apps such as Joomla™ 3 and Magento. It’s ideal for scalable apps, because it performs unbelievably well when handling huge volumes of data. Rather than locking the whole table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can execute much more tasks for the same period of time. Additionally, InnoDB offers an improved database failure recovery and supports transactions and foreign keys – rules that indicate how data inserts and modifications should be treated. In case a certain operation has not been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will be preserved intact and will not be partially mixed with newly imported content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with other hosting companies, it’s an essential part of the default set of services offered with our cloud hosting plans. In case you’d like to use a PHP-based app that requires InnoDB particularly, in order to be activated and to operate correctly, you will not experience any obstacles as the database storage engine is available on our in-house built cloud Internet hosting platform. Irrespective of whether you set up a new MySQL database and install an application manually or make use of our single-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific app requires InnoDB instead of MyISAM. In addition to the exceptional database failure recovery that InnoDB offers, we also keep regular backups of all databases, so we can quickly recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you will be able to make the most of all the features offered by this MySQL storage engine with any PHP-based web app that needs it. It is one of the engines that are available on our cloud web hosting platform, so the one that will be selected depends on the given app’s prerequisites. You will not need to do anything manually to enable InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our one-click application installer. To avoid any risk, we will store daily backups of all your databases, so if something goes wrong following some update or if you remove some content unintentionally, we will be able to restore your database the way it was on any of the past seven days.

InnoDB in VPS Servers

When you obtain a VPS server from us, you will be able to take advantage of our custom-developed Hepsia Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will allow you to run any script-based app that requires InnoDB, as this database engine is included in the default software package that will be pre-installed on the VPS server during its setup. When you set up a brand new MySQL database using the hosting Control Panel, you’ll just need to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine given that the app in question needs it, so you won’t need to do anything else in your VPS account. Identically, if an app requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

If you buy a new dedicated server, you will be able to choose one of the 3 hosting Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t have to enable this database storage engine manually in order to be able to use PHP script-powered apps that require it. InnoDB is used by scalable applications and since a dedicated server will offer you all the server resources that you require in order to manage very large websites, it is rather likely that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so in case a specific app needs MyISAM rather than InnoDB, you won’t have to deal with any impediment while managing it. The engine that will be used will be recognized automatically as soon as the app installation procedure starts, so you will not have to tweak any setting manually whatsoever.