InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a much better overall performance and a faster database failure recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is endorsed by a lot of programmers that write scalable applications, as it works better with immense data volumes, while it keeps the server load at a minimum. Furthermore, it locks only a single row in the database if anything should be modified, while lots of other engines lock the entire database table and therefore need much more time to accomplish several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification procedure cannot be completed for any reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the latest Joomla versions are two instances of popular PHP-based web apps that have moved to InnoDB.

InnoDB in Website Hosting

While InnoDB is either not offered or it is a paid upgrade with many other web hosting companies, it’s part of the default set of features that we are offering with our website hosting plans. If you want to make use of a PHP-based application that needs InnoDB in particular, in order to be installed and to operate properly, you won’t come across any difficulties since the database engine is available on our in-house built cloud website hosting platform. No matter if you set up a new MySQL database and install an application manually or make use of our single-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the given application needs it rather than MyISAM. In addition to the remarkable database crash recovery that InnoDB offers, we also maintain regular database backups, so we can swiftly restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our semi-dedicated servers by default, so the moment you obtain a new semi-dedicated account, you can go ahead and activate any PHP script-based software app that needs this particular MySQL database storage engine. Several engines are installed on our cloud hosting platform, so when you set up a brand-new MySQL database and begin installing an app manually, or decide to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be picked on the basis of the concrete app’s prerequisites. This will allow you to activate and run InnoDB-specific applications without any obstacle and without having to edit any settings in your semi-dedicated account. To be on the safe side, we’ll always keep a 1-week-old backup of all your databases, so if you delete or alter any content by mistake, we can easily rescue it.

InnoDB in VPS Servers

If you buy a VPS server from us, you’ll be able to make use of our in-house built Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will allow you to activate any PHP-driven software app which needs InnoDB, as the database engine is an essential part of the default software bundle that will be installed on the Virtual Private Server during its creation. When you set up a brand-new database using the Control Panel, you simply have to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine given that the application in question needs it, so you will not have to do anything else in your account. Correspondingly, if a given application needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house developed Hepsia Control Panel come with a software bundle that is pre-activated and among everything else, you’ll get the InnoDB storage engine, so you will not have to add it manually if you wish to run open-source scripts that need it. All it takes to use such a script is to create a new database and to begin the installation – once the script installation wizard gets access to the database and starts importing content into 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 use scripts that require MyISAM, the other very popular MySQL engine, so you won’t have to change any settings on the server. This will permit you to run a variety of scripts on one single machine and to use it to its maximum capacity.