InnoDB is a storage engine for MySQL relational databases, which is used by widespread script-powered software apps such as Magento and Joomla 3.x. It’s excellent for scalable applications, as it works unbelievably well when processing immense data volumes. Rather than locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can execute a lot more operations for the same period of time. Also, InnoDB offers a much faster database failure recovery and supports transactions and foreign key constraints – a set of rules that indicate how data inserts and modifications should be handled. If a specific operation has not been fully completed for whatever reason, the action will be rolled back. Thus, the content in the database will stay safe and sound and will not be partially merged with newly imported content.

InnoDB in Hosting

While InnoDB is either not offered or it is a paid upgrade with many other hosting companies, it’s an essential part of the standard set of services that we are offering with our hosting plans. If you wish to make use of a script-powered software application that needs InnoDB particularly, in order to be installed and to work properly, you will not have to deal with any problems since the MySQL storage engine is available on our in-house developed cloud web hosting platform. Regardless of whether you set up a brand new database and install an app manually or use our one-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the specific application requires InnoDB instead of MyISAM. In addition to the amazing database failure recovery that InnoDB is offering, we also perform regular backups of all databases, so we can quickly restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

You can activate a PHP-based app that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our avant-garde cloud platform where the database engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you use our 1-click app installer. Either way, the required engine will be picked automatically as soon as the app’s activation begins, so you will not have to edit anything manually, regardless of whether the app requires InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to retrieve any of your MySQL databases in case you erase one by mistake, as we make a couple of backups every day, each of which is kept for 1 whole week.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be an integral part of the default software package that will be installed on your Virtual Private Server before we hand it over to you. You will not need to set up anything manually and you’ll be able to install and run any script-based software app that requires InnoDB as soon as your Virtual Private Server is ready, which takes no more than sixty minutes after the order submission process itself. A few engines are available, so whenever you set up a MySQL database using the Hepsia Control Panel, a particular engine will be selected once the app installation process commences and our system will automatically detect the engine that is required by the app in question. If you have to use MyISAM, for example, you won’t have to do anything different than installing the app of your preference, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

When you get a new dedicated server, you’ll be able to pick one of the three Control Panels that we offer – cPanel, DirectAdmin and Hepsia. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t have to add this database storage engine manually so as to be able to run open-source script-based web apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the server resources that you require to run very large Internet sites, it’s rather likely that you’ll resort to InnoDB. You will be able to use other engines too, so if a particular app requires MyISAM rather than InnoDB, you will not have to deal with any difficulty while using it. The engine that will be used will be automatically detected as soon as the app installation procedure starts, so you won’t have to update any settings manually whatsoever.