InnoDB is a storage engine for MySQL relational databases, which is used by widespread PHP script-driven apps such as Joomla 3.x and Magento. It’s excellent for scalable apps, since it excels in processing enormous amounts of data. 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 handle much more tasks for the same length of time. Besides, InnoDB offers a better database failure recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data imports and modifications should be handled. If a given task has not been thoroughly completed for any reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and will not be partially merged with new content.

InnoDB in Website Hosting

Any open-source script-based application that requires InnoDB will run impeccably on our leading-edge cloud hosting platform and the MySQL database engine comes with all our website hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will make use of will be selected based on the app’s requirements without having to edit any setting in your shared web hosting account. InnoDB will be picked automatically for any app that requires this specific engine and you will be able to make the most of its full capacity. We’ll store daily backups of your content, so in case you accidentally remove a MySQL database that is important to you or you overwrite a specific part of it, we will be able to restore your data the way it was only a couple of hours ago.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our semi-dedicated hosting plans by default, so as soon as you create a new account, you can go on and install any script-powered application that needs this database storage engine. A few engines are pre-installed on our cloud web hosting platform, so when you set up a brand-new MySQL database and start 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 based on the prerequisites of the respective app. This will permit you to activate and run InnoDB-specific applications without the need to cope with any impediment and without needing to modify any settings in your semi-dedicated account. To be on the safe side, we will always keep a 7-day-old backup of all your databases, so if you erase or change any content by accident, we can quickly rescue it.

InnoDB in VPS Servers

If you get a VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be an integral part of the standard software pack that will be pre-installed on your server before we give it to you. You won’t need to set up anything manually and you will be able to enable and run any PHP-driven web application that needs InnoDB as soon as your VPS server is set up, which takes no more than 60 minutes after the order submission itself. A couple of engines are available, so anytime you set up a MySQL database using the Hepsia Control Panel, a particular engine will be picked when the app installation process commences and our system will recognize the engine that is required by the application in question. If you need MyISAM, for example, you won’t have to do anything different than installing the desired application, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated web hosting plans ordered with the Hepsia Control Panel. It’s included in the standard software bundle that we install on all Hepsia-managed dedicated servers, so once your physical machine is assembled, you will be able to sign in and to activate any type of script-based software application that needs this database storage engine. If you create a new database via the hosting Control Panel, there won’t be any active engine until you start installing an app. Once the app setup wizard begins dumping data in the database, the engine will be set automatically depending on the given app’s prerequisites, so you can run both InnoDB and MyISAM without having to select either of them specifically at any time. Thus, you can use a broad selection of apps for your sites.