InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it offers a better overall performance and an improved database crash recovery compared with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is endorsed by plenty of programmers that build scalable software applications, since it works much better with immense data volumes, while it keeps the server processing load low. Moreover, it it locks only one row in the database in case any information should be updated, whereas many other engines lock the entire database table and therefore need more time to process multiple successive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – if the modification of the entire data cannot be completed successfully for any reason, the operation is rolled back to avoid scrambling or losing data. Magento and the newest Joomla™ editions are two instances of popular PHP-driven applications that have switched to InnoDB.

InnoDB in Web Hosting

Any PHP script-based application that needs InnoDB will run flawlessly on our advanced cloud hosting platform and the database engine is offered with all our web hosting plans. Each time you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected based on the app’s requirements without having to edit any setting in your web hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you will be able to take advantage of its full potential. We will maintain regular content backups, so if you accidentally remove a database that’s important to you or you overwrite some part of it, we will be able to restore everything the way it was only a few hours ago.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database from the Control Panel coming with each of our semi-dedicated server plans and you begin installing a PHP-based app either manually or using our single-click app installer, the database storage engine will be picked automatically based on the prerequisites of the particular application. As InnoDB is present on the cloud website hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any app that requires it without any manual intervention needed on your end at any moment. To prevent any chance of losing info if you update an app or if you remove a database by mistake, we will perform a backup of all your databases each and every day, so if something goes wrong, we can rescue your data.

InnoDB in Dedicated Servers

InnoDB is available as standard with all dedicated web hosting plans that are ordered with the Hepsia Control Panel. It’s included in the default software package that will be installed on all Hepsia-managed dedicated servers, so as soon as your physical machine is set up, you will be able to log in and to install any PHP script-based web app that needs this storage engine. When you create a new MySQL database via the hosting Control Panel, there won’t be any active engine till you start installing an application. Once the app installation wizard begins entering content into the database, the engine will be chosen automatically based on the requirements of the respective application, so you can use both MyISAM and InnoDB without having to select either one of them explicitly at any moment. In this way, you can make use of a large collection of applications for your websites.