InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it offers a significantly better overall performance and a faster database failure recovery compared with the default engine used by the MySQL relational database management system – MyISAM. InnoDB is preferred by plenty of devs that create scalable software applications, since it works more effectively with large volumes of data, while it keeps the server processing load low. Additionally, it uses row-level locking if any info should be modified, while lots of other engines lock the entire database table and thus need much more time to carry out several consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification process cannot be completed for whatever reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the latest editions of Joomla are two instances of widely used PHP-driven software applications that have switched to InnoDB.

InnoDB in Web Hosting

InnoDB is available with all our web hosting by default, not upon request or as a paid upgrade, so you can install and manage any PHP script-based web app which requires the MySQL database storage engine without having to deal with any problem as soon as you order your shared hosting account. InnoDB will be selected automatically as the default engine for a given database during the app activation process, irrespective of whether you take advantage of our single-click installation tool or create the MySQL database and activate the application manually, as long as the application requires it instead of the more popular MyISAM engine. We’ll create regular database backups, so you can be certain that you’ll never lose any data in case you delete a database accidentally or you overwrite some important information – you’ll just need to alert us and we’ll restore the database back to normal.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database from the hosting Control Panel included with all our semi-dedicated server plans and you begin installing an open-source script-driven app either manually or using our 1-click app installer tool, the database storage engine will be selected automatically based on the prerequisites of the given app. Since InnoDB is available on the cloud platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that needs it without any manual intervention needed on your end at any moment. To avoid any risk of losing information if you update an app or if you erase a database by mistake, we’ll perform a backup of all your MySQL databases each day, so if anything goes wrong, we can rescue your data.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia Control Panel, the InnoDB database engine will be included in the default software package that will be installed on your Virtual Private Server before we hand it over to you. You will not need to activate anything manually and you will be able to install and manage any open-source script-based web app that needs InnoDB when your VPS server is ready, which takes no more than 60 minutes after the order process itself. A number of engines are available, so anytime you set up a database through the Hepsia hosting Control Panel, a particular engine will be selected once the app activation process commences and our system will recognize which engine is required by the application in question. In case you need MyISAM, for example, you won’t have to do anything different from installing the app of your preference, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-built Hepsia hosting Control Panel come with a software package that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t need to add it manually if you would like to run scripts that require it. All it takes to activate such a script is to create a new MySQL database and to start the setup – once the script setup wizard receives access to the database and begins entering data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You’ll also be able to use scripts that require the other widely used MySQL engine – MyISAM, so you won’t need to update any settings on the server. This will permit you to activate a variety of scripts on a single physical server and to use the latter to its maximum capabilities.