InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it provides a significantly better overall performance and a faster database failure recovery compared with the default engine used by MySQL – MyISAM. InnoDB is preferred by many devs that run scalable software applications, because it works much more effectively with immense volumes of data, while it keeps the server processing load low. Additionally, it locks only a single row in the database if any information should be modified, whereas many other engines lock the entire database table and thus need much more time to carry out several successive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification cannot be completed successfully for any reason, the operation is rolled back to avoid confusion or losing data. Magento and the latest Joomla versions are two examples of popular PHP script-powered software applications which have shifted over 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 script-powered application that requires the database storage engine without any problem once you order your account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app installation, irrespective of whether you use our single-click installer or create the database and activate the application manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We will make daily backups of all your databases, so you can rest assured that you won’t ever lose any data if you delete a database by accident or you overwrite some key information – you will simply need to alert us and we will restore everything back to normal.

InnoDB in Semi-dedicated Hosting

InnoDB is included with each of our semi-dedicated packages by default, so as soon as you get a new account, you can move on and install any PHP script-driven software app that needs the MySQL database storage engine. Several engines are pre-installed on our cloud platform, so when you create a brand-new database and begin installing an app manually, or opt to make use of the Hepsia Control Panel-integrated application installer, the engine for the database will be picked depending on the prerequisites of the app in question. This will permit you to install and manage InnoDB-specific apps without needing to cope with any obstacle and without the need to configure any settings in your semi-dedicated account. To be on the safe side, we will always keep a 1-week-old backup of all your MySQL databases, so if you erase or alter any content unintentionally, we can easily recover it.

InnoDB in VPS Hosting

If our custom-developed Hepsia hosting Control Panel is selected during the signup process for your new Linux VPS hosting packages , InnoDB will be activated on the server along with other needed pieces of software, so you won’t need to do anything if you decide to install PHP-driven software applications that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated too. You can create a new MySQL database and begin installing the application manually or through our 1-click installer. The system will recognize which engine the app in question requires and will set it for the specific MySQL database, so the installation will proceed impeccably and the application can enter its data into that database. In this way, you can run applications with different prerequisites with regard to the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Web Hosting

Our Hepsia hosting Control Panel is one of the features which you can pick on the server configuration page when you buy a dedicated server from us. As this is the most powerful type of hosting, it is rather likely that you’ll run popular sites that will attract plenty of people, and since InnoDB is one of the best options for such sites, we will enable it together with all the other software apps that come with a Hepsia-managed server. If you set up a new database in your dedicated server account, there won’t be any activated MySQL storage engine till you start installing an open-source PHP script, whether manually through your browser or using the automatic scripts installation tool that is integrated into the hosting Control Panel. The needed engine will be recognized automatically and will be set for that database, so you can use scripts that require InnoDB, as well as ones that require the default MySQL engine, MyISAM, without needing to cope with any obstacle.