InnoDB is a MySQL database engine, which has been gaining popularity lately, because it provides a better overall performance and a faster crash recovery compared to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is endorsed by a lot of devs that run highly scalable web applications, because it works much more efficiently with enormous volumes of data, while it keeps the server load at a minimum. Moreover, it it locks only one row in the database if anything should be updated, while lots of other engines lock the entire table and therefore need much more time to perform several successive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification cannot be completed for any reason, the action is rolled back to avoid scrambling or losing data. Magento and the latest Joomla versions are two examples of widespread open-source script-based applications that have shifted over to InnoDB.
InnoDB in Cloud Web Hosting
While InnoDB is either not offered or it is a paid upgrade with many other web hosts, it is an essential part of the default set of features that we’re offering with our cloud web hosting plans. In case you would like to make use of a PHP-driven web app that requires InnoDB in particular, in order to be installed and to operate correctly, you will not face any problems because the MySQL database storage engine is available on our in-house developed cloud web hosting platform. No matter if you create a new database and activate an application manually or make use of our 1-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the given application requires InnoDB instead of MyISAM. Besides the exceptional database failure recovery offered by InnoDB, we also store regular database backups, so that we can swiftly restore any MySQL database in your shared web hosting account.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with each of our Linux semi-dedicated hosting by default, so as soon as you order a new semi-dedicated account, you can go ahead and install any open-source script-powered web app that needs this particular database engine. A few engines are pre-installed on our cloud platform, so when you create a new database and start installing an application manually, or decide to take advantage of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be chosen in accordance with the requirements of the particular app. This will allow you to activate and manage InnoDB-specific applications without having any problem and without the need to change any settings in your account. To avoid any risk, we will always have a one-week-old backup of all your MySQL databases, so if you erase or alter any content by mistake, we can quickly rescue it.
InnoDB in VPS Hosting
When you order a virtual private server from us, you’ll be able to use our custom-built Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will permit you to install any script-powered software application that requires InnoDB, as this particular MySQL database engine is included in the software bundle that will be installed on the Virtual Private Server during its creation. When you create a new database using the hosting Control Panel, you simply have to begin installing an app – manually or using our app installer tool. InnoDB will be set as the default engine on the condition that the app in question needs it, so you won’t have to do anything else in your VPS account. Equivalently, if a given application requires MyISAM, it will be automatically set as the default engine for this specific database.
InnoDB in Dedicated Web Hosting
InnoDB is available as standard with all Linux dedicated hosting services that are ordered with the Hepsia hosting Control Panel. It is included in the software package that will be installed on all Hepsia-managed servers, so as soon as your physical machine is up and running, you’ll be able to log in and to install any type of open-source script-driven application that requires this particular database engine. If you set up a new database through the Control Panel, there won’t be any active engine until you start installing an app. As soon as the app setup wizard begins inserting information into the database, the engine will be selected automatically depending on the requirements of the respective app, so you can use both MyISAM and InnoDB without selecting either of them explicitly at any time. Therefore, you can use a huge variety of apps for your sites.