InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it offers a 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 preferred by lots of web developers that create highly scalable software apps, since it works much better with enormous volumes of data, while it keeps the server load at a minimum. Furthermore, it uses row-level locking in case any info should be edited, whereas lots of other engines lock the entire database table and hence need more time to accomplish multiple consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification cannot be completed for some reason, the action is rolled back to prevent confusion or data loss. Magento and the newest editions of Joomla™ are two instances of popular script-driven software applications that have moved to InnoDB.

InnoDB in Shared Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many other hosting service providers, it’s included in the standard set of features offered with our shared website hosting packages. In case you wish to use an open-source script-based app that needs InnoDB particularly, in order to be installed and to perform correctly, you will not need to deal with any difficulties as the storage engine is available on our custom cloud hosting platform. No matter if you set up a new database and activate an application manually or use our one-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the specific app needs InnoDB rather than MyISAM. In addition to the excellent database crash recovery that InnoDB is offering, we also keep daily backups of all databases, so we can easily recover any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

If you set up a new MySQL database through the hosting Control Panel provided with all our semi-dedicated server plans and you begin installing a PHP-powered web application either manually or using our one-click app installer tool, the storage engine for the MySQL database will be selected automatically depending on the particular app’s requirements. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for each app that needs it without any manual intervention needed on your end at any moment. To prevent any risk of losing information if you update an application or if you remove a database by accident, we’ll carry out a backup of all your databases each day, so if something happens, we can recover your data.

InnoDB in Dedicated Servers Hosting

When you purchase a new dedicated server, you will be able to select one of the three Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t need to enable this database storage engine manually so as to be able to run PHP script-based software applications that require it. InnoDB is used by scalable apps and since a dedicated server will offer you all the system resources that you require to run large-size websites, it’s pretty likely that you will use InnoDB. You will be able to use other engines as well, so if a certain app requires MyISAM rather than InnoDB, you will not encounter any complication while using it. The engine that will be used will be recognized automatically as soon as the app installation commences, so you will not have to edit any settings manually at any time.