InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and an improved database failure recovery compared to the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is preferred by numerous devs that run highly scalable web apps, as it works better with immense volumes of data, while it keeps the server processing load low. Furthermore, it locks only one database row if any info should be modified, whereas many other engines lock the entire table and hence require more time to accomplish several sequential tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification process cannot be completed for whatever reason, the operation is rolled back to prevent confusion or data loss. Magento and the newest Joomla editions are two instances of widespread PHP script-based web apps that have switched to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with many web hosting providers, it is part of the default set of services that we offer with our shared hosting packages. If you wish to use a script-based web app that requires InnoDB particularly, in order to be activated and to operate correctly, you won’t encounter any obstacles because the InnoDB storage engine is available on our custom cloud web hosting platform. No matter if you create a new MySQL database and install an application manually or use our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the application requires InnoDB instead of MyISAM. In addition to the excellent crash recovery that InnoDB offers, we also make regular backups of all databases, so we can quickly recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Hosting

InnoDB comes with all our Linux semi-dedicated hosting by default, so the moment you obtain a new account, you can go on and install any PHP-driven web application that requires this particular MySQL database storage engine. A number of engines are pre-installed on our cloud web hosting platform, so when you create a new MySQL database and begin installing an app manually, or decide to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be selected on the basis of the prerequisites of the application in question. This will allow you to install and run InnoDB-specific apps without experiencing any impediment and without having to modify any settings in your semi-dedicated account. To be on the safe side, we will always have a 7-day-old backup of all your MySQL databases, so if you remove or change any content by accident, we can quickly retrieve it.

InnoDB in VPS Hosting

In case our in-house built Hepsia Control Panel is chosen during the registration process for a new Linux VPS hosting packages , InnoDB will be activated on the VPS server along with other necessary pieces of software, so you will not need to do anything if you choose to use PHP script-powered apps that require this MySQL storage engine. MyISAM – the default MySQL engine, will be activated too. You can create a new MySQL database and start installing the application manually or through our single-click installer tool. The system will automatically recognize the engine that the particular application requires and will set it for the specific database, so the installation will continue impeccably and the app can enter its data into that database. Therefore, you can install applications with various prerequisites about the MySQL engine without making any changes on your VPS.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting ordered with our custom-developed Hepsia hosting Control Panel include a software package that is pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to add it manually in case you need to activate open-source scripts that require it. All it takes to activate such a script is to set up a new MySQL database and to initiate the setup – once the script configuration wizard gains access to the database and begins entering content into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You will also be able to install scripts that need the other widely used MySQL engine – MyISAM, so you won’t have to update any settings on the server. This will permit you to run different scripts on one single physical server and to use the latter to its full potential.