InnoDB is a database engine for MySQL databases, which is used by widely used open-source script-driven web applications such as Joomla 3 and Magento. It is ideal for scalable apps, since it performs incredibly well when handling immense volumes of data. Rather than locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can complete a lot more operations for the same period of time. Moreover, InnoDB offers an improved database failure recovery and supports database transactions and foreign key constraints – rules that determine how data imports and updates should be handled. If a particular operation has not been entirely completed for any reason, the action will be rolled back. In this way, the content in the database will be preserved undamaged and won’t be partially merged with newly appended content.

InnoDB in Hosting

You can make use of any PHP-based software app that requires InnoDB if you’ve got a hosting with our company, as the storage engine is available on our avant-garde cloud website hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly if this engine is required. You can run applications that require the MyISAM engine without the need to deal with any obstacle as well and, again, the engine will be selected automatically, so you won’t need to change any setting manually at any moment. On top of that, we’ll also carry out regular backups of all the MySQL databases that you have in the account, so if you delete or overwrite anything, we can swiftly get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you can make use of all the features of this database storage engine with any script-powered software app 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 particular application. You won’t have to do anything manually to enable InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer tool. To be on the safe side, we will store daily database backups, so if something goes wrong following an upgrade or if you remove some data by mistake, we will be able to get your database back to the way it was on any of the previous seven days.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be an essential part of the default software package that will be pre-installed on your VPS server before we give it to you. You won’t need to activate anything manually and you’ll be able to install and use any PHP-powered software app that requires InnoDB when your Virtual Private Server is ready, which takes no more than one hour after the order submission itself. A number of engines are offered, so whenever you set up a MySQL database through the Hepsia hosting Control Panel, a particular engine will be selected when the app activation process commences and our system will recognize the engine that is required by the app in question. If you have to use MyISAM, for instance, you won’t have to do anything different than installing the app of your preference, whether manually or using our application installer.

InnoDB in Dedicated Servers

When you buy a new dedicated server, you’ll be able to pick any of the 3 hosting Control Panels that we’re offering – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to install this MySQL storage engine manually in order to be able to manage script-based web apps that need it. InnoDB is used by scalable applications and since a dedicated server will offer you all the system resources that you require in order to run very large Internet sites, it’s rather likely that you’ll resort to InnoDB. You will be able to make use of other engines as well, so in case a certain app requires MyISAM instead of InnoDB, you will not encounter any difficulty while managing it. The engine that will be used will be recognized automatically once the app installation process commences, so you will not need to modify any setting manually whatsoever.