InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and an improved database crash recovery compared with the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by many web developers that write highly scalable software applications, since it works better with large amounts of data, while it keeps the server load low. Also, it uses row-level locking if any info should be modified, while many other engines lock the entire table and therefore require more time to carry out multiple sequential tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification cannot be completed for any reason, the operation is rolled back to prevent confusion or losing data. Magento and the newest versions of Joomla are two examples of widely used PHP script-powered web apps which have moved to InnoDB.

InnoDB in Website Hosting

While InnoDB is either not available or a paid upgrade with many web hosting providers, it is an essential part of the default set of services offered with our website hosting packages. If you wish to make use of a PHP-based software application that needs InnoDB particularly, in order to be installed and to function correctly, you will not have any difficulties because the storage engine is available on our custom-built cloud hosting platform. No matter if you create a brand-new MySQL database and activate an app manually or take advantage of our 1-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application requires it rather than MyISAM. In addition to the exceptional database failure recovery offered by InnoDB, we also carry out daily database backups, so we can swiftly restore any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you’ll be able to use all the options offered by this database engine with any PHP-driven application that needs it. It’s among the engines that are available on our cloud hosting platform, so the one that will be used depends on the prerequisites of the app in question. You won’t need to do anything manually to activate InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer tool. To avoid any risk, we’ll carry out regular backups of all your MySQL databases, so if anything goes wrong following an upgrade or if you delete some content by mistake, we will be able to get the database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If you obtain a VPS server from us, you will be able to take full advantage of our custom-built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will permit you to install any script-based software app that needs InnoDB, as this particular MySQL database engine is an integral part of the software package that will be pre-installed on your server during its creation. When you set up a brand-new database via the Control Panel, you will just need to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine if the application in question requires it, so you will not have to do anything else in your account. Similarly, if a certain application needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

InnoDB is included as standard with all dedicated servers ordered with the Hepsia hosting Control Panel. It’s part of the default software bundle that we install on all Hepsia-equipped dedicated servers, so once your physical machine is ready, you’ll be able to log in and to activate any kind of PHP script-powered web app that needs this MySQL database storage engine. When you set up a new database via the Control Panel, there won’t be any activated engine until you begin installing an app. As soon as the app installation wizard starts importing data into the database, the engine will be picked automatically depending on the requirements of the given app, so you can use both InnoDB and MyISAM without the need to select either one of them explicitly at any moment. Therefore, you can make use of an immense collection of apps for your sites.