InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it provides a much better overall performance and a faster database crash recovery in comparison to the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is used by many devs that create scalable apps, since it works more effectively with huge volumes of data, while it keeps the server load low. What’s more, it locks only a single row in the database in case any info should be updated, while many other engines lock the entire table and hence need more time to execute several successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed for whatever reason, the action is rolled back to avoid confusion or data loss. Magento and the newest editions of Joomla are two instances of famous PHP-powered applications that have shifted over to InnoDB.

InnoDB in Shared Web Hosting

InnoDB is offered with all our Linux shared web hosting services by default, not as a paid upgrade or upon request, so you can install and run any script-powered software application that needs the InnoDB storage engine without having to deal with any impediment as soon as you activate your account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app installation, irrespective of whether you take advantage of our one-click installation tool or create the database and install the app manually, provided that the application requires it instead of the more popular MyISAM engine. We will perform regular backups of all your databases, so you can rest assured that you won’t ever lose any data in case you erase a database accidentally or you overwrite some important info – you will simply need to notify us and we’ll restore the database the way it was.

InnoDB in Semi-dedicated Hosting

All our Linux semi-dedicated hosting support InnoDB and you can use all the options offered by this storage engine with any script-powered app that needs it. It’s one of the engines that we have on our cloud hosting platform, so the one that will be used depends on the requirements of the specific application. You won’t have to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an application – whether manually or using our one-click app installer tool. To be on the safe side, we’ll store daily MySQL database backups, so if something goes wrong following an upgrade or if you delete some data accidentally, we’ll be able to get the database back to the way it was on any of the past seven days.

InnoDB in VPS Web Hosting

If you buy a virtual private server from us, you’ll be able to take full advantage of our custom-developed Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to activate any script-driven app which needs InnoDB, as this particular database storage engine is an integral part of the software package that will be installed on the Virtual Private Server during its creation. When you create a brand new MySQL database via the Control Panel, you will just have to start installing an application – manually or using our application installer tool. InnoDB will be set as the default engine if the app in question needs it, so you will not need to do anything else in your account. Identically, if a given app requires MyISAM, it will be automatically set as the default engine for this concrete database.

InnoDB in Dedicated Servers Hosting

Our Hepsia hosting Control Panel is among the options that you can pick on the order page when you buy a dedicated server from us. Since this is the most powerful type of web hosting, it’s rather likely that you’ll run highly popular sites that will attract plenty of visitors, and since InnoDB is among the best options for such websites, we’ll install it along with all the other software apps that are available with a Hepsia-equipped server. When you set up a brand-new MySQL database in your dedicated server account, there won’t be any active MySQL database storage engine till you start installing a PHP script, whether manually through your Internet browser or using the automatic script installer tool that is integrated into the hosting Control Panel. The needed engine will be recognized and will be assigned to the database in question, so you can install scripts that need InnoDB, as well as ones that require MyISAM – the default MySQL engine, without encountering any impediment.