InnoDB is a storage engine for MySQL databases, which is used by widely used PHP-driven apps like Magento and Joomla™ 3. It is excellent for scalable applications, since it works exceptionally 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 carry out much more operations for the same period of time. Additionally, InnoDB offers a much better database failure recovery and supports database transactions and foreign keys – a set of rules that prescribe how data imports and updates should be treated. In case a specific task has not been fully completed for some reason, the action will be rolled back. In this way, the information in the database will stay safe and sound and will not be partially mixed with newly entered content.

InnoDB in Shared Hosting

InnoDB is offered with all our shared hosting service by default, not upon request or as a paid upgrade, so you’ll be able to activate and manage any script-driven software application that requires the MySQL database engine without encountering any obstacle as soon as you activate your shared account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app activation process, no matter if you make use of our one-click installer or create the MySQL database and activate the app manually, on the condition that the app requires it instead of the more famous MyISAM engine. We’ll maintain daily backups of all your MySQL databases, so you can be certain that you’ll never lose any data in case you delete a database by accident or you overwrite some crucial information – you will just need to inform us and we’ll restore your content back to normal.

InnoDB in Semi-dedicated Servers

You can use a script-powered application that requires InnoDB with all of our semi-dedicated server plans, because all the accounts are created on our cutting-edge cloud web hosting platform where the MySQL database engine is installed. A new database can be set up in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our 1-click application installer tool. Either way, the needed engine will be selected automatically the moment the installation of the application begins, so you won’t need to edit anything manually, irrespective of whether the application requires InnoDB or the more commonly used MyISAM. On top of that, we’ll always be able to retrieve any of your MySQL databases in case you accidentally remove one, as we create several backups every day, each of which is preserved for 7 days.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be included in the default software package that will be installed on your Virtual Private Server before we give it to you. You will not have to set up anything manually and you will be able to install and use any PHP-based web application that needs InnoDB as soon as your Virtual Private Server is set up, which takes no more than sixty minutes after the order submission procedure itself. A couple of engines are offered, so every time you set up a MySQL database via the Hepsia hosting Control Panel, a specific engine will be activated once the app installation process commences and our system will automatically detect which engine is required by the application in question. In case you need to use MyISAM, for instance, you will not need to do anything different than installing the app of your preference, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

All dedicated service that are ordered with our custom-developed Hepsia hosting Control Panel come with a software bundle that’s pre-installed and besides everything else, you will get the InnoDB database engine, so you will not need to add it manually in case you need to run open-source scripts that need it. All it takes to install such a script is to create a new MySQL database and to initiate the installation – as soon as the script installation wizard acquires access to the database and starts entering data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You will also be able to run scripts that require the other very popular MySQL engine, MyISAM, so you won’t need to configure any settings on the dedicated server. This will permit you to run different scripts on one single physical server and to use the latter to its maximum potential.