InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a much better overall performance and a faster database crash recovery compared to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is used by numerous devs that create scalable software apps, as it works much more effectively with enormous amounts of data, while it keeps the server processing load low. What’s more, it it locks only one row in the database if any info should be updated, while many other engines lock the entire database table and therefore require much more time to carry out multiple sequential tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the entire data modification cannot be completed successfully for some reason, the action is rolled back to avoid confusion or data loss. Magento and the latest Joomla™ editions are two examples of widespread PHP-powered software platforms that have switched to InnoDB.

InnoDB in Shared Web Hosting

InnoDB is offered with all our shared web hosting by default, not upon request or as a paid upgrade, so you will be able to activate and run any script-driven web app that needs the storage engine without any problem once you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation, no matter if you use our one-click installation tool or create the MySQL database and set up the application manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We will generate regular database backups, so you can rest assured that you won’t ever lose any data if you erase a database unintentionally or you overwrite some crucial info – you will just have to notify us and we’ll restore your database back to normal.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database from the hosting Control Panel offered with all our semi-dedicated server plans and you start installing an open-source script-powered web app either manually or using our one-click application installer tool, the database storage engine will be selected automatically based on the requirements of the particular application. Since InnoDB is available on the cloud website hosting platform where your new account will be created, it will be set as the default engine for each app that requires it without any manual intervention required on your end at any time. To avoid any chance of losing info if you update an application or if you delete a database accidentally, we will generate backups of all your databases each day, so if anything happens, we can restore your data.

InnoDB in VPS Servers

When you order a VPS server from our company, you will be able to make use of our custom-developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will allow you to run any script-based application that needs InnoDB, as the storage engine is an integral part of the standard software bundle that will be pre-installed on your Virtual Private Server during its creation. When you create a brand new MySQL database via the Control Panel, you will simply need to start installing an app – manually or using our app installer. InnoDB will be set as the default engine if the application in question requires it, so you won’t have to do anything else in your VPS account. Analogously, if a given app needs MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers

InnoDB is included as standard with all dedicated servers ordered with the Hepsia hosting Control Panel. It is included in the standard software package that will be pre-installed on all Hepsia-managed servers, so once your machine is assembled, you’ll be able to sign in and to install any type of PHP script-powered web app that requires this particular storage engine. When you create a new MySQL database via the Control Panel, there won’t be any active engine till you begin installing an application. Once the app configuration wizard begins dumping content in the database, the engine will be set automatically depending on the requirements of the application in question, so you can use both InnoDB and MyISAM without the need to select either of them explicitly at any moment. Therefore, you can make use of an extensive collection of applications for your sites.