InnoDB is a popular storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has got plenty of advantages that have made it the preferred engine for plenty of script-powered apps, such as Joomla and Magento, which have switched over to InnoDB for good. For instance, importing large volumes of data will be much faster with InnoDB, due to the fact that it locks only one database row to execute a certain task, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the data is treated. Put simply, importing new or editing existing data will either be fully completed, or will be aborted and the operation will be rolled back in case a certain problem shows up during the process, which means that the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

Any script-driven web app that needs InnoDB will function impeccably on our avant-garde cloud platform and the MySQL database engine is offered with all our shared hosting plans. Every time 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 specifications without having to update any setting in your shared web hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to take advantage of its full potential. We will carry out regular backups of your content, so in case you accidentally remove a database that’s important to you or you overwrite a specific part of it, we will be able to restore your content the way it was just a few hours earlier.

InnoDB in Semi-dedicated Servers

You can make use of a script-powered web application that requires InnoDB with all of our semi-dedicated server plans, since all the accounts are set up on our cutting-edge cloud hosting platform where the storage engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our 1-click app installer tool. Either way, the needed engine will be selected automatically the moment the installation of the application begins, so you will not have to change anything manually, regardless of whether the application needs InnoDB or the more regularly used MyISAM. Furthermore, we’ll always be able to retrieve any of your MySQL databases in case you accidentally remove one, as we make a few backups every day, each of which is preserved for one week.

InnoDB in VPS Servers

If our custom-developed Hepsia hosting Control Panel is picked during the registration process for a new VPS servers , InnoDB will be activated on the VPS server together with other essential software, so you won’t have to do anything if you choose to install script-driven software apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be activated as well. You can create a new MySQL database and start the app installation procedure manually or using our 1-click installer. The system will recognize which engine the particular app requires and will assign it to the specific MySQL database, so the installation will continue impeccably and the application can enter its content into that database. Therefore, you can use apps with various prerequisites regarding the MySQL engine without the need to make any changes on your VPS server.

InnoDB in Dedicated Servers

When you obtain a new dedicated server, you’ll be able to select one of the three hosting Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Each server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to enable this database engine manually so as to be able to manage open-source script-powered apps that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you need to run large-size websites, it is very possible that you’ll resort to InnoDB. You will be able to make use of other engines too, so if a given app needs MyISAM rather than InnoDB, you won’t have any impediment while managing it. The engine that will be used will be detected automatically as soon as the app installation process starts, so you won’t need to change any settings manually at any moment.