InnoDB is a popular storage engine for MySQL. It is an alternative to the default MyISAM engine and it has got plenty of advantages which have made it the preferred engine for a lot of open-source script-based web applications, such as Joomla and Magento, which have moved to InnoDB for good. For example, importing huge amounts of data will be faster with InnoDB, as it locks only one database row to carry out a task, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is treated. To put it simply, adding new or editing existing data will either be entirely completed, or will be canceled and the operation will be rolled back in case a certain issue occurs in the meantime, which is why the content that remains in the database will not be lost.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud plans by default, not upon request or as a paid upgrade, so you can activate and run any PHP-powered software app which needs the InnoDB database engine without the need to deal with any difficulty as soon as you open your shared web hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app activation process, irrespective of whether you make use of our one-click installer or create the database and install the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll generate daily database backups, so you can be sure that you will never lose any content in case you delete a database by mistake or you overwrite some essential information – you simply need to alert us and we’ll restore the database back to normal.

InnoDB in Semi-dedicated Servers

You can activate a PHP-powered web application that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are created on our innovative cloud web hosting platform where the MySQL database storage engine is installed. A new MySQL database can be created in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you take advantage of our one-click application installer tool. Either way, the required engine will be chosen automatically the moment the app’s installation begins, so you won’t have to change anything manually, regardless of whether the app needs InnoDB or the more regularly used MyISAM. On top of that, we will always be able to recover any of your databases in case you erase one by mistake, as we make a couple of MySQL database backups every day, each of which is kept for 7 days.

InnoDB in VPS Servers

If you choose a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be an integral part of the default software pack that will be pre-installed on your VPS server before we give it to you. You will not need to set up anything manually and you’ll be able to enable and use any PHP script-driven software app that requires InnoDB when your VPS server is up and running, which takes no more than sixty minutes after the order submission process itself. A couple of engines are offered, so whenever you set up a MySQL database using the Hepsia hosting Control Panel, a particular engine will be picked when the app activation process commences and our system will detect the engine that is required by the app in question. In case you have to use MyISAM, for instance, you won’t need to do anything different from installing the desired app, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

If you get a new dedicated server, you’ll be able to select one of the 3 hosting Control Panels that we offer – Hepsia, DirectAdmin and cPanel. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t need to install this MySQL database storage engine manually so as to be able to manage PHP script-powered web applications that need it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the resources that you need in order to run large-size sites, it is pretty possible that you will resort to InnoDB. You’ll be able to make use of other engines too, so if a specific app needs MyISAM instead of InnoDB, you will not experience any problem while running it. The engine that will be used will be automatically recognized once the app installation begins, so you will not need to configure any setting manually whatsoever.