InnoDB is a MySQL database 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 that is used by the MySQL database management system – MyISAM. InnoDB is preferred by lots of devs that create highly scalable software applications, as it works more efficiently with huge amounts of data, while it keeps the server load at a minimum. What’s more, it uses row-level locking if any information should be edited, while many other engines lock the entire database table and thus require more time to process multiple consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed successfully for any reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest versions of Joomla are two instances of widely used PHP script-based apps which have switched over to InnoDB.

InnoDB in Web Hosting

Every script-driven app that needs InnoDB will function impeccably on our cutting-edge cloud website hosting platform and the storage engine is offered with all our web hosting plans. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s prerequisites without the need to change any setting in your account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to make the most of its full potential. We’ll store regular backups of your content, so if you unintentionally remove a MySQL database that is important to you or you overwrite specific parts of it, we will be able to restore your database the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting come with InnoDB and you’ll be able to get the most out of all the features of this MySQL storage engine with any PHP script-driven web application that requires it. It is one of the engines that are available on our cloud platform, so the one that will be used depends on the given app’s prerequisites. You won’t have to do anything manually to activate InnoDB, since it will be set as the default engine when you install an app – whether manually or using our one-click app installer tool. To avoid any risk, we will make regular backups of all your databases, so if anything goes wrong after an upgrade or if you remove some content unintentionally, we will be able to get your database back to the way it was on any of the past 7 days.

InnoDB in VPS

If you purchase a virtual private server from our company, you will be able to take advantage of our custom-developed Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will allow you to install any PHP script-powered application which requires InnoDB, as this particular database storage engine is part of the standard software package that will be installed on the Virtual Private Server during its creation. When you create a new MySQL database via the Control Panel, you will just need to start installing an app – manually or using our app installer. InnoDB will be set as the default engine given that the app in question needs it, so you will not need to do anything else in your account. In the same manner, if an app requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Hosting

If you buy a new dedicated server, you’ll be able to pick one of the 3 hosting Control Panels that we’re offering – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to add this storage engine manually to be able to manage script-based web apps that need it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the resources that you need in order to manage large-size websites, it is pretty possible that you will use InnoDB. You will be able to use other engines as well, so if a given app requires MyISAM rather than InnoDB, you will not experience any complication while running it. The engine that will be used will be automatically recognized as soon as the app installation starts, so you won’t have to alter any setting manually at any moment.