InnoDB is a database engine for MySQL relational databases, which is used by well known script-based web apps like Joomla 3.x and Magento. It is excellent for scalable apps, as it works astonishingly well when processing enormous amounts of data. Rather than locking the entire database table to append new information to a database like many other engines do, InnoDB locks only one row, so it can handle a lot more tasks for the same length of time. What’s more, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and updates should be handled. In case a particular task has not been entirely completed for some reason, the action will be rolled back. In this way, the content in the database will remain intact and won’t be partially mixed with newly appended content.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other hosting service providers, it is part of the standard set of features that we offer with our shared hosting plans. If you would like to use a PHP script-based software app that requires InnoDB in particular, in order to be installed and to perform correctly, you will not need to deal with any problems as the InnoDB storage engine is available on our custom cloud website hosting platform. No matter if you create a new MySQL database and activate an application manually or make use of our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the given app requires InnoDB instead of MyISAM. Besides the exceptional database failure recovery offered by InnoDB, we also maintain regular database backups, so we can easily recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you will be able to make the most of all the options offered by this database storage engine with any PHP-based application that requires it. It’s among the engines that we have on our cloud website hosting platform, so the one that will be used depends on the requirements of the given application. You will not need to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an app – whether manually or using our one-click application installer tool. To avoid any risk, we will perform daily database backups, so if anything goes wrong after an update or if you delete some content by mistake, we will be able to get the database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you’ll be able to use any open-source script-based software application that needs the database storage engine without setting up anything manually. You can select Hepsia on the VPS order page and your brand new server will be set up within one hour, so you can sign in and begin creating your websites right away. When you create a new MySQL database and begin the app installation process, our system will choose the engine for this database automatically. In this way, you can use various applications simultaneously without updating anything on the Virtual Private Server. You can have a WordPress-based online journal that uses MyISAM – the default MySQL engine, and a Magento Internet shop that makes use of the InnoDB engine, for instance.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our in-house developed Hepsia hosting Control Panel include a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB database engine, so you will not need to add it manually if you want to use PHP scripts that need it. All it takes to run such a script is to create a new MySQL database and to begin the installation – as soon as the installer wizard accesses the database and begins entering content into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You will also be able to activate scripts that require the other very popular MySQL engine, MyISAM, so you will not have to configure any settings on the dedicated server. This will allow you to activate a variety of scripts on one single physical server and to use the latter to its fullest capabilities.