InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it offers a significantly better overall performance and a faster database failure recovery in comparison to the default engine used by MySQL – MyISAM. InnoDB is endorsed by a lot of web developers that build highly scalable web applications, due to the fact that it works much more efficiently with large volumes of data, while it keeps the server load low. Moreover, it uses row-level locking if anything should be updated, while lots of other engines lock the entire table and thus need more time to accomplish several consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for whatever reason, the action is rolled back to prevent confusion or data loss. Magento and the newest Joomla versions are two examples of famous open-source script-powered software platforms which have moved to InnoDB.
InnoDB in Cloud Website Hosting
InnoDB is available with all our Linux cloud website hosting packages by default, not as a paid upgrade or upon request, so you’ll be able to install and run any PHP-driven web application that requires the MySQL database engine without any difficulty once you open your account. InnoDB will be pre-selected as the default engine for a specific database during the app installation, regardless of whether you use our single-click installation tool or create the MySQL database and activate the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We will generate regular backups of all your databases, so you can be certain that you won’t ever lose any data in case you erase a database accidentally or you overwrite some key information – you simply have to alert us and we will restore your database back to normal.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated packages come with InnoDB and you can use all the features offered by this MySQL database engine with any script-powered web application that requires it. InnoDB is one of the engines that are available on our cloud hosting platform, so the one that will be picked depends on the given app’s requirements. You won’t have to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our 1-click application installer tool. To avoid any risk, we will carry out regular backups of all your MySQL databases, so if anything goes wrong following some update or if you delete some data unintentionally, we’ll be able to get your database back to the way it was on any of the previous 7 days.
InnoDB in Dedicated Web Hosting
All Linux dedicated servers hosting packages that are ordered with our custom-built Hepsia hosting Control Panel include a software package that is pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you will not need to activate it manually if you want to activate open-source PHP scripts that need it. All it takes to use such a script is to set up a new database and to begin the installation process – once the script configuration wizard gets access to the database and begins importing data 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 will also be able to activate scripts that need MyISAM – the other widely used MySQL engine, so you will not need to modify any settings on the server. This will allow you to install various scripts on a single server and to use the latter to its full capabilities.