InnoDB is a storage engine for MySQL relational databases, which is used by widespread PHP-powered software applications such as Magento and Joomla 3.x. It is ideal for scalable apps, because it works incredibly well when processing huge amounts of data. Instead of locking the whole database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can execute much more tasks for the same length of time. Moreover, InnoDB offers a better database failure recovery and supports transactions and foreign keys – a set of rules that determine how data imports and modifications should be treated. If a certain task hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the content in the database will be retained intact and will not be partially merged with newly imported content.

InnoDB in Shared Website Hosting

Any script-powered app that needs InnoDB will function flawlessly on our avant-garde cloud web hosting platform and the MySQL database storage engine is offered with all our shared website hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected in accordance with the app’s specifications without the need to change any setting in your shared account. InnoDB will be picked automatically for any app that requires this specific engine and you’ll be able to take advantage of its full potential. We will perform regular backups of your content, so if you unintentionally remove a MySQL database that’s important to you or you overwrite a specific part of it, we’ll be able to restore everything the way it was only several hours ago.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database through the hosting Control Panel provided with each of our semi-dedicated server accounts and you begin installing a PHP-powered web application either manually or using our 1-click application installer, the storage engine for the MySQL database will be set automatically based on the particular app’s prerequisites. As InnoDB is available on the cloud hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any application that needs it without any manual intervention required on your end at any time. To avoid any chance of losing info if you update an application or if you delete a database by mistake, we’ll perform a backup of all your databases each day, so if anything happens, we can retrieve your data.

InnoDB in VPS Servers

When you buy a VPS server from our company, you will be able to use our in-house built Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will allow you to manage any PHP-based application which needs InnoDB, as this particular MySQL database engine is an essential part of the default software bundle that will be installed on your server during its setup. When you create a brand new database using the Control Panel, you will just need to start installing an app – manually or using our application installer tool. InnoDB will be set as the default engine on the condition that the app in question requires it, so you won’t have to do anything else in your account. Equivalently, if a certain app needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

When you acquire a new dedicated server, you will be able to choose any of the three hosting Control Panels offered by us – cPanel, Hepsia and DirectAdmin. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not have to install this database storage engine manually in order to be able to run PHP-based applications that require it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the server resources that you require in order to run large-size websites, it’s quite likely that you will resort to InnoDB. You will be able to use other engines as well, so in case a particular app requires MyISAM instead of InnoDB, you won’t run into any complication while using it. The engine that will be used will be detected automatically the moment the app installation starts, so you will not need to configure any setting manually at any time.