InnoDB is a very popular database engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got many upsides which have made it the preferred engine for many PHP-driven apps, such as Joomla™ and Magento, which have moved to InnoDB permanently. For example, importing huge volumes of data will be much faster with InnoDB, as it locks only a single row to accomplish a specific operation, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the info is handled. To put it simply, importing new or updating existing data will either be thoroughly completed, or will be annulled and the procedure will be rolled back if a given issue appears during the process, so the content that remains in the database will not be lost.

InnoDB in Shared Hosting

You will be able to run any open-source script-based app that requires InnoDB in case you have a Linux shared package with our company, as the MySQL storage engine is available on our cutting-edge cloud website hosting platform by default. During the app installation – 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 install apps which require the MyISAM engine without having to deal with any problem as well and, again, the engine will be selected automatically, so you won’t have to update any setting manually at any point. Furthermore, we will also generate daily backups of all the MySQL databases that you’ve got in your shared web hosting account, so if 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 Hosting

You can use a script-based app that requires InnoDB with all of our semi-dedicated server plans, because all the accounts are created on our innovative cloud platform where the MySQL database 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 one-click app installer tool. In either case, the needed engine will be picked automatically the moment the activation of the app starts, so you won’t have to change anything manually, irrespective of whether the application requires InnoDB or the more frequently used MyISAM. Also, we’ll always be able to recover any of your databases in case you remove one by accident, as we carry out a couple of database backups every day, each of which is saved for 7 days.

InnoDB in VPS Hosting

In case our custom-built Hepsia Control Panel is chosen during the registration process for a new Linux VPS hosting packages , InnoDB will be installed on the Virtual Private Server together with other necessary software, so you will not have to do anything if you choose to use script-based applications that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can set up a brand-new MySQL database and begin the app installation manually or through our one-click installer tool. The system will automatically detect which engine the particular application needs and will set it for the specific database, so the installation will continue impeccably and the application can insert its content into that database. Therefore, you can run apps with different requirements regarding the MySQL engine without having to make any modifications on your server.

InnoDB in Dedicated Web Hosting

All Linux dedicated servers hosting packages ordered with our custom-developed Hepsia Control Panel come with a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB storage engine, so you will not need to add it manually if you wish to use scripts that need it. All it takes to run such a script is to create a new MySQL database and to begin the setup – as soon as the installation wizard receives access to the database in question and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You will also be able to use scripts that need MyISAM – the other widely used MySQL engine, so you will not need to edit any settings on the dedicated server. This will allow you to use a variety of scripts on a single physical server and to use it to its full potential.