InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it provides a significantly better overall performance and an improved crash recovery in comparison with the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is used by plenty of developers that run scalable apps, due to the fact that it works more effectively with enormous volumes of data, while it keeps the server processing load low. Additionally, it locks only a single row in the database if any info should be edited, whereas lots of other engines lock the entire database table and hence need more time to handle multiple successive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed for some reason, the operation is rolled back to avoid scrambling or the loss of data. Magento and the latest versions of Joomla are two instances of widely used script-driven software applications that have shifted over to InnoDB.

InnoDB in Shared Website Hosting

InnoDB is available with all our Linux shared website hosting plans by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any PHP-driven web application that requires the database storage engine without encountering any impediment once you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a given database during the app activation, regardless of whether you make use of our single-click installation tool or create the database and activate the app manually, provided that the app requires it instead of the more famous MyISAM engine. We will create daily backups of all your MySQL databases, so you can be certain that you won’t ever lose any content if you erase a database by mistake or you overwrite some important information – you simply need to contact us and we’ll restore your data back to normal.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you’ll be able to take advantage of all the options offered by this MySQL storage engine with any script-driven software application that needs it. InnoDB is one of the engines that we have on our cloud platform, so the one that will be used depends on the prerequisites of the given app. You won’t have to do anything manually to activate InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our one-click app installer tool. To be on the safe side, we’ll generate regular backups of all your databases, so if anything goes wrong following some update or if you erase some data by mistake, we will be able to get your database back to the way it was on any of the past 7 days.

InnoDB in VPS Servers

In case our custom-built Hepsia hosting Control Panel is chosen during the signup process for a new VPS hosting plans , InnoDB will be installed on the server along with other necessary pieces of software, so you won’t have to do anything if you choose to install open-source script-powered software applications that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated too. You can set up a brand new MySQL database and start the app installation manually or using our one-click installation tool. The system will detect the engine that the particular app requires and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the app can dump its data in that database. Therefore, you can run apps with various requirements concerning the MySQL engine without having to make any changes on your server.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our in-house built Hepsia Control Panel come with a software package that’s pre-installed and among everything else, you will get the InnoDB storage engine, so you will not need to add it manually if you wish to run PHP scripts that need it. All it takes to use such a script is to create a new MySQL database and to start the installation process – once the script configuration wizard acquires access to the database in question and begins inserting content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You’ll also be able to install scripts that require the other popular MySQL engine – MyISAM, so you will not have to modify any settings on the dedicated server. This will permit you to run a variety of scripts on a single physical machine and to use the latter to its fullest capacity.