InnoDB is a database storage engine for MySQL relational databases, which is used by well known open-source script-driven web apps such as Magento and Joomla™ 3. It is excellent for scalable applications, because it works incredibly well when processing enormous volumes of data. Rather than locking the entire table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can process much more tasks for the same length of time. Also, InnoDB offers a much better database failure recovery and supports transactions and foreign keys – rules that determine how data imports and modifications should be handled. In case a specific task has not been fully completed for any reason, the action will be rolled back. Thus, the database content will stay safe and sound and will not be partially mixed with newly added content.

InnoDB in Website Hosting

InnoDB is offered with all our website hosting by default, not upon request or as a paid upgrade, so you can install and manage any PHP-driven app that needs the InnoDB storage engine without encountering any obstacle once you activate your shared website hosting account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app activation, regardless of whether you make use of our single-click installer or create the database and install the application manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We’ll generate regular database backups, so you can be sure that you won’t ever lose any data in case you erase a database by accident or you overwrite some vital information – you’ll simply have to get in touch with us and we’ll restore the database the way it was.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database through the hosting Control Panel included with all our semi-dedicated server accounts and you start installing a PHP script-driven software application either manually or using our 1-click application installer tool, the storage engine for the database will be set automatically depending on the requirements of the particular application. Since InnoDB is present on the cloud website hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any app that needs it without the need for any manual action on your end at any point. To avoid any risk of losing data if you update an application or if you erase a database unintentionally, we will make backups of all your databases every day, so if anything happens, we can retrieve your content.

InnoDB in VPS Servers

When you acquire a VPS server from our company, you will be able to make use of our custom-built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will permit you to manage any script-driven software app that needs InnoDB, as this MySQL database storage engine is an essential part of the default software bundle that will be pre-installed on your Virtual Private Server during its setup. When you create a brand-new database through the hosting Control Panel, you will just have to start installing an application – manually or using our application installer tool. InnoDB will be set as the default engine on the condition that the application in question needs it, so you will not have to do anything else in your VPS account. Analogously, if an application requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-built Hepsia Control Panel come with a software bundle that is pre-installed and among everything else, you’ll get the InnoDB database engine, so you will not have to activate it manually if you wish to use open-source PHP scripts that need it. All it takes to use such a script is to create a new MySQL database and to start the setup – as soon as the setup wizard gains access to the database in question and starts importing data 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 install scripts that require MyISAM, the other very popular MySQL engine, so you will not have to modify any settings on the dedicated server. This will allow you to install various scripts on one single machine and to use it to its maximum potential.