InnoDB is a very popular database storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has many pluses that have made it the engine of choice for a lot of PHP-based apps, including Joomla and Magento, which have switched to InnoDB permanently. For instance, importing immense volumes of data will be much faster with InnoDB, because it locks only one row to accomplish a particular task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is tackled. To put it simply, importing new or updating existing data will either be fully completed, or will be aborted and the operation will be rolled back if any issue appears in the meantime, thus the content that remains in the database will not be lost.

InnoDB in Shared Website Hosting

Every open-source script-driven web application that requires InnoDB will function flawlessly on our leading-edge cloud hosting platform and the MySQL database engine comes with all our shared website hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will use will be selected based on the app’s prerequisites without the need to change any setting in your shared account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to take advantage of its full potential. We’ll make regular backups of your content, so if you accidentally remove a MySQL database that you need or you overwrite a certain part of it, we’ll be able to restore your data the way it was only a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database through the hosting Control Panel provided with each of our semi-dedicated server accounts and you begin installing a PHP script-driven software application either manually or using our one-click app installer, the storage engine for the MySQL database will be picked automatically based on the specific app’s prerequisites. Since InnoDB is available on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for each app that needs it without the need for any manual intervention on your end at any time. To prevent any chance of losing data if you update an application or if you erase a database unintentionally, we’ll perform backups of all your databases each day, so if anything goes wrong, we can rescue your data.

InnoDB in VPS

If you buy a virtual private server from us, you’ll be able to take advantage of our in-house built Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to run any open-source script-driven app that needs InnoDB, as this MySQL storage engine is an integral part of the default software package that will be pre-installed on the Virtual Private Server during its creation. When you set up 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 application in question needs it, so you won’t have to do anything else in your VPS account. Likewise, if a given app requires MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Hosting

When you get a new dedicated server, you’ll be able to pick any of the 3 Control Panels offered by us – cPanel, Hepsia and DirectAdmin. Each server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to activate this database storage engine manually so as to be able to manage PHP script-based web apps that require it. InnoDB is used by scalable apps and since a dedicated server will give you all the server resources that you need in order to manage large-size sites, it’s very possible that you’ll use InnoDB. You will be able to make use of other engines as well, so if a certain app needs MyISAM instead of InnoDB, you won’t need to deal with any impediment while using it. The engine that will be used will be automatically detected the moment the app installation starts, so you won’t need to configure any setting manually at any time.