InnoDB is a MySQL database engine, which has been gaining popularity lately, because it provides a better overall performance and an improved database crash recovery compared with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is used by lots of developers that run highly scalable software applications, as it works much more effectively with enormous volumes of data, while it keeps the server load low. Also, it locks only a single row in the database if anything should be modified, whereas lots of other engines lock the entire table and hence require more time to perform multiple sequential tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for any reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest versions of Joomla are two instances of popular PHP script-based apps which have switched to InnoDB.

InnoDB in Cloud Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosting providers, it is an integral part of the standard set of features that we offer with our cloud web hosting packages. If you’d like to make use of a PHP script-driven app that requires InnoDB specifically, in order to be activated and to operate properly, you won’t need to deal with any difficulties as the InnoDB storage engine is available on our custom-built cloud platform. Irrespective of whether you create a brand-new database and install an app manually or use our one-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the application requires it instead of MyISAM. Besides the incredible database failure recovery that InnoDB offers, we also perform regular database backups, so we can quickly restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database from the hosting Control Panel coming with all our semi-dedicated server packages and you begin installing a script-driven application either manually or using our one-click application installer, the storage engine for the MySQL database will be picked automatically depending on the prerequisites of the app in question. Since InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for any app that requires it without any manual action required on your end at any moment. To avoid any risk of losing data if you update an application or if you remove a database by mistake, we will perform backups of all your MySQL databases every day, so if anything happens, we can rescue your content.

InnoDB in VPS Servers

If our in-house built Hepsia hosting Control Panel is selected during the registration process for a new VPS hosting plans , InnoDB will be installed on the server along with other essential software, so you will not need to do anything if you decide to install PHP script-based software applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed too. You can set up a brand-new database and begin installing the app manually or through our one-click installer. The system will detect which engine the particular app requires and will assign it to the specific database, so the installation will continue impeccably and the application can enter its content into that database. In this way, you can activate apps with different requirements with regard to the MySQL engine without making any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

InnoDB is included by default with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It is an integral part of the standard software package that will be installed on all Hepsia-managed servers, so once your machine is up and running, you will be able to sign in and to install any open-source script-powered software app that needs this particular MySQL database storage engine. When you create a new MySQL database via the hosting Control Panel, there won’t be any active engine till you start installing an app. As soon as the app setup wizard starts inserting information into the database, the engine will be set automatically based on the prerequisites of the specific application, so you can use both InnoDB and MyISAM without having to select either of them explicitly at any moment. Thus, you can use a wide collection of applications for your sites.