InnoDB is a very popular database engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got a number of strong sides which have made it the preferred engine for many open-source script-driven software applications, among them Joomla and Magento, which have switched over to InnoDB for good. For instance, importing immense data volumes will be faster with InnoDB, because it locks only one database row to complete a specific operation, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the data is treated. To put it simply, adding new or modifying existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case some issue appears during the process, therefore the content that remains in the database won’t be lost.

InnoDB in Cloud Hosting

You’ll be able to use any open-source script-driven application that needs InnoDB in case you’ve got a cloud hosting service with us, as the database storage engine is available on our advanced cloud platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can run applications which use the MyISAM engine without any impediments as well and, once again, the engine will be pre-selected, so you will not need to edit anything manually at any moment. In addition, we will also perform daily backups of all the databases that you’ve got in your account, so in case you erase or overwrite something, we can swiftly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting service support InnoDB and you’ll be able to take full advantage of all the features offered by this database engine with any script-powered software app that requires it. It is among the engines that we have on our cloud platform, so the one that will be selected depends on the given app’s prerequisites. You won’t need to do anything manually in order to activate InnoDB, since it will be set as the default engine when you install an app – whether manually or using our single-click app installer. To avoid any risk, we will generate daily backups of all your databases, so if something goes wrong after some update or if you erase some content by accident, we’ll be able to restore the database the way it was on any of the previous seven days.

InnoDB in VPS Servers

If our custom Hepsia hosting Control Panel is picked during the signup process for a new VPS servers , InnoDB will be installed on the VPS server along with other needed software, so you will not have to do anything if you decide to use PHP script-based software apps that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be installed as well. You can create a new database and begin the app installation process manually or through our single-click installer tool. The system will recognize which engine the particular app requires and will assign it to the specific database, so the installation process will proceed flawlessly and the app can insert its content into that database. Thus, you can manage applications with various prerequisites in regard to the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers

When you get a new dedicated server, you’ll be able to select one of the 3 Control Panels that we offer – Hepsia, DirectAdmin and cPanel. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to activate this database engine manually to be able to use PHP-driven web applications that require it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the server resources that you require in order to run large-scale Internet sites, it is pretty possible that you will resort to InnoDB. You’ll be able to make use of other engines too, so in case a certain application requires MyISAM rather than InnoDB, you won’t have any complication while managing it. The engine that will be used will be automatically recognized once the app installation procedure starts, so you will not need to modify any settings manually at any point.