InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and a faster database crash recovery in comparison to the default engine used by MySQL – MyISAM. InnoDB is used by a lot of developers that run scalable web apps, since it works more effectively with immense volumes of data, while it keeps the server load low. Also, it it locks only one row in the database if anything should be edited, whereas lots of other engines lock the entire database table and hence need more time to fulfill multiple consecutive tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed for some reason, the action is rolled back to prevent confusion or losing data. Magento and the newest Joomla releases are two instances of popular PHP-driven software apps that have moved to InnoDB.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any PHP-powered web app which requires the database engine without having any difficulty as soon as you order your shared web hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation process, irrespective of whether you take advantage of our 1-click installer or create the MySQL database and activate the app manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We’ll store daily backups of all your MySQL databases, so you can be certain that you won’t ever lose any data in case you delete a database unintentionally or you overwrite some crucial information – you will just need to touch base with us and we’ll restore your data the way it was.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database through the Control Panel provided with each of our semi-dedicated server plans and you start installing a script-based web application either manually or using our 1-click app installer tool, the storage engine for the database will be selected automatically based on the particular app’s requirements. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each app that requires it without any manual action needed on your end at any point. To prevent any risk of losing data if you update an application or if you remove a database accidentally, we will perform backups of all your databases each and every day, so if anything happens, we can rescue your content.

InnoDB in VPS

If you order a virtual private server with our Hepsia Control Panel, the InnoDB database engine will be part of the default software pack that will be installed on your Virtual Private Server before we hand it over to you. You will not have to configure anything manually and you will be able to enable and use any open-source script-driven software app that needs InnoDB once your VPS server is up and running, which takes no more than one hour after the order procedure itself. A few engines are offered, so whenever you create a MySQL database through the Hepsia hosting Control Panel, a particular engine will be picked when the app installation commences and our system will detect which engine is required by the app in question. In case you need MyISAM, for example, you won’t have to do anything different than installing the chosen application, whether manually or using our app installer.

InnoDB in Dedicated Hosting

When you order a new dedicated server, you will be able to pick one of the 3 Control Panels offered by our company – cPanel, Hepsia and DirectAdmin. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to install this MySQL storage engine manually in order to be able to use open-source script-driven software apps that require it. InnoDB is used by scalable applications and since a dedicated server will offer you all the system resources that you require in order to manage large-size sites, it is pretty possible that you’ll resort to InnoDB. You will be able to use other engines as well, so in case a particular app needs MyISAM instead of InnoDB, you will not have to deal with any complication while running it. The engine that will be used will be automatically recognized once the app installation process begins, so you will not need to edit any settings manually at any time.