InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it offers a better overall performance and an improved database crash recovery in comparison with the default engine that is used by MySQL – MyISAM. InnoDB is preferred by many programmers that build highly scalable web apps, since it works much more efficiently with huge volumes of data, while it keeps the server load low. In addition, it locks only a single database row if anything should be edited, while many other engines lock the entire table and therefore need more time to accomplish multiple sequential tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification cannot be completed successfully for some reason, the action is rolled back to prevent scrambling or losing data. Magento and the newest editions of Joomla™ are two instances of widely used open-source script-powered apps which have switched to InnoDB.

InnoDB in Web Hosting

InnoDB is offered with all our web hosting by default, not upon request or as a paid upgrade, so you can install and manage any script-powered application which requires the InnoDB database storage engine without encountering any difficulty as soon as you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation process, irrespective of whether you make use of our 1-click installer or create the database and activate the app manually, on the condition that the application requires InnoDB instead of the more famous MyISAM engine. We will keep daily MySQL database backups, so you can be certain that you won’t ever lose any data if you delete a database by accident or you overwrite some essential information – you just need to notify us and we will restore your content the way it was.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database through the Control Panel coming with all our semi-dedicated server packages and you start installing an open-source script-based web application either manually or using our 1-click app installer tool, the storage engine for the database will be picked automatically based on the particular app’s requirements. Since InnoDB is present on the cloud web hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each app that requires it without the need for any manual action on your end at any time. To prevent any chance of losing information if you update an app or if you delete a database by accident, we will carry out backups of all your databases each day, so if anything goes wrong, we can restore your data.

InnoDB in VPS Web Hosting

If you buy a virtual private server from our company, you’ll be able to take advantage of our in-house built Hepsia Control Panel to manage your content. A Hepsia-managed VPS will allow you to activate any script-driven web application that needs InnoDB, as this particular storage engine is an integral part of the standard software bundle that will be pre-installed on your VPS server during its creation. When you set up a brand-new database through the hosting Control Panel, you’ll just need to start installing an app – manually or using our app installer. InnoDB will be set as the default engine given that the application in question requires it, so you won’t need to do anything else in your VPS account. Identically, if a given app needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers Hosting

If you order a new dedicated server, you will be able to select any of the three Control Panels that we offer – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to install this storage engine manually to be able to manage open-source script-based software applications that require it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the resources that you need to manage large-scale Internet sites, it is very possible that you will resort to InnoDB. You’ll be able to use other engines too, so in case a given app needs MyISAM rather than InnoDB, you won’t run into any difficulty while running it. The engine that will be used will be detected automatically as soon as the app installation process commences, so you will not need to update any settings manually at any point.