InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it offers a much better overall performance and an improved database crash recovery compared to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is preferred by many programmers that build highly scalable web apps, because it works much more efficiently with large data volumes, while it keeps the server load at a minimum. Additionally, it uses row-level locking if any information should be updated, whereas lots of other engines lock the entire database table and thus require much more time to accomplish multiple consecutive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for some reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the newest releases of Joomla are two instances of widespread script-based web applications that have switched to InnoDB.

InnoDB in Shared Web Hosting

InnoDB is available with all our shared web hosting services by default, not upon request or as a paid upgrade, so you can activate and manage any PHP script-based application that requires the InnoDB database storage engine without encountering any difficulty once you order your shared 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 one-click installer or create the MySQL database and set up the application manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll perform regular MySQL database backups, so you can rest assured that you will never lose any data if you erase a database accidentally or you overwrite some important info – you simply have to inform us and we’ll restore the database back to normal.

InnoDB in Semi-dedicated Hosting

You can run a PHP-driven application that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are set up on our cutting-edge cloud platform where the MySQL database storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our single-click application installer. Either way, the required engine will be selected automatically once the installation of the app starts, so you will not need to change anything manually, irrespective of whether the application requires InnoDB or the more widely used MyISAM. In addition, we’ll always be able to retrieve any of your MySQL databases in case you remove one by accident, as we perform several backups every day, each of which is preserved for one whole week.

InnoDB in VPS

When you obtain a virtual private server from our company, you’ll be able to make use of our in-house built Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to manage any PHP script-driven software application that needs InnoDB, as this particular MySQL database storage engine is included in the standard software bundle that will be pre-installed on the VPS server during its setup. When you create a brand new database through the hosting Control Panel, you’ll just have to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine on the condition that the application in question needs it, so you will not have to do anything else in your account. Equivalently, if an application needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Hosting

All dedicated hosting ordered with our custom-developed Hepsia Control Panel come with a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB database engine, so you will not need to install it manually if you want to activate PHP scripts that require it. All it takes to run such a script is to set up a new MySQL database and to start the setup process – once the installer 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 needed by the particular script. You will also be able to run scripts that require the other popular MySQL engine – MyISAM, so you won’t have to modify any settings on the dedicated server. This will permit you to install different scripts on a single physical server and to use the latter to its maximum potential.