InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it offers a better overall performance and a faster database crash recovery in comparison to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by a lot of devs that write scalable apps, since it works more efficiently with huge volumes of data, while it keeps the server processing load at a minimum. Additionally, it locks only a single row in the database if any info should be modified, whereas many other engines lock the entire database table and thus need more time to process multiple sequential tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – in case the entire data modification process cannot be completed for any reason, the action is rolled back to prevent scrambling or data loss. Magento and the latest editions of Joomla are two examples of widely used PHP script-based software apps that have switched to InnoDB.

InnoDB in Shared Hosting

InnoDB is available with all our shared hosting by default, not upon request or as a paid upgrade, so you can activate and manage any PHP script-powered app which requires the database storage engine without any difficulty as soon as you activate your shared website hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app installation process, irrespective of whether you take advantage of our 1-click installation tool or create the database and set up the application manually, on the condition that the application requires it instead of the more popular MyISAM engine. We will store regular backups of all your databases, so you can rest assured that you won’t ever lose any content in case you delete a database unintentionally or you overwrite some key info – you’ll just have to alert us and we will restore your data the way it was.

InnoDB in Semi-dedicated Servers

You can make use of a PHP-based software application that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our advanced cloud web hosting platform where the MySQL storage engine is installed. A new MySQL database can be set up in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you use our one-click application installer. In either case, the required engine will be chosen automatically the moment the activation of the app starts, so you will not need to configure anything manually, no matter if the app needs InnoDB or the more regularly used MyISAM. In addition, we will always be able to restore any of your MySQL databases if you accidentally erase one, as we carry out a couple of database backups every day, each of which is preserved for one whole week.

InnoDB in VPS Servers

If our in-house developed Hepsia hosting Control Panel is picked during the registration process for your new VPS web hosting plans , InnoDB will be installed on the Virtual Private Server along with other essential software, so you won’t need to do anything if you decide to make use of PHP script-powered software apps that require this MySQL storage engine. The default MySQL engine – MyISAM, will be installed as well. You can create 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 application needs and will assign it to the specific database, so the installation process will continue impeccably and the application can insert its data into that database. Therefore, you can activate applications with different prerequisites in regard to the MySQL engine without the need to make any changes on your VPS server.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our in-house developed Hepsia hosting Control Panel come with a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you will not need to add it manually in case you would like to use open-source PHP scripts that require it. All it takes to run such a script is to create a new MySQL database and to begin the setup – as soon as the installer wizard accesses the database and starts inserting data into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to activate scripts that require the other popular MySQL engine – MyISAM, so you will not need to update any settings on the dedicated server. This will allow you to use various scripts on a single server and to use the latter to its full capacity.