InnoDB is a database storage engine for MySQL relational databases, which is used by well known open-source script-powered web apps such as Joomla 3 and Magento. It is ideal for scalable applications, as it performs remarkably well when processing enormous amounts of data. Rather than locking the whole table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can execute much more tasks for the same period of time. In addition, InnoDB offers a better database failure recovery and supports database transactions and foreign key constraints – rules that determine how data inserts and modifications should be handled. If a certain task has not been entirely completed for some reason, the action will be rolled back. In this way, the information in the database will stay safe and sound and won’t be partially merged with newly inserted content.

InnoDB in Website Hosting

While InnoDB is either not available or a paid upgrade with many other hosting providers, it is part of the standard set of services that we’re offering with our website hosting plans. In case you’d like to make use of an open-source script-driven software application that requires InnoDB in particular, in order to be activated and to function correctly, you won’t come across any problems as the InnoDB database engine is available on our custom-built cloud platform. No matter if you set up a new database and activate an application manually or use our one-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the particular application requires it rather than MyISAM. In addition to the incredible database crash recovery offered by InnoDB, we also make daily backups of all databases, so we can easily recover any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

If you set up a brand new MySQL database from the hosting Control Panel provided with all our semi-dedicated server plans and you begin installing a PHP-based software application either manually or using our single-click application installer, the database storage engine will be selected automatically based on the requirements of the app in question. As InnoDB is present on the cloud hosting platform where your new account will be set up, it will be set as the default engine for any app that requires it without any manual intervention needed on your end at any time. To avoid any chance of losing data if you update an application or if you erase a database by mistake, we’ll perform a backup of all your databases each day, so if anything happens, we can restore your content.

InnoDB in VPS Servers

When you purchase a VPS server from our company, you’ll be able to make use of our custom-built Hepsia Control Panel to manage your content. A Hepsia-managed VPS will allow you to run any PHP script-based app which needs InnoDB, as this particular database engine is part of the default software bundle that will be installed on your VPS server during its creation. When you set up a brand-new MySQL database using the Control Panel, you simply have to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine on the condition that the application in question requires it, so you won’t have to do anything else in your account. Analogously, if a given application requires MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-developed Hepsia hosting Control Panel come with a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB database engine, so you won’t need to activate it manually if you’d like to activate scripts that require it. All it takes to run such a script is to create a new database and to initiate the setup – once the installation wizard gains access to the database and starts inserting data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You’ll also be able to install scripts that need the other widely used MySQL engine, MyISAM, so you won’t have to update any settings on the server. This will allow you to install various scripts on a single machine and to use the latter to its fullest capacity.