InnoDB is a storage engine for MySQL databases, which is used by well known PHP script-powered software applications like Magento and Joomla 3.x. It’s perfect for scalable applications, as it works exceptionally well when managing immense amounts of data. Rather than locking the whole database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can process a lot more operations for the same period of time. Additionally, InnoDB offers a much faster database crash recovery and supports transactions and foreign keys – rules that define how data inserts and updates should be handled. If a given task hasn’t been entirely completed for some reason, the action will be rolled back. In this way, the information in the database will stay undamaged and won’t be partially mixed with newly imported content.

InnoDB in Cloud Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosting providers, it’s an essential part of the standard set of services that we’re offering with our cloud hosting plans. If you wish to make use of a PHP script-based web application that requires InnoDB particularly, in order to be activated and to perform correctly, you won’t encounter any problems as the storage engine is available on our in-house developed cloud platform. Irrespective of whether you set up a new MySQL database and activate an app manually or take advantage of our single-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the given app needs it rather than MyISAM. In addition to the remarkable crash recovery that InnoDB offers, we also perform daily backups of all databases, so we can easily restore any database in your shared account.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server accounts and you begin installing a PHP-based software app either manually or using our single-click app installer, the storage engine for the database will be set automatically depending on the given app’s requirements. Since InnoDB is available on the cloud website hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any app that requires it without the need for any manual intervention on your end at any point. To avoid any risk of losing info if you update an app or if you erase a database by mistake, we’ll carry out backups of all your MySQL databases each and every day, so if anything happens, we can recover your content.

InnoDB in VPS Servers

In case our in-house developed Hepsia Control Panel is picked during the signup process for a new VPS web hosting plans , InnoDB will be activated on the server together with other needed software, so you won’t need to do anything if you decide to install script-driven web applications that need this MySQL database engine. MyISAM, the default MySQL engine, will be installed as well. You can create a brand new database and start the app installation manually or using our one-click installer tool. The system will detect the engine that the application in question needs and will assign it to the specific database, so the installation will continue flawlessly and the app can insert its content into that database. Thus, you can run applications with different requirements in regard to the MySQL engine without having to make any modifications on your Virtual Private Server.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom-built Hepsia hosting Control Panel come with a software bundle that is pre-installed and among everything else, you will get the InnoDB database storage engine, so you won’t need to install it manually if you’d like to run open-source PHP scripts that require it. All it takes to install such a script is to create a new MySQL database and to start the setup process – as soon as the script configuration wizard accesses the database in question and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to run scripts that require the other very popular MySQL engine, MyISAM, so you won’t need to change any settings on the dedicated server. This will allow you to activate different scripts on a single physical machine and to use the latter to its full capacity.