InnoDB is a database storage engine for MySQL databases, which is used by widespread PHP script-driven applications such as Magento and Joomla™ 3. It is ideal for scalable apps, as it performs stunningly well when processing enormous amounts of data. Instead of locking the entire table to append new information to a database as many other engines do, InnoDB locks only one row, so it can carry out much more operations for the same length of time. Besides, InnoDB offers a much faster database failure recovery and supports transactions and foreign key constraints – rules that indicate how data imports and updates should be handled. In case a certain operation hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the content in the database will stay intact and won’t be partially mixed with new content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many website hosting service providers, it’s an integral part of the default set of services offered with our cloud hosting plans. If you’d like to make use of a script-based web app that needs InnoDB specifically, in order to be installed and to operate properly, you won’t encounter any obstacles since the MySQL database engine is available on our in-house developed cloud platform. Regardless of whether you create a brand new MySQL database and install an application manually or make use of our single-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the respective app requires InnoDB instead of MyISAM. In addition to the remarkable database failure recovery that InnoDB offers, we also store daily backups of all databases, so we can quickly restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting include InnoDB and you will be able to make the most of all the options offered by this storage engine with any PHP script-powered software application that requires it. It’s among the engines that we have on our cloud platform, so the one that will be used depends on the requirements of the particular app. You won’t have to do anything manually in order to activate InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer tool. To avoid any risk, we’ll keep regular backups of all your databases, so if something goes wrong after an upgrade or if you remove some content by accident, we will be able to restore your database the way it was on any of the past seven days.

InnoDB in VPS Hosting

In case our in-house developed Hepsia Control Panel is chosen during the registration process for a new Linux virtual private servers , InnoDB will be activated on the VPS server together with other essential pieces of software, so you won’t need to do anything if you decide to manage open-source script-powered web applications that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed too. You can create a brand new database and begin installing the app manually or using our one-click installer tool. The system will automatically recognize which engine the application in question needs and will assign it to the specific MySQL database, so the installation process will proceed flawlessly and the app can dump its data in that database. Thus, you can make use of apps with different prerequisites concerning the MySQL engine without having to make any changes on your VPS server.

InnoDB in Dedicated Web Hosting

If you purchase a new dedicated server, you will be able to choose any of the three hosting Control Panels that we offer – DirectAdmin, Hepsia and cPanel. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to add this database storage engine manually so as to be able to run script-driven software apps that need it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the system resources that you require to manage large-size websites, it’s very likely that you will resort to InnoDB. You’ll be able to use other engines too, so if a specific application needs MyISAM rather than InnoDB, you won’t run into any complication while managing it. The engine that will be used will be automatically detected when the app installation begins, so you won’t have to configure any setting manually at any moment.