InnoDB is a very popular database engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got lots of upsides which make it the engine of choice for many PHP-based software applications, including Joomla and Magento, which have shifted over to InnoDB permanently. For example, importing enormous volumes of data will be faster with InnoDB, as it locks only a single row to execute a task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the info is tackled. Simply put, importing new or updating existing data will either be entirely completed, or will be aborted and the procedure will be rolled back if a certain issue occurs in the meantime, hence the content that remains in the database will not be damaged.

InnoDB in Shared Hosting

While InnoDB is either not offered or it is a paid upgrade with many other web hosting companies, it is part of the default set of features that we are offering with our shared hosting plans. In case you wish to make use of a script-driven web application that requires InnoDB in particular, in order to be activated and to function properly, you will not face any problems as the MySQL database storage engine is available on our in-house developed cloud website hosting platform. Irrespective of whether you create a new database and activate an application manually or take advantage of our one-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the app needs InnoDB instead of MyISAM. Besides the exceptional database failure recovery offered by InnoDB, we also store daily backups of all databases, so we can swiftly restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers come with InnoDB and you can take full advantage of all the options offered by this database engine with any PHP-based software application that requires it. It is among the engines that are available on our cloud platform, so the one that will be picked depends on the particular app’s prerequisites. You will not have to do anything manually to activate InnoDB, as it will be set as the default engine whenever you install an application – whether manually or using our single-click app installer tool. To be on the safe side, we’ll store regular MySQL database backups, so if something goes wrong after some update or if you remove some content by accident, we’ll be able to get the database back to the way it was on any of the previous seven days.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be part of the standard software package that will be installed on your server before we hand it over to you. You won’t have to set up anything manually and you will be able to install and use any PHP script-based software app that needs InnoDB as soon as your VPS server is set up, which takes no more than 1 hour after the order submission process itself. A couple of engines are available, so whenever you create a database through the Hepsia Control Panel, a particular engine will be activated once the app installation process starts and our system will automatically recognize which engine is required by the application in question. If you have to use MyISAM, for example, you will not have to do anything different from installing the chosen application, whether manually or using our application installer.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our in-house developed Hepsia hosting Control Panel come with a software bundle that is pre-installed and among everything else, you will get the InnoDB storage engine, so you won’t have to add it manually if you want to activate scripts that need it. All it takes to activate such a script is to create a new MySQL database and to start the installation process – as soon as the setup wizard gets access to the database in question and begins inserting content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You will also be able to run scripts that require the other widely used MySQL engine, MyISAM, so you won’t have to configure any settings on the dedicated server. This will enable you to activate various scripts on one single server and to use the latter to its full capabilities.