InnoDB is a database engine for MySQL relational databases, which is used by famous PHP-powered software apps like Joomla™ 3 and Magento. It’s perfect for scalable applications, because it performs very well when managing huge volumes of data. Instead of locking the entire table to append new information to a database like many other engines do, InnoDB locks only one row, so it can perform much more operations for the same length of time. What’s more, InnoDB offers a better database failure recovery and supports database transactions and foreign key constraints – rules that specify how data imports and modifications should be handled. In case a particular task has not been thoroughly completed for any reason, the action will be rolled back. In this way, the content in the database will be preserved safe and sound and will not be partially mixed with newly appended content.

InnoDB in Cloud Hosting

While InnoDB is either not offered or it is a paid upgrade with many other website hosting service providers, it’s an integral part of the standard set of features that we’re offering with our cloud hosting plans. In case you want to make use of an open-source script-driven software app that requires InnoDB particularly, in order to be installed and to operate correctly, you will not have any difficulties because the database storage engine is available on our in-house built cloud website hosting platform. Irrespective of whether you create a new MySQL database and install an app manually or take advantage of our one-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the app needs it rather than MyISAM. In addition to the excellent crash recovery offered by InnoDB, we also store regular backups of all databases, so that we can easily recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB comes with all our semi-dedicated servers by default, so as soon as you get a new semi-dedicated account, you can go on and activate any PHP script-based web app that needs this particular MySQL storage engine. A couple of engines are installed on our cloud hosting platform, so when you create a brand-new MySQL database and start installing an app manually, or opt to make use of the Hepsia Control Panel-integrated application installer, the engine for the database will be chosen on the basis of the requirements of the respective application. This will permit you to install and manage InnoDB-specific apps without encountering any difficulty and without having to edit any settings in your semi-dedicated account. To be on the safe side, we’ll always keep a 1-week-old backup of all your MySQL databases, so if you remove or alter any content by accident, we can quickly retrieve it.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom Hepsia Control Panel include a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to add it manually in case you need to use open-source PHP scripts that require it. All it takes to use such a script is to set up a new database and to begin the setup – once the installation wizard acquires access to the database and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You’ll also be able to activate scripts that need the other popular MySQL engine – MyISAM, so you won’t have to change any settings on the dedicated server. This will allow you to use various scripts on one single physical machine and to use it to its maximum capabilities.