InnoDB is a database storage engine for MySQL relational databases, which is used by widely used open-source script-powered software apps such as Magento and Joomla™ v3. It’s perfect for scalable apps, as it works really well when handling enormous data volumes. Rather than locking the entire database table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same period of time. In addition, InnoDB offers a faster database failure recovery and supports database transactions and foreign key constraints – rules that define how data inserts and updates should be handled. In case a particular operation hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the content in the database will remain intact and won’t be partially merged with newly imported content.

InnoDB in Web Hosting

Any script-driven app that requires InnoDB will function flawlessly on our cutting-edge cloud platform and the MySQL storage engine comes with all our web hosting plans. Every time you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected on the basis of the app’s prerequisites without having to edit any setting in your shared account. InnoDB will be picked automatically for any app that requires this particular engine and you will be able to get the most out of its full potential. We’ll make daily backups of your content, so in case you accidentally erase a MySQL database that you need or you overwrite some part of it, we’ll be able to restore your data the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers support InnoDB and you can make use of all the features of this storage engine with any PHP-driven software application that needs it. It’s among the engines that we have on our cloud platform, so the one that will be used depends on the requirements of the given application. You won’t have to do anything manually in order to activate InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer tool. To be on the safe side, we will store regular backups of all your MySQL databases, so if anything goes wrong following an upgrade or if you delete some content unintentionally, we’ll be able to restore the database the way it was on any of the past 7 days.

InnoDB in Dedicated Servers

All Linux dedicated service that are ordered with our in-house developed Hepsia Control Panel include a software bundle that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you will not need to activate it manually if you need to run scripts that require it. All it takes to run such a script is to set up a new MySQL database and to begin the setup process – once the installation wizard receives access to the database in question and begins dumping content in it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You will also be able to activate scripts that require MyISAM, the other very popular MySQL engine, so you won’t have to configure any settings on the server. This will permit you to install a variety of scripts on one single server and to use the latter to its full capacity.