InnoDB is a database engine for MySQL relational databases, which is used by popular script-driven software apps such as Joomla v3 and Magento. It is ideal for scalable applications, as it performs exceptionally well when processing immense volumes of data. Rather than locking the entire table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can process much more tasks for the same length of time. Plus, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – rules that specify how data imports and modifications should be handled. In case a given operation has not been entirely completed for some reason, the action will be rolled back. In this way, the content in the database will stay safe and sound and won’t be partially merged with newly added content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other web hosting companies, it is included in the standard set of services that we are offering with our cloud hosting plans. If you’d like to make use of a PHP script-driven app that requires InnoDB specifically, in order to be activated and to work correctly, you will not experience any problems because the InnoDB storage engine is available on our custom-built cloud platform. Irrespective of whether you set up a brand new database and install an app manually or use our one-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular application requires InnoDB rather than MyISAM. Besides the amazing database failure recovery that InnoDB offers, we also carry out daily backups of all databases, so that we can easily restore any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated service support InnoDB and you will be able to use all the features of this storage engine with any PHP-based application that needs it. It’s among the engines that we have on our cloud hosting platform, so the one that will be selected depends on the prerequisites of the app in question. You won’t have to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our one-click application installer tool. To avoid any risk, we’ll maintain daily backups of all your databases, so if something goes wrong after an upgrade or if you erase some content by accident, we’ll be able to restore your database the way it was on any of the previous seven days.

InnoDB in VPS Servers

All VPS hosting service that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you’ll be able to run any PHP-powered software application that needs the database engine without needing to install anything manually. You can select Hepsia on the VPS order page and your brand new Virtual Private Server will be ready within the hour, so you can sign in and begin creating your sites right away. Once you set up a new MySQL database and start the app activation process, our system will select the engine for that MySQL database automatically. In this way, you can run different apps at the same time without having to modify anything on the Virtual Private Server. You can create a WordPress-based online blog that uses MyISAM – the default MySQL engine, and a Magento web store that uses InnoDB, for example.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-built Hepsia Control Panel include a software bundle that is pre-installed and besides everything else, you will get the InnoDB database storage engine, so you won’t need to activate it manually if you would like to use open-source PHP scripts that need it. All it takes to install such a script is to create a new MySQL database and to initiate the installation process – once the script installation wizard gains access to the database and starts inserting content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You’ll also be able to install scripts that require the other very popular MySQL engine, MyISAM, so you won’t need to modify any settings on the server. This will allow you to activate different scripts on one single server and to use it to its maximum potential.