InnoDB is a very popular database storage engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has a lot of upsides which make it the engine of choice for plenty of open-source script-powered web apps, among them Joomla and Magento, which have switched over to InnoDB permanently. For example, adding huge data volumes will be faster with InnoDB, because it locks only one database row to accomplish a certain task, not the entire database table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. To put it simply, appending new or updating existent data will either be thoroughly completed, or will be aborted and the procedure will be rolled back in case some issue shows up during the process, thus the content that remains in the database won’t be damaged.

InnoDB in Cloud Hosting

While InnoDB is either not offered or it is a paid upgrade with other hosting service providers, it’s part of the default set of features that we offer with our cloud hosting plans. In case you want to make use of a PHP script-driven web application that needs InnoDB particularly, in order to be installed and to work properly, you will not have any impediments because the storage engine is available on our custom cloud platform. Irrespective of whether you create a brand-new MySQL database and activate an app manually or make use of our one-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the particular application requires it rather than MyISAM. In addition to the incredible database crash recovery offered by InnoDB, we also maintain regular database backups, so we can easily restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database from the hosting Control Panel offered with all our semi-dedicated server packages and you start installing an open-source script-powered web application either manually or using our single-click application installer, the database storage engine will be picked automatically based on the requirements of the given app. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any point. To prevent any chance of losing info if you update an application or if you remove a database by mistake, we will generate backups of all your MySQL databases every day, so if something happens, we can recover your data.

InnoDB in VPS Web Hosting

In case our in-house developed Hepsia hosting Control Panel is selected during the signup process for a new Linux virtual private servers , InnoDB will be activated on the server together with other necessary pieces of software, so you won’t need to do anything if you decide to run PHP script-based apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be installed as well. You can create a brand new MySQL database and begin the app installation procedure manually or using our 1-click installation tool. The system will recognize the engine that the particular app needs and will assign it to the specific MySQL database, so the installation will proceed impeccably and the application can dump its data in that database. Thus, you can manage applications with various prerequisites in regard to the MySQL engine without having to make any changes on your server.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting ordered with our custom-developed Hepsia Control Panel come with a software bundle that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not have to add it manually if you want to use scripts that need it. All it takes to run such a script is to set up a new MySQL database and to begin the setup – as soon as the script 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 provided that it is the one required by the script. You’ll also be able to use scripts that require the other very popular MySQL engine, MyISAM, so you will not have to change any settings on the dedicated server. This will allow you to install various scripts on one single machine and to use the latter to its maximum potential.