InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it offers a much better overall performance and a faster crash recovery compared with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by lots of devs that build highly scalable web apps, since it works much more efficiently with huge amounts of data, while it keeps the server processing load low. What’s more, it uses row-level locking in case anything should be updated, whereas lots of other engines lock the entire database table and thus require much more time to handle several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the modification of the entire data cannot be completed successfully for any reason, the operation is rolled back to avoid scrambling or data loss. Magento and the latest Joomla versions are two examples of widespread PHP script-powered software apps which have shifted over to InnoDB.

InnoDB in Cloud Web Hosting

InnoDB is available with all our Linux cloud web hosting plans by default, not upon request or as a paid upgrade, so you’ll be able to install and run any PHP script-based software app that needs the InnoDB database engine without having any difficulty as soon as you open your account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, no matter if you use our one-click installation tool or create the MySQL database and activate the app manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll perform regular backups of all your MySQL databases, so you can be certain that you will never lose any content in case you delete a database accidentally or you overwrite some essential information – you simply have to contact us and we’ll restore your content the way it was.

InnoDB in Semi-dedicated Servers

InnoDB is offered with all our semi-dedicated hosting plans by default, so once you purchase a new account, you can go on and activate any script-based software app that needs this particular storage engine. A number of engines are pre-installed on our cloud website hosting platform, so when you create a brand-new MySQL database and start installing an app manually, or decide to make use of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be chosen on the basis of the concrete app’s requirements. This will allow you to install and manage InnoDB-specific apps without the need to cope with any problem and without the need to update any settings in your semi-dedicated account. To take no chances, we will always keep a seven-day-old backup of all your MySQL databases, so if you erase or change any content unintentionally, we can swiftly restore it.

InnoDB in VPS Servers

In case our custom-built Hepsia hosting Control Panel is selected during the signup process for your new VPS web hosting plans , InnoDB will be installed on the server along with other necessary software, so you won’t need to do anything if you decide to install PHP-based applications that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed too. You can set up a new MySQL database and begin the app installation procedure manually or using our single-click installation tool. The system will recognize the engine that the app in question needs and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the app can insert its data into that database. In this way, you can install apps with different requirements concerning the MySQL engine without having to make any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

When you purchase a new dedicated server, you’ll be able to pick any of the three Control Panels that we are offering – Hepsia, cPanel and DirectAdmin. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to add this storage engine manually to be able to manage open-source script-based web apps that require it. InnoDB is used for scalable applications and since a dedicated server will give you all the server resources that you require in order to manage large-size Internet sites, it’s very likely that you’ll resort to InnoDB. You will be able to make use of other engines too, so if a certain application requires MyISAM instead of InnoDB, you will not come across any problem while managing it. The engine that will be used will be automatically detected once the app installation starts, so you won’t need to tweak any settings manually whatsoever.