InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a better overall performance and an improved database crash recovery compared to the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is endorsed by numerous developers that run highly scalable web apps, as it works much more effectively with large data volumes, while it keeps the server load low. Additionally, it uses row-level locking if any info should be edited, whereas lots of other engines lock the entire database table and hence require more time to process several sequential tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for some reason, the operation is rolled back to avoid confusion or losing data. Magento and the newest editions of Joomla are two examples of widely used PHP-driven software platforms that have moved to InnoDB.

InnoDB in Shared Hosting

InnoDB is available with all our Linux shared hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and run any open-source script-powered web application which needs the InnoDB storage engine without the need to deal with any obstacle as soon as you open your shared account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app activation, no matter if you make use of our one-click installer or create the MySQL database and set up the application manually, as long as the application requires InnoDB instead of the more famous MyISAM engine. We’ll generate regular backups of all your MySQL databases, so you can be certain that you will never lose any data in case you erase a database unintentionally or you overwrite some essential info – you will simply have to get in touch with us and we will restore your data back to normal.

InnoDB in Semi-dedicated Hosting

You can use an open-source script-based application that needs InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our cutting-edge cloud web hosting platform where the database engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you make use of our single-click app installer tool. Either way, the needed engine will be picked automatically once the activation of the application begins, so you won’t have to configure anything manually, irrespective of whether the application requires InnoDB or the more widely used MyISAM. In addition, we’ll always be able to recover any of your MySQL databases in case you accidentally delete one, as we carry out a few MySQL database backups every day, each of which is kept for seven days.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting ordered with our custom-built Hepsia Control Panel come with a software package that is pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you will not have to activate it manually if you’d like to activate open-source PHP scripts that need it. All it takes to use such a script is to create a new MySQL database and to begin the setup process – as soon as the setup wizard accesses the database and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You will also be able to install scripts that require MyISAM – the other popular MySQL engine, so you won’t need to configure any settings on the dedicated server. This will permit you to use a variety of scripts on a single machine and to use it to its fullest potential.