InnoDB is a database storage engine for MySQL databases, which is used by widespread PHP-based web apps like Joomla™ v3 and Magento. It’s ideal for scalable apps, as it performs astonishingly well when processing large data volumes. Rather than locking the entire table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same length of time. Besides, InnoDB offers a much faster crash recovery and supports database transactions and foreign key constraints – a set of rules that specify how data imports and modifications should be treated. If a certain operation has not been entirely completed for any reason, the action will be rolled back. In this way, the content in the database will be retained undamaged and will not be partially merged with newly entered content.

InnoDB in Website Hosting

You will be able to install any PHP-based app that needs InnoDB if you’ve got a Linux website hosting plan with us, as the MySQL database storage engine is available on our innovative cloud web hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is needed. You can activate apps which need the MyISAM engine without any difficulty as well and, once again, the engine will be pre-selected, so you won’t need to configure anything manually at any point. What’s more, we will also perform daily backups of all the MySQL databases that you have in the account, so if you erase or overwrite something, we can quickly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our Linux semi-dedicated plans by default, so the moment you purchase a new semi-dedicated account, you can go on and activate any open-source script-powered app that needs this MySQL storage engine. Several engines are pre-installed on our cloud website hosting platform, so when you create a brand new MySQL database and start installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be set based on the given app’s requirements. This will permit you to install and manage InnoDB-specific applications without experiencing any impediment and without having to modify any settings in your account. To avoid any risk, we will always have a seven-day-old backup of all your databases, so if you remove or edit any content by accident, we can easily rescue it.

InnoDB in VPS Servers

In case our custom-developed Hepsia hosting Control Panel is chosen during the registration process for your new VPS web hosting plans , InnoDB will be activated on the server along with other needed pieces of software, so you will not need to do anything if you decide to make use of PHP-driven applications that need this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can set up a brand new database and start the app installation manually or through our one-click installer tool. The system will recognize which engine the application in question requires and will set it for the specific MySQL database, so the installation will continue impeccably and the application can import its content into that database. Thus, you can install apps with various requirements concerning the MySQL engine without the need to make any modifications on your VPS.

InnoDB in Dedicated Servers

All Linux dedicated web hosting plans ordered with our in-house developed Hepsia hosting Control Panel come with a software package that’s pre-activated and among everything else, you will get the InnoDB database storage engine, so you won’t need to install it manually if you wish to activate open-source PHP scripts that require it. All it takes to use such a script is to set up a new database and to initiate the setup – once the script setup wizard accesses the database and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You’ll also be able to use scripts that require MyISAM – the other very popular MySQL engine, so you won’t need to configure any settings on the dedicated server. This will enable you to use a variety of scripts on a single physical machine and to use the latter to its maximum capabilities.