InnoDB is a MySQL database engine, which has been gaining in popularity lately, as it provides a significantly better overall performance and an improved database failure recovery in comparison with the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by many developers that run scalable web applications, since it works much more effectively with enormous amounts of data, while it keeps the server load low. Furthermore, it locks only a single database row in case any info should be updated, whereas lots of other engines lock the entire database table and therefore require more time to process several successive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for any reason, the operation is rolled back to prevent scrambling or losing data. Magento and the newest versions of Joomla are two instances of widely used PHP script-based software applications that have switched to InnoDB.

InnoDB in Shared Hosting

Any open-source script-driven web application that requires InnoDB will function impeccably on our innovative cloud hosting platform and the MySQL database storage engine comes with all our shared hosting packages. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will use will be selected in accordance with the app’s prerequisites without the need to edit any setting in your account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to make the most of its full capacity. We will carry out daily backups of your content, so if you accidentally erase a MySQL database that you need or you overwrite specific parts of it, we’ll be able to restore your database the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Servers

InnoDB is offered with all our Linux semi-dedicated plans by default, so once you create a new semi-dedicated account, you can move on and install any PHP-driven software application that needs the MySQL database storage engine. A couple of engines are pre-installed on our cloud web hosting platform, so when you create a brand-new MySQL database and start installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer, the engine for the database will be set on the basis of the prerequisites of the given app. This will permit you to install and manage InnoDB-specific apps without any problems and without updating any settings in your semi-dedicated account. To take no chances, we will always keep a one-week-old backup of all your databases, so if you delete or alter any content by mistake, we can easily recover it.

InnoDB in VPS Servers

If you obtain a VPS server from us, you will be able to take advantage of our custom-built Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to manage any open-source script-driven software application which requires InnoDB, as this MySQL storage engine is included in the default software bundle that will be pre-installed on your VPS server during its configuration. When you create a new database via the Control Panel, you will simply need to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine if the application in question needs it, so you won’t have to do anything else in your account. Equivalently, if an application needs MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the features that you can pick on the order form when you purchase a dedicated server from our company. Since this is the most powerful type of hosting, it is very likely that you’ll run highly popular sites that will draw many visitors, and since InnoDB is among the best options for such sites, we will install it together with all the other software applications that are offered with a Hepsia-managed dedicated server. When you set up a brand-new MySQL database in your dedicated server account, there won’t be any active database engine until you begin installing an open-source PHP script, whether manually via your browser or using the automatic script installer that is integrated into the Control Panel. The required engine will be detected automatically and will be set for the database in question, so you can make use of scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without having any difficulty.