InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it offers a much better overall performance and a faster database failure recovery in comparison to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is preferred by many developers that create highly scalable web apps, since it works better with enormous volumes of data, while it keeps the server load low. Also, it locks only a single row in the database if any information should be modified, while lots of other engines lock the entire database table and therefore require more time to complete several successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – if the entire data modification process cannot be completed for some reason, the action is rolled back to avoid confusion or losing data. Magento and the newest versions of Joomla are two examples of popular PHP-based web apps which have switched to InnoDB.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting providers, it is part of the default set of services offered with our hosting packages. If you want to make use of a PHP-powered web app that needs InnoDB specifically, in order to be activated and to work properly, you won’t experience any problems since the MySQL storage engine is available on our custom cloud Internet hosting platform. Regardless of whether you create a new MySQL database and activate an application manually or use our 1-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the given application requires InnoDB instead of MyISAM. In addition to the outstanding database failure recovery offered by InnoDB, we also carry out regular database backups, so that we can easily recover any MySQL database in your shared account.

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 script-driven software application either manually or using our single-click application installer tool, the database storage engine will be picked automatically depending on the given app’s requirements. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that requires it without any manual action required on your end at any point. To avoid any chance of losing info if you update an app or if you delete a database by accident, we will generate backups of all your MySQL databases each and every day, so if something goes wrong, we can rescue your content.

InnoDB in VPS Servers

If you purchase a VPS server from our company, you will be able to take advantage of our custom-built Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will permit you to run any script-based application which requires InnoDB, as the MySQL database storage engine is part of the standard software package that will be pre-installed on the server during its setup. When you create a brand new database through the hosting Control Panel, you will simply have to start installing an app – manually or using our app installer. InnoDB will be set as the default engine in case the application in question needs it, so you won’t have to do anything else in your VPS account. Similarly, if a certain app requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated web hosting plans that are ordered with the Hepsia Control Panel. It’s included in the software bundle that we install on all Hepsia-managed servers, so as soon as your machine is ready, you will be able to sign in and to activate a various PHP-powered web application that needs this MySQL database engine. If you create a new database via the Control Panel, there won’t be any activated engine till you start installing an application. As soon as the app configuration wizard begins importing information into the database, the engine will be chosen automatically depending on the prerequisites of the application in question, so you can run both MyISAM and InnoDB without the need to select either one of them specifically at any point. In this way, you can use a wide collection of apps for your Internet sites.