InnoDB is a very popular storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got a number of strengths which have made it the engine of choice for plenty of PHP-powered applications, including Magento and Joomla™, which have shifted over to InnoDB permanently. For instance, adding large volumes of data will be faster with InnoDB, as it locks only a single row to complete a particular task, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the info is handled. Simply put, importing new or modifying existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if some problem occurs during the process, which means that the content that remains in the database will not be damaged.

InnoDB in Hosting

InnoDB is available with all our hosting plans by default, not upon request or as a paid upgrade, so you’ll be able to activate and run any script-driven software application that requires the MySQL database storage engine without encountering any impediment once you activate your shared hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app activation, no matter if you use our single-click installer or create the database and set up the application manually, provided that the application requires it instead of the more popular MyISAM engine. We’ll maintain daily MySQL database backups, so you can be certain that you will never lose any data in case you erase a database by mistake or you overwrite some vital info – you will just need to alert us and we will restore your database back to normal.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database from the hosting Control Panel provided with all our semi-dedicated server plans and you start installing an open-source script-powered web app either manually or using our 1-click application installer tool, the MySQL database storage engine will be selected automatically on the basis of the requirements of the particular application. As InnoDB is present on the cloud web hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for each app that requires it without the need for any manual action on your end at any point. To prevent any risk of losing data if you update an app or if you remove a database by mistake, we’ll perform a backup of all your databases each day, so if something goes wrong, we can recover your data.

InnoDB in VPS Servers

When you obtain a VPS server from us, you will be able to use our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to use any open-source script-powered web application which needs InnoDB, as this particular database engine is included in the software bundle that will be pre-installed on your server during its creation. When you set up a brand new MySQL database using the hosting Control Panel, you just need to begin installing an app – manually or using our app installer. InnoDB will be set as the default engine in case the application in question needs it, so you will not need to do anything else in your VPS account. Identically, if an application requires MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers

All Linux dedicated web hosting plans that are ordered with our custom-developed Hepsia hosting Control Panel come with a software bundle that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not need to install it manually if you would like to activate PHP scripts that require it. All it takes to install such a script is to set up a new database and to begin the installation – once the script setup wizard receives access to the database and begins entering data into 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 use scripts that need the other very popular MySQL engine, MyISAM, so you won’t have to change any settings on the dedicated server. This will allow you to activate different scripts on one single server and to use it to its maximum capacity.