InnoDB is a MySQL storage engine, which has been gaining in popularity lately, because it provides a significantly better overall performance and an improved database crash recovery compared to the default engine used by the MySQL DBMS – MyISAM. InnoDB is used by plenty of web developers that write highly scalable applications, due to the fact that it works more effectively with enormous data volumes, while it keeps the server processing load at a minimum. What’s more, it it locks only one row in the database if anything should be modified, whereas many other engines lock the entire table and hence need much more time to fulfill multiple successive tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – in case the entire data modification cannot be completed for any reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest releases of Joomla are two examples of widespread script-driven software apps that have switched to InnoDB.

InnoDB in Shared Web Hosting

You can use any open-source script-driven software app that requires InnoDB if you’ve got a Linux shared web hosting with us, as the MySQL storage engine is available on our leading-edge cloud hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is needed. You can run applications which require the MyISAM engine without having to deal with any impediment as well and, again, the engine will be selected automatically, so you won’t need to configure any setting manually at any moment. What’s more, we’ll also make daily backups of all the databases that you have in the shared web hosting account, so if you erase or overwrite something, we can swiftly get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

You can activate an open-source script-based software app that requires InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our advanced cloud web hosting platform where the database storage engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our single-click application installer tool. In either case, the needed engine will be chosen automatically once the app’s installation starts, so you won’t have to modify anything manually, no matter if the app requires InnoDB or the more regularly used MyISAM. Furthermore, we will always be able to restore any of your MySQL databases in case you erase one by mistake, as we carry out a few backups every day, each of which is stored for one week.

InnoDB in Dedicated Hosting

All Linux dedicated hosting ordered with our custom-developed Hepsia Control Panel include a software bundle that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to install it manually in case you wish to use open-source scripts that need it. All it takes to run such a script is to set up a new MySQL database and to begin the setup – once the setup wizard gets access to the database and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the particular script. You will also be able to install scripts that require MyISAM, the other very popular MySQL engine, so you won’t have to change any settings on the dedicated server. This will permit you to run various scripts on a single physical server and to use the latter to its full capabilities.