InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it offers a significantly better overall performance and an improved database failure recovery in comparison with the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by lots of programmers that create scalable web applications, due to the fact that it works more efficiently with huge volumes of data, while it keeps the server load at a minimum. In addition, it uses row-level locking in case any info should be modified, whereas lots of other engines lock the entire table and thus need more time to accomplish multiple successive tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the entire data modification cannot be completed for any reason, the action is rolled back to prevent confusion or losing data. Magento and the newest versions of Joomla are two instances of popular open-source script-driven applications which have switched to InnoDB.

InnoDB in Shared Hosting

InnoDB is available with all our shared hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and run any open-source script-based app that needs the database storage engine without any problems once you open your shared account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app installation process, irrespective of whether you make use of our 1-click installation tool or create the MySQL database and set up the application manually, provided that the app requires it instead of the more famous MyISAM engine. We will generate regular MySQL database backups, so you can be certain that you won’t ever lose any data if you delete a database accidentally or you overwrite some vital information – you just need to notify us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our semi-dedicated servers by default, so as soon as you purchase a new account, you can move on and install any open-source script-driven application that needs this database engine. A few engines are pre-installed on our cloud website hosting platform, so when you create a new MySQL database and begin installing an application manually, or opt to take advantage of the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be selected depending on the respective app’s prerequisites. This will allow you to activate and manage InnoDB-specific applications without encountering any impediment and without having to modify any settings in your account. To avoid any risk, we will always have a 1-week-old backup of all your databases, so if you delete or alter any content by accident, we can easily restore it.

InnoDB in VPS Servers

In case our custom-developed Hepsia hosting Control Panel is selected during the registration process for your new VPS servers , InnoDB will be activated on the Virtual Private Server together with other needed pieces of software, so you will not need to do anything if you decide to manage PHP script-driven web applications that require this MySQL database engine. The default MySQL engine, MyISAM, will be activated too. You can set up a brand new MySQL database and begin installing the application manually or using our single-click installer. The system will recognize which engine the particular app requires and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can insert its content into that database. Therefore, you can manage apps with various prerequisites with regard to the MySQL engine without making any changes on your server.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated servers ordered with the Hepsia Control Panel. It is included in the standard software bundle that we install on all Hepsia-equipped servers, so as soon as your machine is set up, you will be able to log in and to install any type of PHP script-driven software application that needs this database storage engine. When you create a new database via the Control Panel, there won’t be any activated engine till you start installing an app. Once the app activation wizard begins entering data into the database, the engine will be selected automatically in accordance with the prerequisites of the particular application, so you can run both MyISAM and InnoDB without the need to select either one of them specifically at any time. In this way, you can make use of a huge collection of applications for your websites.