InnoDB is a popular storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has got many upsides that make it the preferred engine for a lot of open-source script-driven applications, such as Magento and Joomla™, which have switched to InnoDB for good. For example, adding enormous volumes of data will be faster with InnoDB, due to the fact that it locks only one database row to perform a task, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. Simply put, importing new or updating existent data will either be fully completed, or will be aborted and the operation will be rolled back if any issue occurs in the meantime, therefore the content that remains in the database won’t be damaged.

InnoDB in Cloud Hosting

Every open-source script-based application that needs InnoDB will run impeccably on our innovative cloud web hosting platform and the database engine comes with all our cloud hosting packages. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected based on the app’s prerequisites without the need to modify any setting in your shared account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to get the most out of its full capacity. We will store regular content backups, so if you accidentally remove a MySQL database that you need or you overwrite certain parts of it, we’ll be able to restore the database the way it was just a couple of hours ago.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers support InnoDB and you will be able to make the most of all the features of this storage engine with any PHP-powered software app that requires it. InnoDB is among the engines that are available on our cloud platform, so the one that will be selected depends on the requirements of the given application. You won’t have to do anything manually in order to activate InnoDB, since it will be set as the default engine whenever you install an application – whether manually or using our 1-click app installer. To be on the safe side, we will perform regular MySQL database backups, so if something goes wrong following an upgrade or if you erase some data by accident, we will be able to restore your database the way it was on any of the past 7 days.

InnoDB in VPS Servers

In case our custom Hepsia hosting Control Panel is chosen during the registration process for your new VPS web hosting plans , InnoDB will be activated on the VPS server together with other required software, so you won’t have to do anything if you choose to manage PHP-based applications that need this MySQL storage engine. The default MySQL engine, MyISAM, will be activated too. You can set up a new MySQL database and begin the app installation process manually or using our one-click installer. The system will recognize the engine that the particular app requires and will set it for the specific database, so the installation will continue impeccably and the app can insert its content into that database. Thus, you can make use of apps with different prerequisites in regard to the MySQL engine without making any changes on your VPS.

InnoDB in Dedicated Servers

All Linux dedicated servers that are ordered with our in-house built Hepsia Control Panel come with a software bundle that is pre-installed and besides everything else, you will get the InnoDB storage engine, so you won’t have to install it manually if you wish to run open-source scripts that require it. All it takes to activate such a script is to create a new MySQL database and to start the setup process – as soon as the installation wizard acquires access to the database and starts inserting content into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You will also be able to install scripts that require the other very popular MySQL engine – MyISAM, so you won’t have to configure any settings on the dedicated server. This will enable you to run various scripts on one single server and to use the latter to its maximum capabilities.