InnoDB is a storage engine for MySQL databases, which is used by popular open-source script-driven apps such as Joomla 3 and Magento. It is ideal for scalable applications, because it works astonishingly well when processing large data volumes. Instead of locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same period of time. Also, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – rules that prescribe how data imports and modifications should be treated. In case a particular operation hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will remain intact and won’t be partially merged with newly inserted content.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with many web hosting providers, it is part of the default set of features that we are offering with our shared hosting plans. In case you wish to use an open-source script-based app that needs InnoDB in particular, in order to be installed and to work correctly, you will not experience any difficulties since the database storage engine is available on our custom-built cloud hosting platform. Regardless of whether you create a new database and activate an app manually or take advantage of our one-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the given application requires InnoDB instead of MyISAM. In addition to the excellent database failure recovery that InnoDB is offering, we also perform daily database backups, so we can swiftly restore any database in your shared account.

InnoDB in Semi-dedicated Hosting

InnoDB is available with each of our Linux semi-dedicated packages by default, so once you buy a new semi-dedicated account, you can go on and install any script-driven software app that requires the database storage engine. Several engines are pre-installed on our cloud website hosting platform, so when you create a new database and start installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be picked based on the prerequisites of the given application. This will permit you to install and manage InnoDB-specific apps without having to cope with any difficulty and without the need to modify any settings in your account. To take no chances, we will always have a one-week-old backup of all your databases, so if you remove or alter any content by mistake, we can quickly retrieve it.

InnoDB in VPS Web Hosting

In case our custom Hepsia hosting Control Panel is selected during the signup process for your new Linux VPS web hosting packages , InnoDB will be installed on the server together with other essential software, so you won’t have to do anything if you choose to use script-driven software applications that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated too. You can set up a new database and start the app installation process manually or through our 1-click installer tool. The system will recognize the engine that the application in question requires and will set it for the specific database, so the installation process will proceed flawlessly and the application can enter its data into that database. Thus, you can run apps with various prerequisites with regard to the MySQL engine without making any modifications on your VPS server.

InnoDB in Dedicated Servers Hosting

InnoDB is included as standard with all Linux dedicated servers hosting packages that are ordered with the Hepsia Control Panel. It’s an essential part of the standard software package that we install on all Hepsia-managed dedicated servers, so once your physical machine is assembled, you will be able to log in and to activate any type of PHP script-driven software application that needs this particular database storage engine. When you create a new database through the hosting Control Panel, there won’t be any active engine till you start installing an app. As soon as the app setup wizard begins dumping information in the database, the engine will be selected automatically on the basis of the prerequisites of the respective application, so you can use both MyISAM and InnoDB without the need to select either one specifically at any time. Thus, you can use a broad variety of applications for your websites.