InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it offers a significantly better overall performance and a faster database failure recovery in comparison to the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is used by many devs that create scalable web applications, because it works much better with enormous amounts of data, while it keeps the server processing load at a minimum. Also, it locks only a single row in the database in case anything should be updated, whereas many other engines lock the entire table and hence require more time to complete several successive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed successfully for whatever reason, the operation is rolled back to prevent confusion or data loss. Magento and the latest versions of Joomla are two examples of widespread PHP script-powered software applications that have switched over to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either not available or a paid upgrade with many other web hosting providers, it is an integral part of the standard set of features offered with our cloud hosting packages. In case you’d like to make use of a PHP-powered web application that requires InnoDB specifically, in order to be installed and to function properly, you won’t face any impediments as the storage engine is available on our in-house developed cloud web hosting platform. Regardless of whether you create a brand new MySQL database and install an application manually or take advantage of our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the app requires InnoDB rather than MyISAM. Besides the amazing database crash recovery offered by InnoDB, we also maintain regular database backups, so we can easily restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database from the Control Panel offered with each of our semi-dedicated server accounts and you start installing an open-source script-based application either manually or using our 1-click app installer, the database storage engine will be picked automatically on the basis of the given app’s requirements. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any app that needs it without the need for any manual intervention on your end at any point. To avoid any chance of losing data if you update an application or if you remove a database unintentionally, we’ll generate a backup of all your MySQL databases each day, so if anything goes wrong, we can rescue your data.

InnoDB in VPS Web Hosting

If our in-house developed Hepsia hosting Control Panel is chosen during the signup process for a new Linux VPS web hosting packages , InnoDB will be installed on the Virtual Private Server along with other needed 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 database storage engine. The default MySQL engine – MyISAM, will be activated as well. You can create a new database and begin installing the application manually or through our one-click installation tool. The system will recognize which engine the app in question requires and will assign it to the specific database, so the installation will continue flawlessly and the app can dump its content in that database. In this way, you can manage applications with different prerequisites with regard to the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers Hosting

Our Hepsia Control Panel is among the features which you can choose on the order form when you buy a dedicated server from us. As this is the most powerful kind of hosting, it’s quite likely that you’ll run very popular Internet sites that will attract many visitors, and since InnoDB is one of the very best options for such Internet sites, we’ll enable it together with all the other software apps that come with a Hepsia-managed dedicated server. If you create a brand-new database in your dedicated account, there won’t be any activated database engine until you start installing a script, whether manually via your Internet browser or using the automatic scripts installation tool that is integrated into the Control Panel. The needed engine will be automatically detected and will be set for that database, so you can run scripts that require InnoDB, as well as ones that need the default MySQL engine, MyISAM, without any difficulty.