InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it provides a much better overall performance and a faster crash recovery compared with the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is preferred by many developers that run highly scalable software applications, due to the fact that it works better with large data volumes, while it keeps the server processing load at a minimum. What’s more, it it locks only one row in the database if any info should be edited, while many other engines lock the entire table and therefore require more time to perform several sequential tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for any reason, the action is rolled back to prevent confusion or data loss. Magento and the latest Joomla releases are two examples of widespread PHP-based software apps which have shifted over to InnoDB.

InnoDB in Website Hosting

You’ll be able to run any PHP script-driven software application that needs InnoDB if you’ve got a website hosting plan with us, as the MySQL storage engine is available on our advanced cloud website hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is needed. You can run apps that need the MyISAM engine without any obstacles as well and, again, the engine will be pre-selected, so you won’t need to configure any setting manually at any moment. What’s more, we will also perform daily backups of all the databases that you have in the shared web hosting account, so in case you erase or overwrite something, we can easily get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

You can use a PHP-based software application that requires InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are set up on our avant-garde cloud hosting platform where the database storage engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our one-click app installer. In either case, the needed engine will be picked automatically once the application’s installation begins, so you will not have to edit anything manually, no matter if the application needs InnoDB or the more regularly used MyISAM. In addition, we will always be able to recover any of your databases in case you erase one by mistake, as we make several MySQL database backups every day, each of which is preserved for 7 days.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an essential part of the software pack that will be pre-installed on your server before we give it to you. You will not have to set up anything manually and you’ll be able to enable and use any script-based software app that requires InnoDB once your VPS server is ready, which takes no more than 1 hour after the order procedure itself. Several engines are available, so whenever you set up a database using the Hepsia Control Panel, a specific engine will be selected when the app installation commences and our system will automatically detect the engine that is required by the app in question. In case you have to use MyISAM, for instance, you won’t have to do anything different from installing the chosen app, whether manually or using our application installer.

InnoDB in Dedicated Servers

InnoDB is included by default with all dedicated web hosting plans ordered with the Hepsia hosting Control Panel. It’s included in the software bundle that we install on all Hepsia-managed dedicated servers, so once your machine is ready, you’ll be able to log in and to install a various PHP script-driven app that needs this particular MySQL storage engine. If you create a new database through the hosting Control Panel, there won’t be any activated engine until you start installing an application. Once the app setup wizard starts inserting information into the database, the engine will be picked automatically based on the prerequisites of the given app, so you can run both InnoDB and MyISAM without the need to select either one specifically at any time. In this way, you can make use of a large range of applications for your Internet sites.