InnoDB is a MySQL database engine, which has been gaining in popularity lately, because it provides a significantly better overall performance and an improved database crash recovery in comparison with the default engine that is used by MySQL – MyISAM. InnoDB is preferred by a lot of devs that create highly scalable applications, as it works more effectively with immense volumes of data, while it keeps the server load low. What’s more, it locks only one database row in case any information should be modified, whereas many other engines lock the entire database table and hence need much more time to carry out multiple consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for some reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest releases of Joomla™ are two examples of widely used PHP script-powered web applications which have shifted over to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other hosting companies, it’s an essential part of the default set of services offered with our shared hosting plans. If you’d like to make use of a PHP-based software app that requires InnoDB in particular, in order to be installed and to operate correctly, you won’t come across any obstacles since the MySQL database storage engine is available on our custom-built cloud Internet hosting platform. No matter if you create a brand new MySQL database and activate an app manually or take advantage of our 1-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the given app needs InnoDB rather than MyISAM. Besides the exceptional database crash recovery that InnoDB is offering, we also keep daily backups of all databases, so that we can quickly recover any database in your shared account.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom Hepsia hosting Control Panel include a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB database storage engine, so you will not need to install it manually if you would like to activate PHP scripts that need it. All it takes to use such a script is to set up a new database and to start the installation process – as soon as the script setup wizard receives access to the database in question and begins dumping content in it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You’ll also be able to activate scripts that need MyISAM – the other widely used MySQL engine, so you won’t need to modify any settings on the server. This will permit you to run various scripts on one single physical server and to use the latter to its full capacity.