InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it provides a better overall performance and a faster crash recovery in comparison to the default engine that is used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by many web developers that build scalable software applications, due to the fact that it works much more effectively with large data volumes, while it keeps the server processing load at a minimum. Moreover, it it locks only one row in the database if any information should be modified, whereas lots of other engines lock the entire database table and thus require more time to accomplish multiple sequential tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for some reason, the action is rolled back to prevent confusion or data loss. Magento and the latest releases of Joomla are two instances of widely used open-source script-driven applications which have switched to InnoDB.

InnoDB in Hosting

InnoDB is available with all our hosting service by default, not upon request or as a paid upgrade, so you will be able to activate and run any script-based software app which needs the InnoDB database storage engine without encountering any impediment once you open your account. InnoDB will be pre-selected as the default engine for a specific database during the app activation process, no matter if you make use of our one-click installation tool or create the MySQL database and install the app manually, on the condition that the application requires it instead of the more popular MyISAM engine. We’ll maintain daily MySQL database backups, so you can be certain that you won’t ever lose any content in case you erase a database by mistake or you overwrite some essential information – you will just need to touch base with us and we’ll restore everything back to normal.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you will be able to make use of all the features offered by this MySQL database engine with any PHP script-driven software application that needs it. InnoDB is one of the engines that are available on our cloud website hosting platform, so the one that will be used depends on the prerequisites of the given app. You will not have to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our single-click app installer. To be on the safe side, we’ll generate daily database backups, so if something goes wrong following some update or if you erase some data by accident, we’ll be able to get your database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

In case our custom-built Hepsia Control Panel is picked during the registration process for a new VPS servers , InnoDB will be installed on the Virtual Private Server together with other essential software, so you will not need to do anything if you choose to install script-powered web applications that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated too. You can set up a new MySQL database and start the app installation procedure manually or through our 1-click installation tool. The system will detect the engine that the particular app requires and will set it for the specific MySQL database, so the installation will continue flawlessly and the application can enter its content into that database. Therefore, you can run apps with different requirements concerning the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Servers

All Linux dedicated service that are ordered with our in-house built Hepsia hosting Control Panel include a software package that’s pre-installed and among everything else, you’ll get the InnoDB database engine, so you won’t have to install it manually if you would like to run PHP scripts that need it. All it takes to use such a script is to create a new MySQL database and to initiate the setup process – once the script installation wizard accesses the database in question and begins importing data 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 particular script. You’ll also be able to activate scripts that require the other very popular MySQL engine – MyISAM, so you won’t need to modify any settings on the server. This will permit you to use different scripts on one single physical machine and to use it to its full potential.