InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it offers a much better overall performance and an improved database crash recovery compared with the default engine that’s used by MySQL – MyISAM. InnoDB is endorsed by plenty of developers that build scalable apps, as it works much more effectively with enormous volumes of data, while it keeps the server load low. Furthermore, it it locks only one row in the database if any information should be edited, while lots of other engines lock the entire table and therefore require much more time to fulfill several sequential tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed for some reason, the action is rolled back to avoid scrambling or data loss. Magento and the latest releases of Joomla™ are two examples of famous PHP-driven apps which have switched to InnoDB.

InnoDB in Hosting

While InnoDB is either not offered or it is a paid upgrade with other hosting providers, it is part of the standard set of services that we are offering with our hosting plans. In case you’d like to make use of an open-source script-driven web app that requires InnoDB in particular, in order to be installed and to function correctly, you won’t encounter any obstacles since the storage engine is available on our custom cloud Internet hosting platform. No matter if you set up a new MySQL database and install an app manually or use our single-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the particular application needs InnoDB rather than MyISAM. In addition to the excellent crash recovery that InnoDB is offering, we also keep daily database backups, so that we can easily recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

You can use a PHP script-based web app that needs InnoDB with any of our semi-dedicated server packages, because all the accounts are set up on our innovative cloud web hosting platform where the database engine is installed. A new MySQL database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you take advantage of our single-click app installer tool. Either way, the needed engine will be selected automatically as soon as the installation of the application starts, so you won’t have to configure anything manually, regardless of whether the app requires InnoDB or the more commonly used MyISAM. Furthermore, we will always be able to retrieve any of your databases if you accidentally delete one, as we make a few backups every day, each of which is preserved for 7 days.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia Control Panel, the InnoDB database engine will be an essential part of the default software bundle that will be pre-installed on your Virtual Private Server before we hand it over to you. You will not have to configure anything manually and you’ll be able to enable and run any PHP script-based app that requires InnoDB when your VPS server is up and running, which takes no more than 60 minutes after the order process itself. A few engines are offered, so whenever you create a MySQL database via the Hepsia Control Panel, a particular engine will be picked once the app activation process commences and our system will automatically detect the engine that is required by the app in question. If you need to use MyISAM, for example, you will not need to do anything different than installing the chosen app, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

All dedicated service that are ordered with our in-house built Hepsia hosting Control Panel come with a software package that is pre-activated and besides everything else, you will get the InnoDB database storage engine, so you will not need to activate it manually if you’d like to use scripts that require it. All it takes to run such a script is to set up a new MySQL database and to initiate the setup – once the script configuration wizard accesses the database in question and starts inserting content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You’ll also be able to use scripts that need MyISAM, the other very popular MySQL engine, so you won’t have to change any settings on the server. This will enable you to run various scripts on a single machine and to use the latter to its full potential.