InnoDB is a database engine for MySQL databases, which is used by widely used script-driven software apps such as Joomla 3 and Magento. It’s perfect for scalable apps, as it works unbelievably well when managing immense volumes of data. Instead of locking the entire database table to add new information to a database as many other engines do, InnoDB locks only one row, so it can complete much more operations for the same length of time. Plus, InnoDB offers an improved database failure recovery and supports database transactions and foreign key constraints – rules that define how data imports and modifications should be treated. If a particular operation has not been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will be preserved undamaged and will not be partially merged with new content.

InnoDB in Cloud Hosting

You can install any PHP-driven app that requires InnoDB if you’ve got a cloud hosting with us, as the MySQL database engine is available on our leading-edge cloud website hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can install applications that require the MyISAM engine without the need to deal with any problem as well and, again, the engine will be selected automatically, so you won’t need to modify any setting manually at any moment. In addition, we’ll also perform regular backups of all the databases that you’ve got in your shared web hosting account, so in case you delete or overwrite anything, we can swiftly get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers come with InnoDB and you’ll be able to make the most of all the options offered by this MySQL database storage engine with any script-based web application that needs it. It is among the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the particular app’s prerequisites. You won’t have to do anything manually to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our 1-click app installer. To be on the safe side, we’ll generate daily database backups, so if anything goes wrong following an update or if you delete some content 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 Servers

When you buy a VPS server from our company, you will be able to make use of our in-house built Hepsia Control Panel to manage your content. A Hepsia-managed VPS will permit you to run any PHP script-powered software application which needs InnoDB, as the MySQL storage engine is an integral part of the software bundle that will be installed on the VPS server during its configuration. When you create a brand-new database via the hosting Control Panel, you will just have to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine if the app in question requires it, so you won’t need to do anything else in your VPS account. In the same manner, if an app requires MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our in-house developed Hepsia hosting Control Panel include a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB database engine, so you won’t have to add it manually in case you want to use open-source scripts that require it. All it takes to run such a script is to create a new database and to start the installation – as soon as the setup wizard receives access to the database and starts entering data into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to activate scripts that need MyISAM – the other popular MySQL engine, so you won’t need to update any settings on the server. This will allow you to run a variety of scripts on a single machine and to use it to its full capabilities.