InnoDB is a storage engine for MySQL databases, which is used by widely used PHP script-driven web applications such as Magento and Joomla 3. It is ideal for scalable applications, since it works incredibly well when managing immense data volumes. Rather than locking the entire database table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same period of time. What’s more, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – rules that specify how data inserts and updates should be treated. If a given operation has not been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will remain safe and sound and won’t be partially merged with newly appended content.

InnoDB in Cloud Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it is part of the default set of services offered with our cloud web hosting plans. If you wish to use a script-based app that requires InnoDB in particular, in order to be installed and to work properly, you won’t have any difficulties as the database engine is available on our in-house developed cloud website hosting platform. Irrespective of whether you set up a new database and activate an app manually or make use of our single-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the application requires it rather than MyISAM. In addition to the remarkable database failure recovery that InnoDB is offering, we also make daily database backups, so that we can quickly restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting packages include InnoDB and you will be able to make the most of all the features of this storage engine with any PHP script-powered software application that needs it. It’s among the engines that we have on our cloud platform, so the one that will be selected depends on the requirements of the particular app. You will not need to do anything manually to enable InnoDB, since it will be set as the default engine when you install an app – whether manually or using our single-click application installer. To avoid any risk, we will make daily backups of all your databases, so if something goes wrong after an upgrade or if you remove some data unintentionally, we will be able to get the database back to the way it was on any of the previous seven days.

InnoDB in VPS Hosting

All Linux VPS hosting packages that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you’ll be able to run any open-source script-powered application that needs the database storage engine without setting up anything manually. You can select Hepsia on the VPS order page and your new server will be up and running within 1 hour, so you can sign in and start creating your sites straight away. Once you create a brand new MySQL database and begin the app installation process, our system will choose the engine for this MySQL database automatically. In this way, you can make use of various applications simultaneously without the need to change anything on the server. You can create a WordPress-based personal blog that makes use of the default MySQL engine – MyISAM, and a Magento online shop that makes use of the InnoDB engine, for instance.

InnoDB in Dedicated Web Hosting

All Linux dedicated servers hosting packages that are ordered with our custom-built Hepsia Control Panel come with a software package that is pre-activated and besides everything else, you will get the InnoDB database engine, so you won’t have to install it manually if you wish to run open-source scripts that require it. All it takes to use such a script is to create a new MySQL database and to begin the installation – once the setup wizard gains access to the database and starts entering data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You will also be able to activate scripts that need MyISAM – the other widely used MySQL engine, so you will not need to change any settings on the dedicated server. This will allow you to install various scripts on one single machine and to use the latter to its fullest potential.