InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it provides a better overall performance and an improved crash recovery in comparison to the default engine that is used by MySQL – MyISAM. InnoDB is used by lots of web developers that write highly scalable web applications, as it works much more effectively with immense volumes of data, while it keeps the server processing load low. Also, it locks only a single row in the database if anything should be modified, while many other engines lock the entire table and therefore need more time to accomplish several sequential tasks. Last, but not least, InnoDB abides by a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for some reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla editions are two examples of widespread PHP-powered web applications which have switched over to InnoDB.

InnoDB in Cloud Web Hosting

InnoDB is available with all our Linux cloud web hosting plans by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any open-source script-based app which requires the InnoDB database engine without the need to deal with any complication as soon as you activate your shared account. InnoDB will be selected automatically as the default engine for a particular database during the app installation process, irrespective of whether you use our single-click installer or create the database and install the application manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We will keep regular 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 accidentally or you overwrite some key information – you’ll just need to alert us and we will restore your content the way it was.

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 accounts and you begin installing a PHP script-driven web app either manually or using our single-click application installer, the MySQL database storage engine will be picked automatically depending on the prerequisites of the specific app. Since InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for any app that needs it without the need for any manual intervention on your end at any moment. To avoid any risk of losing information if you update an app or if you remove a database by mistake, we will perform a backup of all your databases every day, so if something goes wrong, we can recover your content.

InnoDB in VPS Servers

All Linux VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you’ll be able to use any PHP script-powered web app that requires this MySQL database engine without activating anything manually. You can select Hepsia on the VPS order form and your new Virtual Private Server will be ready within one hour, so you can sign in and begin creating your sites straight away. Once you create a brand-new MySQL database and start the app installation process, our system will set the engine for that MySQL database automatically. Thus, you can install various apps at the same time without updating anything on the Virtual Private Server. You can create a WordPress-based online blog that uses MyISAM – the default MySQL engine, and a Magento-driven e-commerce site that uses InnoDB, for instance.

InnoDB in Dedicated Servers

When you order a new dedicated server, you will be able to pick any of the three Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to activate this storage engine manually so as to be able to use script-powered software apps that require it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the server resources that you need to manage large-size sites, it’s very possible that you will use InnoDB. You will be able to use other engines as well, so if a specific app requires MyISAM instead of InnoDB, you will not have to deal with any impediment while using it. The engine that will be used will be detected automatically as soon as the app installation commences, so you will not have to tweak any setting manually at any time.