InnoDB is a database engine for MySQL databases, which is used by famous script-based applications such as Magento and Joomla™ 3. It is excellent for scalable applications, since it works really well when handling enormous amounts of data. Rather than locking the whole table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same length of time. In addition, InnoDB offers a much better database failure recovery and supports transactions and foreign key constraints – rules that specify how data inserts and updates should be handled. In case a specific operation has not been fully completed for whatever reason, the action will be rolled back. In this way, the content in the database will be retained safe and sound and won’t be partially merged with newly entered content.

InnoDB in Web Hosting

InnoDB is available with all our Linux web hosting packages by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any PHP script-driven software app which requires the InnoDB database storage engine without any impediments once you activate your account. InnoDB will be pre-selected as the default engine for a particular database during the app activation, no matter if you take advantage of our 1-click installer or create the database and install the application manually, as long as the app requires it instead of the more famous MyISAM engine. We will carry out daily MySQL database backups, so you can be sure that you’ll never lose any content if you erase a database by accident or you overwrite some important info – you simply need to alert us and we will restore your database the way it was.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database from the hosting Control Panel included with all our semi-dedicated server plans and you start installing a PHP-driven software app either manually or using our single-click application installer tool, the database storage engine will be picked automatically depending on the given app’s requirements. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that requires it without any manual intervention needed on your end at any point. To avoid any chance of losing data if you update an app or if you delete a database unintentionally, we’ll carry out a backup of all your MySQL databases each day, so if something happens, we can rescue your content.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting packages ordered with our in-house built Hepsia hosting Control Panel come with a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB storage engine, so you won’t need to activate it manually if you want to activate PHP scripts that need it. All it takes to use such a script is to set up a new MySQL database and to initiate the installation process – once the installation wizard obtains access to the database and starts dumping data in it, InnoDB will be set as the default 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 the other widely used MySQL engine, MyISAM, so you will not need to update any settings on the dedicated server. This will allow you to use various scripts on a single physical machine and to use the latter to its maximum potential.