InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it provides a significantly better overall performance and an improved crash recovery in comparison to the default engine used by the MySQL database management system – MyISAM. InnoDB is preferred by plenty of developers that create scalable applications, since it works much better with huge data volumes, while it keeps the server processing load low. Also, it uses row-level locking if any information should be modified, while many other engines lock the entire database table and hence need much more time to perform several sequential tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for some reason, the action is rolled back to prevent confusion or the loss of data. Magento and the newest releases of Joomla™ are two examples of famous PHP-powered applications that have shifted over to InnoDB.

InnoDB in Web Hosting

While InnoDB is either not offered or it is a paid upgrade with other web hosting companies, it is part of the default set of features that we offer with our web hosting plans. In case you’d like to use a PHP script-driven application that needs InnoDB specifically, in order to be installed and to work properly, you will not face any obstacles as the storage engine is available on our in-house developed cloud Internet hosting platform. No matter if you set up a new MySQL database and install an app manually or use our one-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the given application requires it rather than MyISAM. Besides the remarkable crash recovery that InnoDB is offering, we also perform regular database backups, so we can quickly recover any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you will be able to take advantage of all the features of this storage engine with any open-source script-powered app that requires it. It’s among the engines that we have on our cloud website hosting platform, so the one that will be selected depends on the prerequisites of the specific app. You will not need to do anything manually to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click app installer tool. To be on the safe side, we will keep regular database backups, so if something goes wrong after an upgrade or if you erase some content accidentally, we’ll be able to get your database back to the way it was on any of the previous 7 days.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you’ll be able to take advantage of any open-source script-powered software application that needs this particular storage engine without needing to install anything manually. You can pick Hepsia on the VPS order form and your new VPS server will be up and running within 1 hour, so you can sign in and begin setting up your sites right away. When you set up a brand new MySQL database and start the app installation process, our system will select the engine for that MySQL database automatically. In this way, you can install various apps at the same time without having to configure anything on the VPS server. You can create a WordPress blog that uses the default MySQL engine – MyISAM, and a Magento-powered shopping portal that uses InnoDB, for example.

InnoDB in Dedicated Servers

All Linux dedicated web hosting plans that are ordered with our in-house developed Hepsia Control Panel come with a software package that’s pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you will not need to activate it manually in case you want to run scripts that require 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 receives access to the database in question and starts inserting data into it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You will also be able to run scripts that require the other very popular MySQL engine, MyISAM, so you won’t have to edit any settings on the dedicated server. This will permit you to activate a variety of scripts on one single physical machine and to use it to its full capacity.