InnoDB is a storage engine for MySQL databases, which is used by widely used PHP-driven web apps like Joomla v3 and Magento. It’s excellent for scalable applications, as it works remarkably well when processing large data volumes. Rather than locking the entire database table to import new information into a database as many other engines do, InnoDB locks only one row, so it can process much more tasks for the same length of time. Additionally, InnoDB offers a faster database failure recovery and supports database transactions and foreign key constraints – rules that define how data imports and modifications should be handled. In case a particular operation hasn’t been entirely completed for some reason, the action will be rolled back. In this way, the database content will remain intact and won’t be partially mixed with newly appended content.

InnoDB in Cloud Website Hosting

You can make use of any open-source script-driven web app that requires InnoDB in case you’ve got a cloud website hosting plan with us, as the MySQL database engine is available on our leading-edge cloud hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is required. You can activate applications that require the MyISAM engine without having to deal with any difficulty as well and, once again, the engine will be pre-selected, so you won’t have to update anything manually at any moment. In addition, we will also create regular backups of all the databases that you have in the shared hosting account, so in case you erase or overwrite anything, we can quickly get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

You can activate a PHP-based web app that needs InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are created on our leading-edge cloud web hosting platform where the database storage engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you use our single-click app installer tool. Either way, the required engine will be chosen automatically the moment the activation of the application starts, so you will not need to update anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. On top of that, we’ll always be able to retrieve any of your databases in case you accidentally erase one, as we generate several backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS Servers

If our custom Hepsia Control Panel is chosen during the signup process for your new VPS web hosting plans , InnoDB will be activated on the Virtual Private Server together with other required software, so you won’t have to do anything if you decide to make use of PHP-based web apps that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated too. You can set up a brand new database and begin installing the app manually or using our 1-click installer. The system will detect the engine that the particular app requires and will set it for the specific MySQL database, so the installation process will proceed impeccably and the app can dump its content in that database. Thus, you can install apps with different requirements with regard to the MySQL engine without having to make any modifications on your server.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our in-house built Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB database storage engine, so you won’t have to activate it manually if you would like to run PHP scripts that require it. All it takes to use such a script is to set up a new MySQL database and to begin the installation – once the script configuration wizard gains access to the database and begins dumping data in it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You will also be able to install scripts that need MyISAM – the other widely used MySQL engine, so you won’t need to configure any settings on the server. This will enable you to activate different scripts on one single machine and to use the latter to its full capacity.