InnoDB is a very popular database engine for the MySQL database management system. It’s an alternative to the default MyISAM engine and it has a number of pluses which have made it the preferred engine for a lot of PHP script-powered software apps, including Joomla and Magento, which have switched over to InnoDB permanently. For instance, adding immense data volumes will be faster with InnoDB, as it locks only one row to carry out a task, not the entire table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is tackled. Put simply, appending new or editing existing data will either be thoroughly completed, or will be annulled and the procedure will be rolled back in case any problem shows up during the process, therefore the content that remains in the database won’t be lost.

InnoDB in Cloud Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting service providers, it is part of the default set of features that we are offering with our cloud web hosting packages. In case you’d like to use a PHP-based web application that needs InnoDB in particular, in order to be installed and to work properly, you will not need to deal with any difficulties since the database engine is available on our custom-developed cloud web hosting platform. Irrespective of whether you create a brand new MySQL database and install an application manually or take advantage of our one-click app installer software tool, InnoDB will be selected automatically by our platform as the default engine if the respective application needs InnoDB instead of MyISAM. In addition to the incredible database crash recovery that InnoDB offers, we also make daily database backups, so that we can quickly recover any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

InnoDB is available with each of our Linux semi-dedicated hosting by default, so the moment you order a new account, you can go on and activate any open-source script-based software application that needs this particular database storage engine. A few engines are pre-installed on our cloud web hosting platform, so when you set up a brand new database and begin installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be chosen on the basis of the requirements of the app in question. This will permit you to install and manage InnoDB-specific apps without any problems and without having to configure any settings in your account. To be on the safe side, we will always have a one-week-old backup of all your MySQL databases, so if you delete or change any content by accident, we can easily rescue it.

InnoDB in VPS

In case our in-house built Hepsia Control Panel is chosen during the signup process for a new Linux virtual private servers , InnoDB will be activated on the server along with other required pieces of software, so you won’t need to do anything if you choose to install script-based apps that require this MySQL storage engine. MyISAM – the default MySQL engine, will be installed too. You can set up a new MySQL database and start installing the app manually or through our 1-click installation tool. The system will automatically detect which engine the particular app requires and will assign it to the specific database, so the installation will continue impeccably and the application can import its content into that database. In this way, you can run applications with various requirements regarding the MySQL engine without making any changes on your server.

InnoDB in Dedicated Hosting

All Linux dedicated hosting services that are ordered with our custom-developed Hepsia Control Panel come with a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you won’t need to install it manually in case you’d like to activate PHP scripts that need it. All it takes to use such a script is to set up a new MySQL database and to start the installation process – as soon as the setup wizard accesses the database in question and begins importing data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You will also be able to run scripts that require MyISAM, the other very popular MySQL engine, so you won’t need to configure any settings on the server. This will enable you to run a variety of scripts on a single physical server and to use it to its full potential.