InnoDB is a MySQL database 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 that is used by the MySQL RDBMS – MyISAM. InnoDB is used by a lot of programmers that run highly scalable applications, since it works much more efficiently with immense data volumes, while it keeps the server processing load at a minimum. Moreover, it locks only a single database row if any info should be modified, whereas lots of other engines lock the entire database table and thus require much more time to execute multiple successive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed for any reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest editions of Joomla are two instances of widely used PHP-powered software applications which have switched over to InnoDB.

InnoDB in Shared Hosting

You’ll be able to make use of any script-based software application that needs InnoDB in case you’ve got a shared plan with our company, as the MySQL database storage engine is present on our innovative cloud hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is needed. You can install apps that need the MyISAM engine without any difficulty as well and, once again, the engine will be selected automatically, so you won’t have to modify any setting manually at any time. What’s more, we’ll also create regular backups of all the databases that you’ve got in your shared account, so if you delete or overwrite something, we can swiftly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans come with InnoDB and you’ll be able to take advantage of all the features offered by this database storage engine with any open-source script-driven app that requires it. It is one of the engines that are available on our cloud website hosting platform, so the one that will be picked depends on the requirements of the specific app. You won’t have to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our 1-click application installer. To avoid any risk, we will carry out daily backups of all your MySQL databases, so if anything goes wrong after an upgrade or if you remove some content by accident, we’ll be able to restore the database the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If you buy a VPS server from us, you will be able to take advantage of our custom Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to manage any PHP script-powered software application that requires InnoDB, as this database engine is an essential part of the standard software bundle that will be pre-installed on your VPS server during its creation. When you set up a new MySQL database via the hosting Control Panel, you simply have to begin installing an application – manually or using our application installer tool. InnoDB will be set as the default engine on the condition that the app in question needs it, so you will not have to do anything else in your VPS account. Analogously, if a given app requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom-built Hepsia Control Panel include a software bundle that is pre-installed and besides everything else, you will get the InnoDB storage engine, so you will not need to activate it manually if you would like to activate scripts that need it. All it takes to use such a script is to create a new database and to begin the setup – as soon as the script configuration wizard gets access to the database and begins inserting content 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’ll also be able to use scripts that need the other very popular MySQL engine – MyISAM, so you will not need to configure any settings on the server. This will permit you to run various scripts on one single physical machine and to use the latter to its maximum potential.