InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it offers a much better overall performance and a faster database failure recovery in comparison with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by a lot of programmers that build scalable applications, because it works more effectively with large volumes of data, while it keeps the server load at a minimum. In addition, it locks only a single database row in case any information should be modified, whereas many other engines lock the entire table and hence require much more time to accomplish several consecutive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for some reason, the operation is rolled back to avoid scrambling or losing data. Magento and the newest releases of Joomla are two examples of popular script-powered applications that have switched to InnoDB.

InnoDB in Web Hosting

InnoDB is offered with all our web hosting plans by default, not as a paid upgrade or upon request, so you can activate and run any PHP-powered web app which requires the InnoDB database engine without the need to deal with any complication once you open your shared hosting account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app activation, irrespective of whether you take advantage of our single-click installer or create the MySQL database and activate the application manually, as long as the app requires InnoDB instead of the more popular MyISAM engine. We’ll store regular MySQL database backups, so you can be sure that you’ll never lose any content in case you erase a database accidentally or you overwrite some essential information – you will simply have to alert us and we will restore everything back to normal.

InnoDB in Semi-dedicated Servers

You can use a PHP script-driven software application that requires InnoDB with any of our semi-dedicated server plans, since all the accounts are created on our cutting-edge cloud hosting platform where the MySQL storage engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you use our single-click application installer. Either way, the required engine will be picked automatically once the activation of the app starts, so you will not need to update anything manually, irrespective of whether the app needs InnoDB or the more widely used MyISAM. Also, we’ll always be able to recover any of your MySQL databases in case you unintentionally delete one, as we create a couple of MySQL database backups every day, each of which is stored for 7 days.

InnoDB in VPS Servers

When you purchase a VPS server from us, you’ll be able to use our custom Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will permit you to install any PHP script-driven application which requires InnoDB, as the MySQL database storage engine is an integral part of the software bundle that will be pre-installed on the VPS server during its configuration. When you create a brand-new database through the hosting Control Panel, you simply need to begin installing an app – manually or using our application installer. InnoDB will be set as the default engine in case the application in question requires it, so you won’t need to do anything else in your account. Identically, if a certain app requires MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our in-house built Hepsia Control Panel come with a software package that is pre-activated and among everything else, you will get the InnoDB database storage engine, so you won’t need to activate it manually if you need to use open-source 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 process – as soon as the script setup wizard gains access to the database and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You will also be able to install scripts that require MyISAM – the other popular MySQL engine, so you won’t have to edit any settings on the dedicated server. This will allow you to use various scripts on a single physical machine and to use the latter to its maximum potential.