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 many advantages which have made it the preferred engine for many script-based web apps, among them Joomla and Magento, which have switched over to InnoDB permanently. For example, importing immense volumes of data will be faster with InnoDB, because it locks only a single database row to complete a task, not the entire database table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is tackled. Simply put, adding new or editing existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if a certain problem occurs in the meantime, thus the content that remains in the database won’t be lost.

InnoDB in Website Hosting

While InnoDB is either not available or a paid upgrade with many web hosting providers, it is an essential part of the standard set of features that we are offering with our website hosting packages. If you wish to use a PHP-powered app that needs InnoDB in particular, in order to be activated and to operate correctly, you will not come across any difficulties because the InnoDB storage engine is available on our in-house built cloud hosting platform. Irrespective of whether you create a brand-new MySQL database and install an app manually or make use of our 1-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the given application needs it rather than MyISAM. Besides the remarkable crash recovery that InnoDB offers, we also generate daily backups of all databases, so we can swiftly restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers include InnoDB and you’ll be able to get the most out of all the features of this database engine with any PHP script-driven software application that requires it. InnoDB is among the engines that we have on our cloud platform, so the one that will be selected depends on the requirements of the app in question. You will not need to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer tool. To be on the safe side, we’ll maintain daily backups of all your MySQL databases, so if something goes wrong after some update or if you delete some data by accident, we will be able to restore your database the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an essential part of the standard software package that will be pre-installed on your Virtual Private Server before we hand it over to you. You will not have to set up anything manually and you will be able to enable and use any PHP-powered software app that requires InnoDB once your VPS is set up, which takes no more than sixty minutes after the order submission procedure itself. A number of engines are offered, so every time you set up a database using the Hepsia Control Panel, a particular engine will be picked when the app installation commences and our system will recognize which engine is required by the app in question. If you have to use MyISAM, for example, you won’t need to do anything different from installing the desired app, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

All dedicated service that are ordered with our in-house built Hepsia hosting Control Panel include a software package that’s pre-installed and among everything else, you will get the InnoDB database storage engine, so you will not need to add it manually if you want to use open-source scripts that require it. All it takes to run such a script is to set up a new database and to initiate the setup process – as soon as the script configuration wizard accesses the database in question and starts dumping content in it, InnoDB will be set as the default engine for this database as long as 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 have to modify any settings on the dedicated server. This will allow you to use various scripts on one single physical server and to use the latter to its fullest capabilities.