InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it offers a much better overall performance and a faster database crash recovery compared with the default engine that is used by MySQL – MyISAM. InnoDB is preferred by a lot of devs that create scalable apps, because it works much better with enormous data volumes, while it keeps the server processing load at a minimum. Furthermore, it uses row-level locking if anything should be edited, while many other engines lock the entire database table and thus require much more time to process several sequential tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed for any reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the latest Joomla versions are two examples of widespread open-source script-powered apps which have shifted over to InnoDB.

InnoDB in Cloud Web Hosting

You’ll be able to install any PHP-based app that needs InnoDB if you’ve got a cloud web hosting plan with our company, as the storage engine is available on our advanced cloud platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is required. You can install apps which need the MyISAM engine without the need to deal with any obstacle as well and, once again, the engine will be pre-selected, so you will not need to change any setting manually at any point. In addition, we’ll also perform daily backups of all the MySQL databases that you’ve got in your shared web hosting account, so in case you delete or overwrite anything, we can quickly get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

InnoDB is included with each of our semi-dedicated plans by default, so as soon as you order a new account, you can move on and install any PHP-based software application that needs this particular database engine. A couple of engines are installed on our cloud web hosting platform, so when you create a brand new MySQL database and begin installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be set depending on the concrete app’s prerequisites. This will allow you to activate and run InnoDB-specific applications without any obstacle and without the need to modify any settings in your semi-dedicated account. To take no chances, we will always keep a 7-day-old backup of all your databases, so if you delete or alter any content accidentally, we can swiftly retrieve it.

InnoDB in VPS Servers

If our custom-developed Hepsia Control Panel is selected during the registration process for a new VPS web hosting plans , InnoDB will be installed on the VPS server together with other required pieces of software, so you will not have to do anything if you decide to use PHP script-powered web apps that require this MySQL storage engine. The default MySQL engine – MyISAM, will be activated too. You can create a brand new database and start installing the app manually or through our single-click installer. The system will automatically detect the engine that the particular app requires and will assign it to the specific database, so the installation will continue impeccably and the application can insert its content into that database. Thus, you can use applications with different prerequisites in regard to the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom-developed Hepsia Control Panel come with a software package that’s pre-activated and among everything else, you will get the InnoDB database engine, so you won’t need to add it manually if you would like to activate PHP scripts that require it. All it takes to install such a script is to set up a new database and to start the installation – once the script configuration wizard obtains access to the database in question and begins entering data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You will also be able to activate scripts that require the other very popular MySQL engine – MyISAM, so you will not need to update any settings on the dedicated server. This will allow you to use a variety of scripts on a single machine and to use it to its full potential.