InnoDB is a popular storage engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has lots of advantages which have made it the preferred engine for many PHP script-driven software applications, such as Magento and Joomla, which have switched over to InnoDB for good. For example, adding huge volumes of data will be much faster with InnoDB, as it locks only one row to complete a given operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the information is treated. In simpler words, adding new or editing existent data will either be thoroughly completed, or will be canceled and the operation will be rolled back if a certain issue occurs during the process, hence the content that remains in the database will not be lost.

InnoDB in Cloud Website Hosting

You’ll be able to activate any script-based software app that requires InnoDB in case you’ve got a cloud website hosting with us, as the database engine is available on our advanced cloud web hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is needed. You can install apps that need the MyISAM engine without having any problem as well and, once again, the engine will be pre-selected, so you will not need to configure anything manually at any point. What’s more, we’ll also make daily backups of all the databases that you’ve got in the shared web hosting account, so if you erase or overwrite something, we can swiftly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers support InnoDB and you’ll be able to make use of all the features of this MySQL database engine with any PHP script-driven software app that requires it. It’s one of the engines that we have on our cloud hosting platform, so the one that will be picked depends on the prerequisites of the particular 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 one-click app installer tool. To be on the safe side, we’ll store daily database backups, so if something goes wrong following an upgrade or if you erase some content accidentally, we’ll be able to restore your database the way it was on any of the past seven days.

InnoDB in VPS Servers

All Linux VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you’ll be able to make use of any open-source script-driven web application that requires this database storage engine without the need to install anything manually. You can select Hepsia on the VPS order form and your brand new VPS server will be ready within the hour, so you can log in and begin setting up your websites straight away. Once you create a brand new database and start the app installation process, our system will set the engine for that database automatically. In this way, you can manage various apps simultaneously without changing anything on the VPS server. You can set up a WordPress-based weblog that makes use of MyISAM – the default MySQL engine, and a Magento-driven Internet shop that makes use of InnoDB, for example.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our in-house built Hepsia Control Panel come with a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you will not need to add it manually if you’d like to activate scripts that need it. All it takes to use such a script is to set up a new database and to begin the setup – as soon as the script setup wizard gets access to the database in question and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You will also be able to activate scripts that require the other popular MySQL engine – MyISAM, so you will not have to change any settings on the server. This will enable you to install a variety of scripts on a single physical server and to use it to its full capabilities.