InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and a faster crash recovery in comparison to the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by a lot of programmers that run highly scalable applications, because it works much more effectively with enormous amounts of data, while it keeps the server processing load low. What’s more, it locks only one database row if any info should be modified, while many other engines lock the entire database table and thus require more time to perform several consecutive tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – if the modification of the entire data cannot be completed for some reason, the action is rolled back to prevent confusion or the loss of data. Magento and the newest versions of Joomla are two examples of famous script-powered software applications that have shifted over to InnoDB.
InnoDB in Shared Web Hosting
While InnoDB is either not available or a paid upgrade with many hosting companies, it is an essential part of the standard set of features offered with our shared web hosting plans. In case you’d like to make use of a script-based web application that needs InnoDB particularly, in order to be installed and to operate correctly, you won’t need to deal with any difficulties since the InnoDB storage engine is available on our custom cloud platform. Regardless of whether you create a brand new database and install an app manually or use our 1-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the app requires it instead of MyISAM. Besides the excellent database failure recovery that InnoDB offers, we also keep daily database backups, so we can easily recover any database in your shared web hosting account.
InnoDB in Semi-dedicated Servers
All our semi-dedicated hosting plans come with InnoDB and you will be able to make use of all the features offered by this storage engine with any script-driven app that needs it. It’s one of the engines that we have on our cloud website hosting platform, so the one that will be used depends on the requirements of the particular application. You will not need to do anything manually to enable InnoDB, since it will be set as the default engine when you install an app – whether manually or using our single-click application installer. To be on the safe side, we’ll carry out regular database backups, so if something goes wrong after some update or if you erase some data by accident, we’ll be able to restore the database the way it was on any of the previous seven days.
InnoDB in VPS Servers
If you obtain a VPS server from our company, you will be able to take advantage of our custom-developed Hepsia Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will allow you to activate any script-powered web application which requires InnoDB, as this particular MySQL storage engine is an essential part of the default software bundle that will be pre-installed on the VPS server during its creation. When you create a brand new MySQL database via the Control Panel, you’ll just need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine if the app in question requires it, so you won’t need to do anything else in your account. Analogously, if a certain application requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Servers
InnoDB is included as standard with all dedicated web hosting plans ordered with the Hepsia Control Panel. It is included in the default software package that we install on all Hepsia-managed dedicated servers, so once your physical machine is set up, you’ll be able to sign in and to activate any kind of PHP script-based app that requires this MySQL storage engine. When you create a new MySQL database through the hosting Control Panel, there won’t be any activated engine till you begin installing an app. As soon as the app activation wizard begins entering data into the newly created database, the engine will be selected automatically based on the requirements of the respective app, so you can run both MyISAM and InnoDB without the need to select either of them explicitly at any time. Therefore, you can use a vast range of applications for your sites.