InnoDB is a storage engine for MySQL databases, which is used by famous open-source script-powered apps such as Joomla v3 and Magento. It is ideal for scalable applications, as it works remarkably well when handling enormous 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 database row, so it can carry out a lot more operations for the same period of time. Furthermore, InnoDB offers a much better database failure recovery and supports transactions and foreign keys – rules that determine how data inserts and updates should be treated. If a given task hasn’t been fully completed for any reason, the action will be rolled back. Thus, the information in the database will be preserved undamaged and will not be partially merged with newly appended content.

InnoDB in Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosting companies, it is included in the default set of services that we are offering with our website hosting plans. In case you would like to use a PHP-based application that needs InnoDB in particular, in order to be activated and to perform correctly, you won’t experience any problems because the InnoDB database engine is available on our custom-built cloud Internet hosting platform. Regardless of whether you create a brand new MySQL database and install an app manually or take advantage of our single-click app 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 crash recovery offered by InnoDB, we also keep daily database backups, so that we can swiftly recover any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated plans include InnoDB and you’ll be able to take full advantage of all the options offered by this MySQL database storage engine with any PHP-driven web 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 prerequisites of the particular application. You will not have 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 single-click application installer. To be on the safe side, we will store daily MySQL database backups, so if anything goes wrong following some update or if you erase some data accidentally, we will be able to get your database back to the way it was on any of the past 7 days.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house built Hepsia hosting Control Panel come with a software bundle that is pre-installed and besides everything else, you will get the InnoDB storage engine, so you will not need to add it manually if you need to run open-source PHP scripts that need it. All it takes to install such a script is to set up a new MySQL database and to start the setup process – once the script configuration wizard acquires access to the database in question and begins inserting content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You’ll also be able to install scripts that need MyISAM – the other popular MySQL engine, so you will not have to modify any settings on the server. This will allow you to activate a variety of scripts on a single physical server and to use it to its fullest capacity.