InnoDB is a very popular database engine for MySQL. It is an alternative to the default MyISAM engine and it has got a number of upsides that have made it the preferred engine for a lot of open-source script-based applications, such as Magento and Joomla, which have moved to InnoDB for good. For instance, adding enormous data volumes will be much faster with InnoDB, because it locks only one database row to accomplish a particular operation, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the info is tackled. Simply put, adding new or modifying existent data will either be fully completed, or will be canceled and the operation will be rolled back if a certain problem occurs during the process, hence the content that remains in the database will not be damaged.

InnoDB in Shared Website Hosting

InnoDB is offered with all our Linux shared website hosting by default, not as a paid upgrade or upon request, so you can activate and manage any PHP script-powered app that needs the InnoDB database storage engine without any problem once you order your shared hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation process, regardless of whether you take advantage of our single-click installer or create the database and set up the application manually, on the condition that the app requires it instead of the more famous MyISAM engine. We’ll perform daily backups of all your MySQL databases, so you can be sure that you won’t ever lose any content if you erase a database by mistake or you overwrite some key info – you’ll just need to touch base with us and we’ll restore your content the way it was.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database from the Control Panel provided with all our semi-dedicated server packages and you start installing an open-source script-based web application either manually or using our one-click application installer, the storage engine for the MySQL database will be picked automatically depending on the prerequisites of the given app. As InnoDB is present on the cloud 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 the need for any manual intervention on your end at any point. To prevent any chance of losing information if you update an app or if you erase a database unintentionally, we will perform a backup of all your databases every day, so if anything goes wrong, we can recover your data.

InnoDB in VPS Web Hosting

When you buy a virtual private server from us, you will be able to take full advantage of our in-house built Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to activate any open-source script-driven software app that requires InnoDB, as the database engine is included in the standard software bundle that will be installed on the VPS server during its creation. When you set up a brand new database using the hosting Control Panel, you’ll just have to start installing an application – manually or using our application installer tool. InnoDB will be set as the default engine if the application in question needs it, so you will not have to do anything else in your VPS account. Correspondingly, if an application needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting that are ordered with our custom-developed Hepsia Control Panel come with a software package that is pre-installed and among everything else, you will get the InnoDB database engine, so you won’t need to activate it manually if you wish to run scripts that require it. All it takes to install such a script is to create a new database and to begin the installation – once the setup wizard gains access to the database in question and starts importing content into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the script. You’ll also be able to run scripts that require the other popular MySQL engine, MyISAM, so you won’t have to configure any settings on the server. This will permit you to activate different scripts on one single physical server and to use it to its fullest capabilities.