InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and an improved crash recovery compared to the default engine used by the MySQL DBMS – MyISAM. InnoDB is used by a lot of web developers that create scalable web applications, since it works much better with enormous amounts of data, while it keeps the server load at a minimum. In addition, it locks only a single database row in case any information should be updated, while lots of other engines lock the entire table and thus need more time to complete multiple consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for whatever reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest Joomla™ releases are two examples of popular PHP-powered web applications which have shifted over to InnoDB.
InnoDB in Cloud Website Hosting
InnoDB is offered with all our cloud website hosting plans by default, not upon request or as a paid upgrade, so you will be able to activate and manage any PHP script-based software application that requires the InnoDB database engine without any difficulty as soon as you activate your account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app activation, regardless of whether you make use of our one-click installer or create the MySQL database and install the app manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We will keep daily MySQL database backups, so you can rest assured that you’ll never lose any data if you erase a database by mistake or you overwrite some essential information – you just need to inform us and we’ll restore everything the way it was.
InnoDB in Dedicated Servers
All dedicated web hosting plans ordered with our custom-built Hepsia Control Panel include a software package that’s pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you won’t need to install it manually in case you wish to activate scripts that require it. All it takes to install such a script is to create a new MySQL database and to initiate the installation process – once the installation wizard receives access to the database in question and starts entering 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 run scripts that need the other widely used MySQL engine, MyISAM, so you won’t need to configure any settings on the server. This will permit you to run a variety of scripts on one single server and to use the latter to its fullest capabilities.