InnoDB is a MySQL database storage engine, which has been gaining popularity lately, because it offers a significantly better overall performance and an improved database failure recovery in comparison to the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is endorsed by lots of programmers that create scalable software apps, because it works much more effectively with immense data volumes, while it keeps the server processing load low. Moreover, it it locks only one row in the database in case anything should be modified, while lots of other engines lock the entire table and hence require much more time to handle several successive tasks. Last, but not least, InnoDB obeys 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 the loss of data. Magento and the latest Joomla™ editions are two instances of widely used PHP script-based apps that have moved to InnoDB.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosting providers, it is part of the default set of features offered with our hosting plans. In case you’d like to use a script-based software application that needs InnoDB particularly, in order to be activated and to work properly, you won’t face any problems as the MySQL storage engine is available on our in-house built cloud Internet hosting platform. Irrespective of whether you create a brand-new MySQL database and install an application manually or make use of our single-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the specific app requires it instead of MyISAM. Besides the amazing database crash recovery that InnoDB offers, we also make daily database backups, so that we can easily recover any MySQL database in your shared web hosting account.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the features that you can pick on the order form when you buy a dedicated server from our company. As this is the most powerful type of hosting, it’s very likely that you’ll run highly popular sites that will attract lots of individuals, and since InnoDB is among the best choices for such websites, we’ll activate it along with all the other software applications that are offered with a Hepsia-equipped server. If you create a brand-new MySQL database in your dedicated account, there won’t be any activated MySQL storage engine until you start installing a PHP script, whether manually through your Internet browser or using the automatic script installer tool that is available in the Control Panel. The needed engine will be recognized and will be assigned to that database, so you can use scripts that require InnoDB, as well as ones that need MyISAM, the default MySQL engine, without running into any obstacle.