InnoDB is a database storage engine for MySQL relational databases, which is used by popular script-based web applications like Joomla™ 3 and Magento. It’s ideal for scalable apps, because it works unbelievably well when processing huge data volumes. Rather than locking the whole database table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can handle a lot more tasks for the same length of time. Moreover, InnoDB offers a much faster crash recovery and supports database transactions and foreign key constraints – a set of rules that specify how data inserts and modifications should be handled. If a given task hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the information in the database will be preserved intact and will not be partially mixed with newly appended content.

InnoDB in Hosting

Every open-source script-based app that needs InnoDB will run flawlessly on our advanced cloud website hosting platform and the database storage engine comes with all our hosting plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database will make use of will be selected on the basis of the app’s prerequisites without the need to edit any setting in your shared web hosting account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to get the most out of its full capacity. We will maintain daily backups of your content, so if you unintentionally remove a MySQL database that is important to you or you overwrite some part of it, we’ll be able to restore the database the way it was only several hours ago.

InnoDB in Semi-dedicated Servers

All our semi-dedicated plans include InnoDB and you will be able to make use of all the options offered by this MySQL database engine with any script-driven web application that requires it. It is among the engines that we have on our cloud hosting platform, so the one that will be used depends on the requirements of the specific app. You won’t have to do anything manually in order to activate InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer. To avoid any risk, we’ll perform regular database backups, so if something goes wrong following an upgrade or if you delete some data by mistake, we will be able to restore your database the way it was on any of the past seven days.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom Hepsia hosting Control Panel come with a software package that is pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you won’t have to install it manually if you would like to use scripts that require it. All it takes to install such a script is to set up a new database and to initiate the installation process – as soon as the script setup wizard acquires access to the database in question 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 needed by the particular script. You’ll also be able to use scripts that require the other very popular MySQL engine – MyISAM, so you won’t need to edit any settings on the dedicated server. This will allow you to run a variety of scripts on a single physical server and to use the latter to its fullest capacity.