InnoDB is a database storage engine for MySQL databases, which is used by well known PHP-driven software applications such as Joomla 3.x and Magento. It is perfect for scalable applications, since it works incredibly well when managing immense amounts of data. Instead of locking the whole table to add new information to a database as many other engines do, InnoDB locks only one row, so it can perform a lot more operations for the same length of time. Plus, InnoDB offers an improved database failure recovery and supports transactions and foreign key constraints – a set of rules that prescribe how data inserts and modifications should be treated. If a given operation has not been thoroughly completed for some reason, the action will be rolled back. Thus, the database content will be kept safe and sound and will not be partially mixed with newly inserted content.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud hosting plans by default, not upon request or as a paid upgrade, so you can install and run any PHP-driven software application that requires the InnoDB database storage engine without any problem once you order your shared website hosting account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app installation, irrespective of whether you make use of our one-click installation tool or create the MySQL database and install the application manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We will store daily backups of all your MySQL databases, so you can rest assured that you’ll never lose any content in case you erase a database accidentally or you overwrite some essential info – you’ll just have to alert us and we’ll restore your content the way it was.

InnoDB in Semi-dedicated Servers

All our semi-dedicated plans include InnoDB and you can use all the features offered by this database engine with any PHP-based web application that needs it. InnoDB is one of the engines that we have on our cloud hosting platform, so the one that will be picked depends on the given app’s prerequisites. You won’t need to do anything manually to enable InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our 1-click application installer tool. To be on the safe side, we will store regular backups of all your databases, so if anything goes wrong following some update or if you delete some content by mistake, we’ll be able to restore the database the way it was on any of the previous seven days.

InnoDB in Dedicated Servers

If you get a new dedicated server, you’ll be able to select any of the 3 Control Panels that we offer – Hepsia, DirectAdmin and cPanel. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to install this MySQL database engine manually so as to be able to run script-powered applications that need it. InnoDB is used by scalable applications and since a dedicated server will offer you all the server resources that you need to manage large-size websites, it’s pretty possible that you will resort to InnoDB. You’ll be able to use other engines as well, so if a given app requires MyISAM instead of InnoDB, you won’t have to deal with any obstacle while using it. The engine that will be used will be recognized automatically when the app installation starts, so you will not need to update any settings manually at any moment.