InnoDB is a popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has a lot of strengths which have made it the preferred engine for a lot of PHP script-powered software applications, among them Magento and Joomla, which have switched to InnoDB permanently. For example, adding immense volumes of data will be much faster with InnoDB, since it locks only a single database row to complete a given task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the info is tackled. Simply put, adding new or modifying existing data will either be thoroughly completed, or will be aborted and the operation will be rolled back if a given issue shows up in the meantime, therefore the content that remains in the database will not be lost.

InnoDB in Cloud Hosting

Every PHP-powered web application that needs InnoDB will function impeccably on our avant-garde cloud platform and the database engine is available with all our cloud hosting packages. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected on the basis of the app’s specifications without having to configure any setting in your shared web hosting account. InnoDB will be picked automatically for any app that requires this specific engine and you will be able to make the most of its full capacity. We will store regular content backups, so in case you accidentally erase a database that is important to you or you overwrite a certain part of it, we will be able to restore the database the way it was only several hours ago.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our semi-dedicated servers by default, so as soon as you order a new semi-dedicated account, you can go ahead and activate any script-powered software app that needs this MySQL storage engine. A couple of engines are pre-installed on our cloud platform, so when you create a new database and begin installing an app manually, or opt to use the Hepsia Control Panel-integrated application installer, the engine for the database will be chosen depending on the prerequisites of the specific application. This will allow you to activate and manage InnoDB-specific apps without running into any complication and without having to update any settings in your semi-dedicated account. To take no chances, we’ll always keep a seven-day-old backup of all your MySQL databases, so if you erase or edit any content by accident, we can quickly recover it.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-developed Hepsia Control Panel come with a software package that’s pre-activated and besides everything else, you will get the InnoDB database engine, so you won’t need to activate it manually if you would like to activate scripts that require it. All it takes to activate such a script is to create a new database and to begin the setup process – once the installer wizard gains access to the database in question and begins inserting 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 activate scripts that need the other very popular MySQL engine – MyISAM, so you won’t need to change any settings on the server. This will permit you to install different scripts on a single physical machine and to use it to its full potential.