InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it provides a significantly better overall performance and an improved database crash recovery in comparison to the default engine used by the MySQL RDBMS – MyISAM. InnoDB is preferred by numerous devs that run scalable applications, due to the fact that it works much more effectively with immense amounts of data, while it keeps the server load low. What’s more, it locks only a single database row if anything should be edited, whereas many other engines lock the entire table and thus require more time to execute multiple sequential tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for some reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest versions of Joomla are two examples of widespread PHP-driven applications that have switched to InnoDB.

InnoDB in Hosting

Every PHP-powered app that needs InnoDB will run impeccably on our avant-garde cloud hosting platform and the database storage engine is offered with all our hosting packages. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will use will be selected on the basis of the app’s specifications without having to change any setting in your hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you’ll be able to make the most of its full potential. We will create regular backups of your content, so in case you accidentally remove a MySQL database that you need or you overwrite a certain part of it, we will be able to restore your data the way it was just a couple of hours ago.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database through the Control Panel coming with all our semi-dedicated server plans and you begin installing an open-source script-powered application either manually or using our single-click application installer tool, the database storage engine will be picked automatically based on the prerequisites of the particular application. Since InnoDB is available on the cloud platform where your new account will be set up, it will be set as the default engine for any application that needs it without any manual action needed on your end at any moment. To prevent any risk of losing data if you update an application or if you remove a database accidentally, we will perform a backup of all your MySQL databases each and every day, so if anything goes wrong, we can restore your content.

InnoDB in VPS Servers

When you get a VPS server from us, you will be able to take advantage of our custom-built Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to activate any PHP-based application which needs InnoDB, as the MySQL storage engine is an integral part of the standard software bundle that will be pre-installed on the VPS server during its configuration. When you create a brand-new MySQL database via the hosting Control Panel, you’ll simply have to start installing an app – manually or using our application installer. InnoDB will be set as the default engine in case the application in question requires it, so you won’t need to do anything else in your account. Identically, if an application needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom Hepsia Control Panel come with a software bundle that is pre-activated and besides everything else, you’ll get the InnoDB storage engine, so you won’t need to install it manually in case you want to use PHP scripts that require it. All it takes to use such a script is to set up a new database and to start the installation process – once the script configuration wizard acquires access to the database in question and starts importing 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 script. You’ll also be able to run scripts that require the other popular MySQL engine, MyISAM, so you will not have to edit any settings on the dedicated server. This will enable you to install various scripts on one single physical machine and to use the latter to its fullest potential.