InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and a faster database failure recovery compared with the default engine used by the MySQL database management system – MyISAM. InnoDB is used by a lot of developers that run scalable apps, because it works more effectively with enormous volumes of data, while it keeps the server load low. Moreover, 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 thus require much more time to accomplish multiple consecutive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed successfully for any reason, the operation is rolled back to prevent scrambling or data loss. Magento and the latest versions of Joomla are two instances of famous PHP script-powered software applications which have shifted over to InnoDB.

InnoDB in Web Hosting

You will be able to install any script-based app that needs InnoDB in case you have a web hosting plan with our company, as the MySQL storage engine is present on our avant-garde cloud web hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can run applications that need the MyISAM engine without having to deal with any impediment as well and, once again, the engine will be pre-selected, so you won’t need to update any setting manually at any time. Furthermore, we’ll also perform regular backups of all the MySQL databases that you’ve got in the shared web hosting account, so in case you delete or overwrite something, we can easily get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans include InnoDB and you can use all the features of this MySQL storage engine with any PHP-driven software app that requires it. It’s one of the engines that are available on our cloud web hosting platform, so the one that will be selected depends on the given app’s requirements. You will not have to do anything manually in order to activate InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our single-click app installer tool. To avoid any risk, we’ll create regular backups of all your MySQL databases, so if something goes wrong following an upgrade or if you delete some content by mistake, we’ll be able to restore the database the way it was on any of the previous 7 days.

InnoDB in VPS Servers

If you buy a VPS server from us, you will be able to use our in-house built Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will allow you to manage any PHP-driven software app which needs InnoDB, as this particular MySQL database engine is included in the software package that will be installed on your server during its setup. When you set up a new database via 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 application in question requires it, so you will not need to do anything else in your VPS account. Likewise, 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 included by default with all dedicated web hosting plans ordered with the Hepsia Control Panel. It’s included in the standard software package that will be pre-installed on all Hepsia-equipped servers, so once your physical machine is set up, you will be able to sign in and to activate any type of script-based web app that needs this particular MySQL database storage engine. When you set up a new MySQL database via the Control Panel, there won’t be any active engine until you begin installing an app. As soon as the app setup wizard begins importing data into the database, the engine will be chosen automatically depending on the prerequisites of the app in question, so you can use both MyISAM and InnoDB without selecting either one specifically at any moment. In this way, you can make use of a broad selection of apps for your Internet sites.