InnoDB is a very popular database storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has got many pluses that have made it the preferred engine for a lot of script-based web applications, among them Magento and Joomla, which have moved to InnoDB permanently. For example, adding enormous amounts of data will be faster with InnoDB, as it locks only one database row to perform a specific task, not the entire database table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the info is tackled. To put it simply, importing new or updating existent data will either be entirely completed, or will be annulled and the procedure will be rolled back in case a given problem appears during the process, hence the content that remains in the database won’t be lost.

InnoDB in Shared Hosting

InnoDB is available with all our shared hosting by default, not upon request or as a paid upgrade, so you can install and manage any script-based software application which requires the database storage engine without having any difficulty once you activate your shared hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app installation, no matter if you take advantage of our one-click installer or create the MySQL database and install the app manually, on the condition that the application requires it instead of the more famous MyISAM engine. We will perform regular backups of all your databases, so you can be certain that you will never lose any data in case you delete a database by accident or you overwrite some crucial information – you’ll just have to notify us and we will restore your database the way it was.

InnoDB in Semi-dedicated Servers

You can run an open-source script-powered web application that requires InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are set up on our cutting-edge cloud web hosting platform where the database engine is installed. A new MySQL database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our 1-click app installer. In either case, the needed engine will be picked automatically the moment the application’s activation begins, so you won’t have to modify anything manually, irrespective of whether the application needs InnoDB or the more widely used MyISAM. In addition, we will always be able to recover any of your databases if you accidentally remove one, as we create a few database backups every day, each of which is saved for seven days.

InnoDB in VPS Servers

When you acquire a VPS server from our company, you’ll be able to take full advantage of our custom-built Hepsia Control Panel to manage your web content. A Hepsia-equipped VPS will allow you to use any open-source script-powered software application which needs InnoDB, as the database storage engine is part of the default software package that will be pre-installed on the server during its setup. When you create a brand-new MySQL database through the hosting Control Panel, you will just have to start installing an app – manually or using our application installer tool. InnoDB will be set as the default engine if the app in question requires it, so you will not need to do anything else in your VPS account. Similarly, if a certain application needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house developed Hepsia hosting Control Panel include a software bundle that is pre-installed and besides everything else, you will get the InnoDB database storage engine, so you won’t have to activate it manually if you wish to use scripts that need it. All it takes to activate such a script is to set up a new database and to start the setup process – as soon as the setup wizard receives access to the database and begins importing data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You will also be able to activate scripts that need MyISAM – the other very popular MySQL engine, so you will not need to modify any settings on the dedicated server. This will enable you to install various scripts on one single physical server and to use the latter to its fullest capabilities.