InnoDB is a storage engine for MySQL relational databases, which is used by widely used PHP script-based software applications such as Magento and Joomla 3.x. It’s excellent for scalable apps, as it works incredibly well when handling immense volumes of data. Rather than locking the whole table to append new information to a database like many other engines do, InnoDB locks only one row, so it can complete a lot more operations for the same period of time. Furthermore, InnoDB offers a much faster crash recovery and supports database transactions and foreign keys – rules that determine how data imports and modifications should be handled. If a particular task has not been entirely completed for any reason, the action will be rolled back. In this way, the information in the database will be kept intact and won’t be partially merged with new content.

InnoDB in Shared Hosting

You can make use of any PHP-powered web app that requires InnoDB if you’ve got a Linux shared hosting with us, as the MySQL database engine is available on our advanced cloud website hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is required. You can run apps that use the MyISAM engine without the need to deal with any complication as well and, again, the engine will be pre-selected, so you won’t have to configure any setting manually at any time. What’s more, we will also generate regular backups of all the databases that you’ve got in your shared account, so if you erase or overwrite something, we can easily get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

InnoDB is offered with all our Linux semi-dedicated hosting by default, so as soon as you get a new account, you can move on and install any PHP-driven software application that requires the storage engine. A couple of engines are pre-installed on our cloud platform, so when you create a brand-new MySQL database and start installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be picked depending on the requirements of the application in question. This will allow you to install and manage InnoDB-specific applications without any problems and without configuring any settings in your semi-dedicated account. To be on the safe side, we will always have a seven-day-old backup of all your databases, so if you remove or change any content by accident, we can swiftly rescue it.

InnoDB in Dedicated Hosting

All Linux dedicated hosting ordered with our custom-built Hepsia Control Panel include a software package that is pre-installed and among everything else, you’ll get the InnoDB database engine, so you will not have to install it manually if you’d like to run open-source PHP scripts that require it. All it takes to run such a script is to create a new database and to begin the setup – once the script setup wizard gains access to the database in question and starts dumping data in it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the script. You’ll also be able to use scripts that require the other widely used MySQL engine – MyISAM, so you will not need to modify any settings on the dedicated server. This will allow you to activate a variety of scripts on a single physical server and to use the latter to its maximum capacity.