InnoDB is a very popular database storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got numerous pluses which make it the engine of choice for plenty of script-based software apps, such as Joomla and Magento, which have shifted over to InnoDB for good. For instance, importing large data volumes will be faster with InnoDB, as it locks only a single row to perform a certain task, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the data is tackled. Simply put, importing new or modifying existent data will either be entirely completed, or will be annulled and the operation will be rolled back in case some issue appears in the meantime, which means that the content that remains in the database won’t be lost.

InnoDB in Shared Website Hosting

While InnoDB is either not available or a paid upgrade with many web hosting providers, it is an integral part of the default set of features that we’re offering with our shared website hosting packages. In case you would like to make use of a script-based software application that needs InnoDB particularly, in order to be installed and to perform properly, you will not have any obstacles as the database storage engine is available on our custom-built cloud platform. Regardless of whether you set up a new MySQL database and install an application manually or take advantage of our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the respective application needs it rather than MyISAM. Besides the incredible crash recovery that InnoDB is offering, we also carry out regular database backups, so we can swiftly restore any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

You can activate a PHP-driven software app that needs InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are set up on our avant-garde cloud platform where the MySQL database engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our 1-click app installer. In either case, the needed engine will be chosen automatically as soon as the installation of the app begins, so you will not have to edit anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases if you remove one by accident, as we make a few backups every day, each of which is preserved for one whole week.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia Control Panel, the InnoDB database engine will be an indivisible part of the default software bundle that will be pre-installed on your server before we give it to you. You won’t have to configure anything manually and you’ll be able to install and run any script-powered software app that requires InnoDB as soon as your VPS is ready, which takes no more than sixty minutes after the order process itself. Several engines are available, so every time you create a database through the Hepsia Control Panel, a specific engine will be selected when the app activation begins and our system will recognize the engine that is required by the app in question. In case you need MyISAM, for example, 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 Linux dedicated service ordered with our custom-developed Hepsia hosting Control Panel include a software bundle that is pre-activated and among everything else, you will get the InnoDB storage engine, so you won’t need to add it manually if you need to run open-source scripts that need it. All it takes to use such a script is to set up a new MySQL database and to start the setup process – once the installer wizard acquires access to the database in question and begins importing data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You will also be able to run scripts that require MyISAM, the other popular MySQL engine, so you will not have to configure any settings on the server. This will allow you to run various scripts on a single physical server and to use the latter to its full potential.