InnoDB is a storage engine for MySQL relational databases, which is used by popular script-driven software applications like Magento and Joomla 3. It’s ideal for scalable apps, since it performs amazingly well when managing immense data volumes. Instead of locking the whole table to append new information to a database as many other engines do, InnoDB locks only one row, so it can execute a lot more tasks for the same period of time. Furthermore, InnoDB offers a much faster crash recovery and supports database transactions and foreign keys – rules that define how data inserts and updates should be treated. In case a given operation has not been fully completed for any reason, the action will be rolled back. In this way, the database content will be preserved intact and won’t be partially mixed with newly imported content.

InnoDB in Web Hosting

InnoDB is available with all our web hosting by default, not upon request or as a paid upgrade, so you can install and manage any PHP script-based software app that needs the storage engine without having any difficulty once you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation, irrespective of whether you use our single-click installer or create the MySQL database and set up the application manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We will store regular database backups, so you can be sure that you’ll never lose any data in case you delete a database by accident or you overwrite some essential information – you simply need to inform us and we will restore your content the way it was.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our Linux semi-dedicated hosting service by default, so as soon as you obtain a new account, you can move on and activate any PHP script-based application that requires the MySQL database storage engine. A few engines are installed on our cloud web hosting platform, so when you create a new MySQL database and begin installing an app manually, or opt to make use of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen depending on the requirements of the application in question. This will permit you to activate and manage InnoDB-specific applications without any problems and without updating any settings in your semi-dedicated account. To avoid any risk, we’ll always keep a seven-day-old backup of all your databases, so if you remove or alter any content unintentionally, we can easily rescue it.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be an essential part of the default software pack that will be pre-installed on your VPS server before we give it to you. You will not have to configure anything manually and you’ll be able to enable and run any script-driven web app that needs InnoDB as soon as your VPS server is up and running, which takes no more than 1 hour after the order submission process itself. A few engines are offered, so anytime you set up a MySQL database through the Hepsia hosting Control Panel, a specific engine will be picked once the app installation process commences and our system will recognize which engine is required by the app in question. If you need MyISAM, for instance, you will not have to do anything different from installing the desired app, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our in-house built Hepsia Control Panel come with a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB database engine, so you will not need to add it manually if you need to use PHP scripts that require it. All it takes to install such a script is to set up a new MySQL database and to initiate the setup – as soon as the installer wizard receives access to the database and starts inserting content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You’ll also be able to use scripts that require MyISAM – the other very popular MySQL engine, so you will not need to update any settings on the dedicated server. This will enable you to install various scripts on a single server and to use it to its fullest capabilities.