InnoDB is a popular database storage engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has plenty of upsides which make it the engine of choice for a lot of PHP script-powered web apps, such as Joomla™ and Magento, which have shifted over to InnoDB for good. For example, importing immense volumes of data will be much faster with InnoDB, due to the fact that it locks only one row to carry out an operation, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is treated. Simply put, adding new or editing existing data will either be fully completed, or will be annulled and the procedure will be rolled back if a certain problem shows up in the meantime, hence the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with many other website hosting service providers, it is an essential part of the default set of services that we offer with our shared hosting plans. If you’d like to make use of a PHP-based software application that requires InnoDB particularly, in order to be activated and to perform properly, you will not have any difficulties because the database storage engine is available on our in-house developed cloud website hosting platform. Regardless of whether you create a brand new MySQL database and install an app manually or take advantage of our one-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific app requires it rather than MyISAM. Besides the exceptional crash recovery that InnoDB is offering, we also maintain daily database backups, so that we can quickly recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

All our semi-dedicated hosting plans come with InnoDB and you can take advantage of all the options offered by this MySQL database engine with any PHP-based app that requires it. InnoDB is one of the engines that we have on our cloud website hosting platform, so the one that will be used depends on the requirements of the particular app. You won’t need to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer. To avoid any risk, we will keep regular MySQL database backups, so if something goes wrong following some update or if you remove some data by accident, we’ll be able to get the database back to the way it was on any of the previous 7 days.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house developed Hepsia hosting Control Panel include a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to add it manually if you need to activate open-source PHP scripts that require it. All it takes to activate such a script is to create a new database and to initiate the setup – once the installation wizard accesses the database and starts importing content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the particular script. You’ll also be able to activate scripts that require the other popular MySQL engine, MyISAM, so you won’t need to change any settings on the server. This will permit you to use various scripts on one single physical server and to use the latter to its maximum capabilities.