InnoDB is a very popular database engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got a lot of strong sides which have made it the engine of choice for plenty of open-source script-driven web applications, such as Joomla™ and Magento, which have shifted over to InnoDB for good. For example, importing large data volumes will be much faster with InnoDB, due to the fact that it locks only a single database row to perform a particular task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the info is treated. In simpler words, appending new or updating existing data will either be entirely completed, or will be canceled and the operation will be rolled back in case any problem occurs in the meantime, thus the content that remains in the database will not be lost.

InnoDB in Shared Web Hosting

You’ll be able to make use of any open-source script-based app that requires InnoDB if you’ve got a Linux shared web hosting package with us, as the MySQL database storage engine is available on our leading-edge cloud website hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is needed. You can run apps that require the MyISAM engine without any problem as well and, again, the engine will be selected automatically, so you won’t need to modify anything manually at any time. In addition, we’ll also create regular backups of all the databases that you’ve got in your shared hosting account, so if you erase or overwrite anything, we can swiftly restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting packages include InnoDB and you will be able to take full advantage of all the features offered by this database storage engine with any script-based app that needs it. It’s among the engines that are available on our cloud website hosting platform, so the one that will be used depends on the prerequisites of the given app. You will not need to do anything manually in order to activate InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our 1-click application installer. To avoid any risk, we will generate regular backups of all your MySQL databases, so if anything goes wrong following an upgrade or if you delete 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 VPS

If you acquire a virtual private server from our company, you will be able to take full advantage of our in-house built Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to run any open-source script-powered web app that needs InnoDB, as this particular storage engine is an integral part of the standard software package that will be installed on the VPS server during its setup. When you create a new MySQL database using the hosting Control Panel, you will just need to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine on the condition that the application in question needs it, so you will not need to do anything else in your VPS account. In the same manner, if a given app needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Hosting

When you get a new dedicated server, you’ll be able to choose one of the three hosting Control Panels that we’re offering – DirectAdmin, cPanel and Hepsia. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t need to add this MySQL database storage engine manually in order to be able to run PHP-driven apps that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the system resources that you need in order to run large-scale Internet sites, it’s quite possible that you will use InnoDB. You will be able to make use of other engines too, so in case a particular app needs MyISAM instead of InnoDB, you won’t have to deal with any difficulty while running it. The engine that will be used will be automatically recognized when the app installation process begins, so you won’t have to configure any settings manually at any time.