InnoDB is a database storage engine for MySQL relational databases, which is used by widely used script-driven applications like Joomla 3 and Magento. It’s perfect for scalable applications, since it works stunningly well when handling immense data volumes. Rather than locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same period of time. Also, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – a set of rules that indicate how data inserts and updates should be treated. If a certain task has not been fully completed for any reason, the action will be rolled back. In this way, the database content will be kept intact and will not be partially merged with newly inserted content.

InnoDB in Cloud Website Hosting

While InnoDB is either not available or a paid upgrade with many hosting providers, it’s included in the standard set of features that we are offering with our cloud website hosting packages. In case you want to use a PHP script-driven web application that requires InnoDB specifically, in order to be activated and to operate properly, you won’t need to deal with any obstacles as the database storage engine is available on our custom-built cloud hosting platform. No matter if you set up a brand new database and install an app manually or take advantage of our 1-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the given app requires InnoDB instead of MyISAM. Besides the excellent database failure recovery offered by InnoDB, we also store regular database backups, so that we can swiftly restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

You can use an open-source script-driven software app that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are created on our leading-edge cloud platform where the storage engine is installed. A new MySQL database can be set up in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our 1-click app installer. Either way, the needed engine will be selected automatically the moment the application’s installation starts, so you won’t have to modify anything manually, regardless of whether the application requires InnoDB or the more commonly used MyISAM. In addition, we’ll always be able to recover any of your databases if you remove one by accident, as we generate a couple of backups every day, each of which is saved for one whole week.

InnoDB in Dedicated Hosting

All Linux dedicated hosting that are ordered with our custom Hepsia Control Panel come with a software package that is pre-installed and besides everything else, you will get the InnoDB database engine, so you will not need to install it manually in case you would like to run PHP scripts that require it. All it takes to use such a script is to set up a new MySQL database and to begin the installation process – as soon as the setup wizard acquires access to the database and begins dumping data in it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You will also be able to run scripts that need MyISAM – the other widely used MySQL engine, so you won’t have to configure any settings on the dedicated server. This will enable you to install a variety of scripts on one single physical machine and to use the latter to its maximum capabilities.