InnoDB is a popular storage engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has got plenty of pluses which have made it the engine of choice for a lot of PHP script-powered software applications, including Magento and Joomla, which have switched to InnoDB permanently. For example, adding enormous amounts of data will be much faster with InnoDB, due to the fact that it locks only one database row to complete a particular task, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is handled. In simpler words, appending new or modifying existent data will either be entirely completed, or will be aborted and the operation will be rolled back in case a certain issue occurs in the meantime, therefore the content that remains in the database won’t be lost.

InnoDB in Cloud Website Hosting

InnoDB is available with all our Linux cloud website hosting plans by default, not as a paid upgrade or upon request, so you can install and manage any PHP-driven web app which needs the storage engine without encountering any difficulty as soon as you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a given database during the app installation, irrespective of whether you use our 1-click installation tool or create the database and activate the app manually, on the condition that the application requires InnoDB instead of the more popular MyISAM engine. We’ll store regular MySQL database backups, so you can be sure that you won’t ever lose any data if you erase a database unintentionally or you overwrite some vital info – you will simply have to touch base with us and we’ll restore everything back to normal.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database from the Control Panel included with all our semi-dedicated server plans and you begin installing a PHP-driven web application either manually or using our 1-click application installer, the storage engine for the MySQL database will be set automatically depending on the requirements of the particular app. Since InnoDB is available on the cloud web hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any app that requires it without the need for any manual intervention on your end at any moment. To avoid any chance of losing information if you update an application or if you delete a database unintentionally, we will perform a backup of all your databases each and every day, so if something goes wrong, we can recover your content.

InnoDB in VPS Servers

When you order a VPS server from us, you’ll be able to take advantage of our custom Hepsia Control Panel to manage your content. A Hepsia-managed VPS will permit you to install any script-based application that needs InnoDB, as the MySQL database engine is an essential part of the standard software package that will be installed on the Virtual Private Server during its setup. When you set up a brand new MySQL database through the hosting Control Panel, you simply need to start installing an application – manually or using our app installer. InnoDB will be set as the default engine given that the app in question needs it, so you will not have to do anything else in your VPS account. In the same manner, if a given application requires MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

All Linux dedicated servers ordered with our custom-built Hepsia Control Panel come with a software bundle that is pre-activated and besides everything else, you will get the InnoDB database storage engine, so you will not have to add it manually in case you want to run scripts that need it. All it takes to install such a script is to create a new database and to start the installation – as soon as the script setup wizard obtains access to the database and begins dumping content in it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You will also be able to use scripts that require MyISAM – the other very popular MySQL engine, so you won’t have to change any settings on the server. This will allow you to use a variety of scripts on a single physical server and to use the latter to its maximum potential.