InnoDB is a storage engine for MySQL relational databases, which is used by well known PHP script-driven apps such as Magento and Joomla 3. It’s excellent for scalable apps, because it performs exceptionally well when handling immense amounts of data. Instead of locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same length of time. Furthermore, InnoDB offers a much faster crash recovery and supports database transactions and foreign key constraints – a set of rules that determine how data imports and updates should be handled. In case a particular task hasn’t been thoroughly completed for any reason, the action will be rolled back. In this way, the database content will be preserved undamaged and won’t be partially merged with newly inserted content.

InnoDB in Cloud Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosts, it’s part of the standard set of services that we are offering with our cloud web hosting packages. In case you would like to make use of a PHP-driven software application that requires InnoDB specifically, in order to be installed and to work correctly, you will not face any impediments as the InnoDB storage engine is available on our custom cloud Internet hosting platform. Regardless of whether you set up a brand new database and install an app manually or use our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the given application needs InnoDB rather than MyISAM. Besides the incredible database failure recovery offered by InnoDB, we also maintain regular database backups, so we can quickly recover any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you will be able to take advantage of all the features of this database storage engine with any open-source script-based software application that needs it. InnoDB is among the engines that we have on our cloud website hosting platform, so the one that will be used depends on the prerequisites of the respective app. You won’t need to do anything manually to activate InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our single-click app installer. To avoid any risk, we’ll create daily database backups, so if something goes wrong following an upgrade or if you delete some data by accident, we will be able to get the database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

In case our custom-developed Hepsia Control Panel is chosen during the signup process for your new VPS servers , InnoDB will be installed on the server along with other essential software, so you will not have to do anything if you choose to activate PHP-powered software applications that require this MySQL storage engine. The default MySQL engine – MyISAM, will be activated as well. You can create a brand-new database and start installing the application manually or through our 1-click installer. The system will recognize which engine the application in question needs and will set it for the specific database, so the installation process will continue flawlessly and the application can insert its content into that database. Thus, you can manage apps with different prerequisites with regard to the MySQL engine without the need to make any modifications on your server.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house built Hepsia hosting Control Panel include a software package that’s pre-installed and besides everything else, you will get the InnoDB database storage engine, so you will not have to install it manually in case you want to run PHP scripts that need it. All it takes to use such a script is to set up a new database and to start the installation process – once the setup wizard obtains access to the database and starts entering data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You’ll also be able to install scripts that need the other very popular MySQL engine – MyISAM, so you will not need to update any settings on the server. This will allow you to run various scripts on one single machine and to use it to its full capabilities.