InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a significantly better overall performance and a faster database crash recovery in comparison to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is used by a lot of devs that build highly scalable web applications, due to the fact that it works much better with huge amounts of data, while it keeps the server load at a minimum. In addition, it it locks only one row in the database in case any information should be modified, while lots of other engines lock the entire table and thus need much more time to perform several sequential tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification cannot be completed successfully for whatever reason, the action is rolled back to prevent scrambling or data loss. Magento and the newest Joomla releases are two examples of famous script-driven applications that have moved to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either not offered or it is a paid upgrade with many other hosting companies, it is an integral part of the default set of services that we are offering with our shared hosting plans. In case you would like to use a PHP-based web app that requires InnoDB specifically, in order to be activated and to work properly, you will not need to deal with any obstacles because the storage engine is available on our custom-built cloud website hosting platform. Regardless of whether you set up a brand new MySQL database and activate an app manually or make use of our one-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the given application needs InnoDB instead of MyISAM. In addition to the exceptional database crash recovery that InnoDB is offering, we also store daily database backups, so we can swiftly recover any database in your shared web hosting account.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting come with InnoDB and you will be able to take advantage of all the features of this MySQL storage engine with any script-based web application that requires it. It is one of the engines that are available on our cloud hosting platform, so the one that will be picked depends on the requirements of the application in question. You will not have to do anything manually to activate InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our one-click app installer tool. To avoid any risk, we’ll keep daily backups of all your databases, so if something goes wrong after an update or if you delete some data unintentionally, we’ll be able to restore your database the way it was on any of the past seven days.
InnoDB in Dedicated Servers Hosting
InnoDB is available as standard with all Linux dedicated servers hosting packages that are ordered with the Hepsia hosting Control Panel. It’s an essential part of the standard software package that we install on all Hepsia-equipped servers, so as soon as your machine is assembled, you will be able to sign in and to install a various PHP-based software application that requires this particular MySQL storage engine. When you create a new database via the Control Panel, there won’t be any active engine till you begin installing an app. Once the app setup wizard starts dumping information in the newly created database, the engine will be selected automatically on the basis of the prerequisites of the particular app, so you can run both InnoDB and MyISAM without having to select either one specifically at any time. In this way, you can use an extensive range of applications for your websites.