InnoDB is a database engine for MySQL relational databases, which is used by widespread script-based apps like Magento and Joomla 3. It’s ideal for scalable apps, because it works really well when processing huge amounts of data. Rather than locking the entire table to append new information to a database like many other engines do, InnoDB locks only one row, so it can process much more tasks for the same period of time. In addition, InnoDB offers a much better database crash recovery and supports database transactions and foreign key constraints – a set of rules that determine how data inserts and modifications should be handled. If a specific operation has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the content in the database will remain safe and sound and will not be partially mixed with new content.

InnoDB in Shared Web Hosting

While InnoDB is either not offered or it is a paid upgrade with other web hosting companies, it’s an integral part of the standard set of services offered with our shared web hosting packages. If you would like to use an open-source script-powered software application that needs InnoDB specifically, in order to be installed and to operate properly, you will not have any impediments because the MySQL database storage engine is available on our in-house built cloud platform. Irrespective of whether you create a new database and activate an application manually or make use of our 1-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the application requires it rather than MyISAM. In addition to the amazing database failure recovery that InnoDB offers, we also make daily database backups, so that we can easily recover any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database through the Control Panel coming with each of our semi-dedicated server packages and you begin installing a PHP script-driven software app either manually or using our 1-click app installer tool, the storage engine for the database will be picked automatically depending on the requirements of the given app. As InnoDB is present on the cloud website hosting platform where your new account will be created, it will be set as the default engine for any application that requires it without any manual intervention needed on your end at any point. To prevent any chance of losing information if you update an app or if you delete a database by mistake, we’ll generate backups of all your databases each day, so if anything goes wrong, we can retrieve your content.

InnoDB in Dedicated Hosting

All Linux dedicated servers hosting packages that are ordered with our custom Hepsia Control Panel come with a software bundle that is pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not need to install it manually if you would like to use scripts that require it. All it takes to activate such a script is to set up a new database and to initiate the setup – as soon as the script setup wizard obtains access to the database in question and starts importing content into it, InnoDB will be set as the default engine for this database provided that it is the one required by the particular script. You’ll also be able to run scripts that need MyISAM, the other widely used MySQL engine, so you will not have to configure any settings on the server. This will enable you to install different scripts on a single machine and to use the latter to its fullest capabilities.