InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it provides a significantly better overall performance and an improved database failure recovery in comparison with the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by lots of web developers that create scalable web applications, as it works more efficiently with large volumes of data, while it keeps the server processing load at a minimum. Furthermore, it uses row-level locking if any information should be updated, whereas many other engines lock the entire database table and hence need much more time to perform multiple successive tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed successfully for any reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the newest Joomla editions are two instances of widely used PHP-based software apps which have switched to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either not available or a paid upgrade with many other web hosting providers, it is an integral part of the default set of services that we’re offering with our cloud hosting plans. If you’d like to make use of an open-source script-powered application that requires InnoDB specifically, in order to be installed and to work properly, you will not need to deal with any problems as the InnoDB storage engine is available on our custom-developed cloud hosting platform. No matter if you create a brand new MySQL database and install an application manually or take advantage of our 1-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the specific app requires it instead of MyISAM. Besides the exceptional crash recovery that InnoDB offers, we also generate daily database backups, so we can quickly restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you can take advantage of all the options offered by this database engine with any open-source script-driven app that needs it. It is one of the engines that are available on our cloud platform, so the one that will be used depends on the requirements of the application in question. You will not need to do anything manually to enable InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our one-click application installer. To avoid any risk, we’ll keep daily backups of all your MySQL databases, so if anything goes wrong following an upgrade or if you delete some content accidentally, we’ll be able to restore your database the way it was on any of the previous seven days.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom Hepsia hosting Control Panel include a software package that is pre-installed and besides everything else, you’ll get the InnoDB database engine, so you won’t have to activate it manually in case you need to use open-source scripts that require it. All it takes to activate such a script is to create a new database and to start the installation process – as soon as the script installation wizard obtains access to the database and begins importing data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to use scripts that need MyISAM, the other popular MySQL engine, so you will not have to modify any settings on the server. This will enable you to install a variety of scripts on one single server and to use the latter to its maximum capacity.