InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it offers a much better overall performance and a faster database failure recovery compared with the default engine used by MySQL – MyISAM. InnoDB is endorsed by many web developers that write scalable software apps, since it works more efficiently with large data volumes, while it keeps the server processing load at a minimum. What’s more, it locks only one database row if any information should be modified, whereas lots of other engines lock the entire database table and hence need much more time to accomplish several consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed successfully for some reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the newest Joomla editions are two examples of famous PHP-based web applications which have switched over to InnoDB.

InnoDB in Shared Website Hosting

While InnoDB is either not offered or it is a paid upgrade with many other hosting providers, it is part of the default set of services that we offer with our shared website hosting plans. In case you wish to make use of an open-source script-driven application that needs InnoDB specifically, in order to be installed and to operate properly, you will not have any difficulties since the database engine is available on our custom-developed cloud website hosting platform. Regardless of whether you create a brand-new MySQL database and install an application manually or make use of our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the given app needs InnoDB rather than MyISAM. Besides the incredible database failure recovery that InnoDB is offering, we also keep regular database backups, so that we can quickly recover any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database from the Control Panel offered with each of our semi-dedicated server plans and you begin installing a script-driven application either manually or using our 1-click application installer, the storage engine for the MySQL database will be picked automatically depending on the particular app’s requirements. Since InnoDB is available on the cloud website hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for any application that needs it without the need for any manual action on your end at any time. To avoid any chance of losing information if you update an application or if you remove a database by accident, we will carry out backups of all your databases each and every day, so if something happens, we can rescue your content.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you’ll be able to pick one of the three hosting Control Panels that we offer – DirectAdmin, cPanel and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to add this MySQL database storage engine manually so as to be able to manage PHP script-based software applications that require it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the resources that you require in order to run very large Internet sites, it is pretty possible that you will use InnoDB. You’ll be able to use other engines as well, so if a specific application requires MyISAM rather than InnoDB, you won’t come across any problem while running it. The engine that will be used will be automatically detected when the app installation starts, so you won’t have to change any setting manually whatsoever.