InnoDB is a popular storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has a number of strong sides which have made it the preferred engine for lots of open-source script-based web apps, such as Magento and Joomla™, which have switched over to InnoDB permanently. For instance, adding huge amounts of data will be much faster with InnoDB, as it locks only one database row to complete a given task, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is handled. In simpler words, adding new or updating existent data will either be fully completed, or will be aborted and the operation will be rolled back in case a certain problem appears in the meantime, which means that the content that remains in the database won’t be lost.

InnoDB in Web Hosting

Every script-driven app that needs InnoDB will run impeccably on our advanced cloud web hosting platform and the database engine is available with all our web hosting plans. Each time you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will use will be selected in accordance with the app’s prerequisites without having to update any setting in your hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to take advantage of its full potential. We’ll make regular content backups, so in case you accidentally remove a database that’s important to you or you overwrite a certain part of it, we will be able to restore everything the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Servers

You can run a PHP-powered software app that requires InnoDB with all of our semi-dedicated server packages, because 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 ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our 1-click application installer. Either way, the needed engine will be chosen automatically as soon as the activation of the application starts, so you will not have to update anything manually, regardless of whether the app requires InnoDB or the more widely used MyISAM. In addition, we will always be able to retrieve any of your databases if you delete one by mistake, as we perform a few backups every day, each of which is preserved for 7 days.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-developed Hepsia Control Panel come with a software package that’s pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you will not need to activate it manually if you need to activate PHP scripts that need it. All it takes to install such a script is to create a new database and to begin the installation – as soon as the setup wizard receives access to the database in question and begins entering data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You’ll also be able to use scripts that need the other widely used MySQL engine, MyISAM, so you will not have to configure any settings on the dedicated server. This will permit you to install different scripts on one single physical machine and to use it to its full capacity.