InnoDB is a very popular storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has a number of advantages that have made it the engine of choice for a lot of PHP script-driven web applications, such as Joomla and Magento, which have switched to InnoDB permanently. For instance, importing huge data volumes will be much faster with InnoDB, due to the fact that it locks only a single row to execute a certain task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the info is handled. In simpler words, importing new or modifying existing data will either be fully completed, or will be annulled and the procedure will be rolled back if a certain problem appears in the meantime, therefore the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

InnoDB is offered with all our Linux shared hosting by default, not upon request or as a paid upgrade, so you can install and manage any PHP-powered web app which requires the MySQL storage engine without the need to deal with any obstacle as soon as you open your shared hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation, irrespective of whether you make use of our single-click installer or create the MySQL database and activate the app manually, on the condition that the app requires it instead of the more popular MyISAM engine. We will create regular MySQL database backups, so you can rest assured that you won’t ever lose any content in case you delete a database by accident or you overwrite some crucial info – you just have to get in touch with us and we’ll restore your data the way it was.

InnoDB in Semi-dedicated Hosting

You can install a script-powered software app that requires InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our cutting-edge cloud web hosting platform where the database storage engine is installed. A new database can be set up in two different ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you make use of our one-click application installer. In either case, the needed engine will be chosen automatically the moment the activation of the app begins, so you will not have to configure anything manually, irrespective of whether the app requires InnoDB or the more regularly used MyISAM. On top of that, we will always be able to retrieve any of your MySQL databases in case you erase one by mistake, as we create a few backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS

If you get a virtual private server with our Hepsia Control Panel, the InnoDB database storage engine will be an indivisible part of the standard software pack that will be installed on your Virtual Private Server before we hand it over to you. You won’t have to set up anything manually and you will be able to enable and run any open-source script-powered software app that requires InnoDB as soon as your VPS is up and running, which takes no more than 60 minutes after the order submission process itself. Several engines are available, so every time you set up a MySQL database using the Hepsia Control Panel, a particular engine will be activated once the app installation starts and our system will automatically recognize the engine that is required by the application in question. If you need to use MyISAM, for instance, you won’t have to do anything different than installing the application of your preference, whether manually or using our app installer tool.

InnoDB in Dedicated Hosting

All dedicated hosting that are ordered with our custom Hepsia hosting Control Panel include a software bundle that is pre-activated and besides everything else, you will get the InnoDB database storage engine, so you will not need to activate it manually in case you want to use scripts that require it. All it takes to activate such a script is to set up a new MySQL database and to start the setup – as soon as the setup wizard acquires access to the database and begins inserting content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to install scripts that require the other popular MySQL engine – MyISAM, so you won’t need to change any settings on the dedicated server. This will permit you to run various scripts on one single physical server and to use the latter to its fullest capabilities.