InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it offers a significantly better overall performance and an improved database crash recovery compared with the default engine used by MySQL – MyISAM. InnoDB is endorsed by lots of programmers that run scalable software applications, since it works much more effectively with immense amounts of data, while it keeps the server load low. In addition, it it locks only one row in the database if any information should be edited, while lots of other engines lock the entire database table and thus require much more time to carry out several successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for some reason, the action is rolled back to prevent scrambling or data loss. Magento and the latest Joomla™ editions are two instances of popular PHP script-based applications which have moved to InnoDB.

InnoDB in Cloud Website Hosting

Any PHP script-driven software app that needs InnoDB will run impeccably on our innovative cloud website hosting platform and the database engine comes with all our cloud website hosting packages. Every time you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will use will be selected in accordance with the app’s prerequisites without the need to change any setting in your hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you’ll be able to make the most of its full capacity. We’ll perform daily backups of your content, so in case you unintentionally remove a MySQL database that is important to you or you overwrite a specific part of it, we’ll be able to restore your data the way it was just several hours earlier.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the Control Panel provided with each of our semi-dedicated server packages and you begin installing a PHP-powered software application either manually or using our 1-click app installer tool, the MySQL database storage engine will be picked automatically based on the requirements of the particular application. Since InnoDB is available on the cloud web hosting platform where your new account will be created, it will be set as the default engine for each app that needs it without any manual action needed on your end at any time. To avoid any risk of losing information if you update an application or if you delete a database accidentally, we’ll perform a backup of all your databases each and every day, so if something happens, we can restore your content.

InnoDB in VPS Servers

If our custom Hepsia hosting Control Panel is picked during the registration process for your new VPS servers , InnoDB will be activated on the Virtual Private Server along with other required pieces of software, so you will not have to do anything if you choose to install PHP script-based apps that require this MySQL storage engine. The default MySQL engine, MyISAM, will be activated too. You can set up a brand-new database and start the app installation process manually or using our 1-click installer. The system will detect the engine that the app in question requires and will assign it to the specific database, so the installation will continue flawlessly and the application can insert its data into that database. Thus, you can manage apps with various prerequisites with regard to the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you will be able to choose any of the 3 hosting Control Panels that we are offering – Hepsia, DirectAdmin and cPanel. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to install this MySQL storage engine manually to be able to use PHP-based applications that need it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the server resources that you require to run very large sites, it’s rather possible that you will resort to InnoDB. You’ll be able to use other engines too, so if a certain application needs MyISAM rather than InnoDB, you will not come across any difficulty while running it. The engine that will be used will be detected automatically when the app installation process starts, so you won’t have to modify any setting manually at any time.