InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it provides a better overall performance and an improved database crash recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is used by a lot of programmers that write scalable software applications, because it works more efficiently with huge data volumes, while it keeps the server load low. What’s more, it locks only one database row in case any information should be updated, while lots of other engines lock the entire database table and therefore require more time to accomplish multiple sequential tasks. Last, but not least, InnoDB obeys the "all-or-nothing" rule – if the entire data modification cannot be completed for whatever reason, the operation is rolled back to avoid scrambling or data loss. Magento and the newest releases of Joomla are two instances of widespread script-driven web applications that have shifted over to InnoDB.

InnoDB in Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosting companies, it’s included in the default set of features that we offer with our web hosting packages. In case you want to use a script-powered web app that needs InnoDB in particular, in order to be activated and to function properly, you will not encounter any difficulties since the storage engine is available on our in-house developed cloud web hosting platform. No matter if you create a brand-new database and activate an app manually or use our 1-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the respective application needs it rather than MyISAM. In addition to the excellent crash recovery offered by InnoDB, we also make regular database backups, so we can swiftly recover any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

InnoDB comes with all our Linux semi-dedicated servers by default, so the moment you purchase a new semi-dedicated account, you can move on and install any PHP-based application that requires this database storage engine. A number of engines are pre-installed on our cloud website hosting platform, so when you create a new MySQL database and start installing an application manually, or decide to take advantage of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be selected depending on the prerequisites of the given application. This will permit you to install and run InnoDB-specific apps without running into any obstacle and without having to edit any settings in your semi-dedicated account. To take no chances, we will always keep a 7-day-old backup of all your MySQL databases, so if you delete or change any content by accident, we can quickly recover it.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the default software package that will be pre-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 install and use any open-source script-based software application that needs InnoDB once your VPS is up and running, which takes no more than sixty minutes after the order procedure itself. Several engines are available, so anytime you create a MySQL database using the Hepsia hosting Control Panel, a specific engine will be picked once the app installation process starts and our system will automatically detect the engine that is required by the app in question. If you need MyISAM, for instance, you will not need to do anything different from installing the preferred application, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options which you can pick on the order form when you purchase a dedicated server from our company. As this is the most powerful kind of website hosting, it is very likely that you’ll run very popular Internet sites that will attract lots of people, and since InnoDB is one of the very best choices for such sites, we will activate it along with all the other software applications that are available with a Hepsia-equipped dedicated server. If you create a brand new database in your account, there won’t be any active MySQL storage engine until you start installing an open-source PHP script, whether manually through your Internet browser or using the automatic script installer that is integrated into the hosting Control Panel. The needed engine will be automatically detected and will be set for that database, so you can use scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without experiencing any obstacle.