InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it provides a better overall performance and an improved database failure recovery in comparison with the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by plenty of devs that build scalable applications, because it works much better with huge volumes of data, while it keeps the server load low. Also, it uses row-level locking if anything should be edited, while lots of other engines lock the entire table and thus need more time to fulfill multiple consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification cannot be completed for whatever reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the latest Joomla editions are two instances of popular open-source script-driven web apps that have switched to InnoDB.

InnoDB in Shared Hosting

Any open-source script-based software app that requires InnoDB will run impeccably on our advanced cloud website hosting platform and the MySQL database engine comes with all our shared hosting packages. Each time you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s prerequisites without the need to modify any setting in your hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to make the most of its full capacity. We will store regular backups of your content, so in case you unintentionally delete a database that’s important to you or you overwrite some part of it, we’ll be able to restore your data the way it was just several hours ago.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our Linux semi-dedicated hosting plans by default, so once you buy a new semi-dedicated account, you can go on and activate any open-source script-powered software app that requires the storage engine. A number of engines are pre-installed on our cloud website hosting platform, so when you create a brand-new MySQL database and start installing an app manually, or decide to make use of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be selected based on the requirements of the specific app. This will permit you to install and manage InnoDB-specific applications without any obstacle and without the need to update any settings in your account. To avoid any risk, we’ll always have a one-week-old backup of all your MySQL databases, so if you erase or change any content by accident, we can quickly recover it.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be included in the standard software package that will be pre-installed on your Virtual Private Server before we hand it over to you. You won’t have to activate anything manually and you will be able to install and manage any PHP-powered application that needs InnoDB once your Virtual Private Server is set up, which takes no more than 1 hour after the order process itself. A couple of engines are offered, so anytime you create a MySQL database through the Hepsia Control Panel, a specific engine will be activated once the app activation begins and our system will recognize which engine is required by the app in question. In case you need MyISAM, for instance, you won’t need to do anything different than installing the application of your preference, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

All Linux dedicated servers that are ordered with our custom-built Hepsia hosting Control Panel include a software bundle that is pre-installed and among everything else, you’ll get the InnoDB storage engine, so you won’t need to add it manually in case you need to use PHP scripts that require it. All it takes to use such a script is to create a new MySQL database and to initiate the installation – once the script configuration wizard obtains 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 script. You’ll also be able to use scripts that need the other popular MySQL engine – MyISAM, so you won’t need to change any settings on the server. This will permit you to install different scripts on a single machine and to use it to its fullest capabilities.