InnoDB is a database storage engine for MySQL databases, which is used by famous PHP-driven web apps such as Magento and Joomla 3. It’s excellent for scalable applications, because it works remarkably well when processing immense data volumes. Instead of locking the whole database table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can complete much more operations for the same length of time. Additionally, InnoDB offers a better database failure recovery and supports transactions and foreign key constraints – a set of rules that specify how data inserts and updates should be handled. In case a certain task has not been fully completed for any reason, the action will be rolled back. Thus, the database content will stay safe and sound and won’t be partially merged with newly imported content.

InnoDB in Cloud Website Hosting

You will be able to use any PHP script-powered software application that needs InnoDB in case you have a cloud website hosting with us, as the MySQL database engine is available on our cutting-edge cloud web hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is needed. You can activate apps which use the MyISAM engine without the need to deal with any problem as well and, again, the engine will be selected automatically, so you won’t have to update anything manually at any time. On top of that, we will also perform regular backups of all the MySQL databases that you’ve got in the account, so in case you erase or overwrite something, we can quickly restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

You can use a script-powered web app that requires InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our avant-garde cloud hosting platform where the MySQL storage engine is installed. A new MySQL database can be created in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our 1-click application installer. Either way, the required engine will be chosen automatically once the installation of the application begins, so you will not need to modify anything manually, regardless of whether the application requires InnoDB or the more widely used MyISAM. In addition, we will always be able to recover any of your databases if you accidentally erase one, as we make a few backups every day, each of which is stored for seven days.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be included in the standard software package that will be pre-installed on your server before we hand it over to you. You will not have to set up anything manually and you will be able to enable and run any PHP script-driven application that needs InnoDB as soon as your VPS server is up and running, which takes no more than one hour after the order procedure itself. A number of engines are offered, so whenever you set up a database through the Hepsia hosting Control Panel, a particular engine will be selected once the app installation process commences and our system will automatically recognize the engine that is required by the application in question. In case you have to use MyISAM, for example, you will not have to do anything different than installing the app of your preference, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

InnoDB comes as standard with all Linux dedicated servers ordered with the Hepsia hosting Control Panel. It is included in the default software package that will be installed on all Hepsia-equipped dedicated servers, so as soon as your physical machine is up and running, you’ll be able to log in and to install any type of script-driven web application that requires this particular database engine. If you set up a new MySQL database via the Control Panel, there won’t be any activated engine till you start installing an app. As soon as the app configuration wizard starts inserting information into the database, the engine will be selected automatically based on the prerequisites of the respective application, so you can run both MyISAM and InnoDB without the need to select either of them explicitly at any time. In this way, you can make use of an extensive range of apps for your sites.