InnoDB is a very popular database engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has a lot of advantages that have made it the preferred engine for a lot of PHP script-based web applications, such as Magento and Joomla™, which have shifted over to InnoDB permanently. For instance, adding large data volumes will be faster with InnoDB, since it locks only a single row to perform a given operation, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the information is tackled. In simpler words, adding new or modifying existing data will either be fully completed, or will be canceled and the operation will be rolled back if any issue appears in the meantime, thus the content that remains in the database won’t be damaged.

InnoDB in Cloud Hosting

Every PHP script-powered app that requires InnoDB will run impeccably on our leading-edge cloud web hosting platform and the MySQL storage engine is available with all our cloud hosting plans. Every 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 having to change any setting in your hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to get the most out of its full potential. We’ll store regular backups of your content, so if you unintentionally erase a database that you need or you overwrite a specific part of it, we will be able to restore your content the way it was only a couple of hours ago.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting packages include InnoDB and you can take advantage of all the options offered by this database storage engine with any script-powered web application that requires it. It is among the engines that are available on our cloud website hosting platform, so the one that will be used depends on the requirements of the particular application. You won’t have to do anything manually to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our single-click app installer. To be on the safe side, we’ll make daily backups of all your databases, so if anything goes wrong after an upgrade or if you erase some content unintentionally, we’ll be able to restore your database the way it was on any of the previous seven days.

InnoDB in VPS

If you buy a virtual private server from our company, you’ll be able to use our in-house developed Hepsia Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will permit you to manage any script-powered web app which needs InnoDB, as the database 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 database via the hosting Control Panel, you simply have to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine as long as the app in question needs it, so you will not need to do anything else in your VPS account. Equivalently, if an application needs MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Hosting

All Linux dedicated servers hosting packages ordered with our custom-built Hepsia Control Panel come with a software bundle that is pre-installed and among everything else, you’ll get the InnoDB storage engine, so you will not need to install it manually if you want to use open-source PHP scripts that need it. All it takes to install such a script is to set up a new database and to begin the installation process – once the installation wizard receives access to the database and begins dumping data in it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You will also be able to activate scripts that require MyISAM, the other popular MySQL engine, so you won’t have to update any settings on the dedicated server. This will enable you to install various scripts on one single server and to use it to its fullest potential.