InnoDB is a database storage engine for MySQL relational databases, which is used by widespread script-driven software apps such as Joomla 3 and Magento. It is excellent for scalable applications, as it performs really well when handling enormous volumes of data. Instead of locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can process much more operations for the same period of time. Also, InnoDB offers a much better database failure recovery and supports database transactions and foreign keys – rules that specify how data inserts and modifications should be handled. If a given operation has not been entirely completed for whatever reason, the action will be rolled back. In this way, the content in the database will stay undamaged and will not be partially merged with newly added content.

InnoDB in Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting companies, it’s an essential part of the standard set of services that we offer with our web hosting plans. If you would like to use a PHP script-driven app that needs InnoDB particularly, in order to be activated and to operate properly, you will not have to deal with any impediments since the MySQL storage engine is available on our in-house built cloud web hosting platform. Irrespective of whether you set up a new MySQL database and install an app manually or use our 1-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the application requires it rather than MyISAM. Besides the remarkable database failure recovery that InnoDB offers, we also store regular backups of all databases, so we can quickly recover any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our Linux semi-dedicated servers by default, so once you order a new account, you can move on and activate any script-powered web app that needs the storage engine. A number of engines are installed on our cloud platform, so when you create a 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 chosen based on the requirements of the given application. This will allow you to install and manage InnoDB-specific applications without having any obstacle and without having to update any settings in your account. To be on the safe side, we’ll always have a 7-day-old backup of all your MySQL databases, so if you delete or alter any content accidentally, we can swiftly restore it.

InnoDB in VPS Servers

When you obtain a VPS server from us, you’ll be able to use our custom-built Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to use any script-powered application that requires InnoDB, as the MySQL database storage engine is an integral part of the software package that will be pre-installed on the Virtual Private Server during its setup. When you set up a brand new database through the hosting Control Panel, you will simply have to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine if the app in question requires it, so you will not have to do anything else in your account. Correspondingly, if an app requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the features which you can choose on the server order page when you purchase a dedicated server from us. As this is the most powerful type of hosting, it’s pretty likely that you’ll manage popular Internet sites that will attract plenty of people, and since InnoDB is one of the very best choices for such Internet sites, we’ll activate it along with all the other software applications that come with a Hepsia-managed server. If you set up a brand-new database in your dedicated account, there won’t be any active MySQL database engine till you begin installing an open-source script, whether manually via your Internet browser or using the automatic script installer that is available in the Control Panel. The required engine will be detected and will be set for that database, so you can use scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without having to deal with any impediment.