InnoDB is a MySQL storage engine, which has been gaining in popularity lately, because it offers a much better overall performance and an improved database crash recovery in comparison to the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by lots of developers that build scalable web applications, because it works more effectively with enormous volumes of data, while it keeps the server load at a minimum. Additionally, it locks only one database row in case any information should be edited, whereas many other engines lock the entire table and thus need much more time to carry out multiple successive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for any reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest releases of Joomla are two instances of widely used script-powered web apps which have moved to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other web hosts, it’s an integral part of the default set of features that we’re offering with our cloud hosting packages. In case you would like to use a PHP-based web application that requires InnoDB specifically, in order to be activated and to work properly, you won’t need to deal with any difficulties because the MySQL storage engine is available on our in-house developed cloud platform. Irrespective of whether you create a new MySQL database and activate an app manually or make use of our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the particular app requires it instead of MyISAM. Besides the incredible database crash recovery that InnoDB is offering, we also perform daily backups of all databases, so we can quickly restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database through the Control Panel provided with each of our semi-dedicated server packages and you start installing a script-based software application either manually or using our one-click application installer tool, the database storage engine will be selected automatically on the basis of the prerequisites of the particular app. Since InnoDB is present on the cloud web hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each app that needs it without any manual intervention needed on your end at any moment. To avoid any risk of losing data if you update an app or if you erase a database unintentionally, we’ll generate a backup of all your databases each and every day, so if anything goes wrong, we can rescue your content.

InnoDB in VPS

If you select a virtual private server with our Hepsia Control Panel, the InnoDB database storage engine will be included in the standard software bundle that will be installed on your VPS server before we hand it over to you. You won’t have to configure anything manually and you’ll be able to enable and use any PHP-powered software application that needs InnoDB once your Virtual Private Server is ready, which takes no more than 60 minutes after the order submission itself. A number of engines are offered, so whenever you set up a database using the Hepsia hosting Control Panel, a specific engine will be activated when the app activation commences and our system will detect which engine is required by the application in question. If you need to use MyISAM, for instance, you won’t have to do anything different than installing the desired application, whether manually or using our application installer tool.

InnoDB in Dedicated Hosting

All dedicated hosting ordered with our in-house built 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 will not have to add it manually in case you would like to activate open-source scripts that need it. All it takes to run such a script is to create a new MySQL database and to begin the setup – as soon as the script configuration wizard receives access to the database in question and starts importing data 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 will also be able to use scripts that require the other popular MySQL engine, MyISAM, so you will not have to modify any settings on the server. This will allow you to use various scripts on one single machine and to use it to its maximum capabilities.