InnoDB is a database storage engine for MySQL relational databases, which is used by popular PHP-powered apps such as Joomla v3 and Magento. It is ideal for scalable apps, since it performs exceptionally well when handling immense volumes of data. Rather than locking the entire table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can handle much more operations for the same period of time. Also, InnoDB offers a much faster database failure recovery and supports transactions and foreign key constraints – rules that specify how data inserts and modifications should be handled. If a given task has not been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will be retained intact and will not be partially merged with newly entered content.

InnoDB in Cloud Website Hosting

While InnoDB is either not available or a paid upgrade with many hosting service providers, it is included in the standard set of services that we offer with our cloud website hosting packages. In case you would like to use an open-source script-powered web app that requires InnoDB in particular, in order to be installed and to work properly, you won’t come across any difficulties as the storage engine is available on our custom-developed cloud web hosting platform. Irrespective of whether you create a brand-new MySQL database and install an application manually or take advantage of our 1-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the app needs InnoDB rather than MyISAM. Besides the excellent database failure recovery that InnoDB offers, we also perform daily backups of all databases, so we can swiftly recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

You can run an open-source script-powered application that requires InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our cutting-edge cloud web hosting platform where the database storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you make use of our single-click application installer tool. In either case, the required engine will be chosen automatically the moment the application’s installation begins, so you won’t need to configure anything manually, regardless of whether the application requires InnoDB or the more frequently used MyISAM. Also, we will always be able to recover any of your MySQL databases if you remove one by accident, as we carry out a couple of database backups every day, each of which is stored for seven days.

InnoDB in VPS Servers

When you acquire a VPS server from us, you will be able to take advantage of our custom-built Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will permit you to use any PHP script-powered application that requires InnoDB, as the database engine is an integral part of the default software package that will be pre-installed on the Virtual Private Server during its creation. When you create a brand-new MySQL database through the Control Panel, you simply have to begin installing an application – manually or using our app installer. InnoDB will be set as the default engine as long as the app in question needs it, so you will not need to do anything else in your account. Identically, if a certain application requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

All Linux dedicated web hosting plans that are ordered with our in-house developed Hepsia Control Panel include a software bundle that is pre-activated and among everything else, you will get the InnoDB storage engine, so you will not need to activate it manually in case you would like to run scripts that need it. All it takes to run such a script is to create a new database and to initiate the installation – once the script installation wizard acquires access to the database and starts importing data 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 will also be able to use scripts that need the other widely used MySQL engine, MyISAM, so you will not have to edit any settings on the dedicated server. This will enable you to use a variety of scripts on one single machine and to use it to its maximum capacity.