InnoDB is a MySQL 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 MySQL – MyISAM. InnoDB is endorsed by numerous programmers that run highly scalable software applications, due to the fact that it works much more efficiently with enormous data volumes, while it keeps the server processing load low. In addition, it locks only one database row in case any information should be edited, whereas lots of other engines lock the entire database table and thus need more time to handle multiple successive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for any reason, the operation is rolled back to prevent confusion or data loss. Magento and the latest Joomla™ versions are two instances of popular PHP script-driven software platforms that have moved to InnoDB.
InnoDB in Cloud Website Hosting
InnoDB is available with all our cloud website hosting plans by default, not upon request or as a paid upgrade, so you’ll be able to install and manage any PHP script-driven software application that requires the database storage engine without any problems as soon as you open your shared account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app activation process, irrespective of whether you use our one-click installer or create the database and install the app manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We will carry out daily database backups, so you can rest assured that you will never lose any content in case you erase a database accidentally or you overwrite some crucial information – you’ll simply have to touch base with us and we will restore your content back to normal.
InnoDB in Dedicated Servers
All dedicated web hosting plans ordered with our custom-built Hepsia Control Panel come with a software bundle that is pre-installed and besides everything else, you will get the InnoDB database engine, so you won’t need to install it manually in case you need to run PHP scripts that require it. All it takes to use such a script is to set up a new MySQL database and to begin the setup – as soon as the installer wizard gains access to the database in question and begins inserting content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You’ll also be able to activate scripts that need MyISAM – the other very popular MySQL engine, so you will not have to modify any settings on the server. This will permit you to use various scripts on one single physical server and to use it to its fullest potential.