InnoDB is a storage engine for MySQL databases, which is used by well known open-source script-powered software apps like Magento and Joomla™ 3. It’s ideal for scalable applications, since it performs unbelievably well when managing immense volumes of data. Instead of locking the entire database table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can carry out much more operations for the same length of time. Plus, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – rules that define how data imports and modifications should be handled. If a certain operation hasn’t been fully completed for some reason, the action will be rolled back. In this way, the content in the database will be kept intact and will not be partially merged with newly added content.

InnoDB in Web Hosting

InnoDB is available with all our Linux web hosting by default, not upon request or as a paid upgrade, so you’ll be able to install and manage any script-powered application which needs the InnoDB database storage engine without having to deal with any impediment once you order your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app installation process, regardless of whether you use our one-click installation tool or create the database and activate the application manually, as long as the application requires it instead of the more popular MyISAM engine. We’ll generate daily MySQL database backups, so you can rest assured that you won’t ever lose any data in case you erase a database by mistake or you overwrite some essential information – you will just have to touch base with us and we will restore everything back to normal.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting come with InnoDB and you’ll be able to take full advantage of all the features of this MySQL database storage engine with any script-driven web app that needs it. It’s among the engines that are available on our cloud website hosting platform, so the one that will be used depends on the requirements of the particular app. You will not need to do anything manually in order to enable InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer. To avoid any risk, we will carry out regular backups of all your databases, so if anything goes wrong following some update or if you remove some data by mistake, we’ll be able to restore your database the way it was on any of the previous 7 days.

InnoDB in VPS Hosting

In case our custom-developed Hepsia Control Panel is chosen during the signup process for a new Linux virtual private servers , InnoDB will be installed on the VPS server along with other essential software, so you will not have to do anything if you decide to make use of PHP-based web apps that require this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can set up a brand-new MySQL database and begin the app installation procedure manually or through our one-click installer. The system will automatically recognize which engine the particular app needs and will set it for the specific database, so the installation will continue impeccably and the application can enter its data into that database. In this way, you can manage apps with various prerequisites with regard to the MySQL engine without having to make any changes on your Virtual Private Server.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting that are ordered with our in-house developed Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you will not have to install it manually in case you would like to run open-source PHP scripts that need it. All it takes to run such a script is to create a new database and to initiate the setup – once the installation wizard gets access to the database and begins dumping content in it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the script. You will also be able to install scripts that require MyISAM, the other popular MySQL engine, so you won’t have to update any settings on the dedicated server. This will permit you to install various scripts on one single server and to use the latter to its maximum capabilities.