InnoDB is a very popular storage engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has got numerous upsides which have made it the engine of choice for numerous PHP script-driven applications, such as Magento and Joomla, which have switched to InnoDB for good. For instance, importing huge data volumes will be faster with InnoDB, since it locks only a single row to execute a certain operation, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the information is treated. Simply put, adding new or updating existing data will either be fully completed, or will be annulled and the procedure will be rolled back if some issue appears in the meantime, thus the content that remains in the database will not be damaged.

InnoDB in Shared Hosting

You’ll be able to make use of any script-driven web app that requires InnoDB in case you’ve got a Linux shared hosting package with us, as the MySQL database storage engine is present on our leading-edge cloud platform as standard. 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 required. You can activate applications which use the MyISAM engine without encountering any obstacle as well and, again, the engine will be pre-selected, so you won’t have to edit any setting manually at any time. Furthermore, we’ll also generate daily backups of all the MySQL databases that you’ve got in your shared hosting account, so in case you delete or overwrite anything, we can quickly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database from the Control Panel included with all our semi-dedicated server packages and you start installing a script-powered web application either manually or using our single-click application installer tool, the storage engine for the MySQL database will be picked automatically based on the prerequisites of the specific app. Since InnoDB is present on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for any application that needs it without any manual intervention needed on your end at any time. To avoid any chance of losing information if you update an application or if you erase a database by accident, we will make backups of all your MySQL databases each day, so if something happens, we can restore your content.

InnoDB in VPS

All Linux VPS packages that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to make use of any script-driven software app that requires this particular MySQL storage engine without the need to configure anything manually. You can select Hepsia on the VPS order form and your brand-new Virtual Private Server will be set up within one hour, so you can sign in and start creating your sites right away. When you set up a brand new database and begin the app installation process, our system will choose the engine for this database automatically. In this way, you can make use of different apps at the same time without the need to configure anything on the VPS server. You can create a WordPress-driven personal weblog that uses the default MySQL engine – MyISAM, and a Magento-powered Internet shop that uses the InnoDB engine, for example.

InnoDB in Dedicated Hosting

All Linux dedicated servers hosting packages ordered with our in-house developed Hepsia Control Panel come with a software package that is pre-activated and besides everything else, you’ll get the InnoDB storage engine, so you will not have to install it manually if you’d like to use open-source scripts that require it. All it takes to use such a script is to set up a new database and to begin the installation – once the script setup wizard obtains access to the database and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the particular script. You’ll also be able to install scripts that require MyISAM – the other widely used MySQL engine, so you will not need to modify any settings on the server. This will permit you to use a variety of scripts on one single physical server and to use it to its maximum capabilities.