InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it offers a significantly better overall performance and a faster crash recovery compared to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is preferred by a lot of developers that build scalable software applications, because it works better with immense data volumes, while it keeps the server processing load low. Additionally, it locks only one database row in case anything should be edited, whereas many other engines lock the entire database table and thus require more time to handle several sequential tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification process cannot be completed successfully for any reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the latest versions of Joomla™ are two instances of famous PHP script-driven apps which have switched to InnoDB.

InnoDB in Hosting

While InnoDB is either a paid upgrade or it is not available at all with other hosting service providers, it is an integral part of the default set of features that we are offering with our hosting plans. In case you want to use a PHP script-based web application that requires InnoDB in particular, in order to be installed and to work correctly, you will not experience any difficulties since the InnoDB database engine is available on our in-house built cloud website hosting platform. Regardless of whether you set up a brand-new MySQL database and activate an application manually or take advantage of our 1-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the application requires InnoDB instead of MyISAM. Besides the excellent crash recovery offered by InnoDB, we also generate daily backups of all databases, so that we can swiftly restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database through the Control Panel provided with all our semi-dedicated server plans and you begin installing a script-driven software app either manually or using our one-click application installer, the database storage engine will be picked automatically on the basis of the specific app’s requirements. As InnoDB is present on the cloud hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that needs it without the need for any manual intervention on your end at any moment. To prevent any risk of losing info if you update an app or if you remove a database by mistake, we will perform a backup of all your databases every day, so if something happens, we can rescue your data.

InnoDB in VPS Servers

In case our in-house developed Hepsia Control Panel is selected during the signup process for a new VPS servers , InnoDB will be activated on the Virtual Private Server along with other necessary pieces of software, so you will not need to do anything if you decide to use PHP script-based software applications that need this MySQL storage engine. MyISAM – the default MySQL engine, will be activated as well. You can create a new database and begin the app installation manually or using our 1-click installation tool. The system will automatically recognize the engine that the application in question requires and will set it for the specific database, so the installation process will proceed flawlessly and the application can import its content into that database. In this way, you can make use of applications with various prerequisites with regard to the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom Hepsia hosting Control Panel include a software package that is pre-installed and besides everything else, you will get the InnoDB database storage engine, so you will not need to activate it manually in case you would like to activate open-source PHP scripts that need it. All it takes to activate such a script is to create a new database and to begin the setup process – as soon as the script setup wizard accesses the database in question and begins inserting content into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You’ll also be able to activate scripts that require the other popular MySQL engine – MyISAM, so you won’t need to update any settings on the server. This will permit you to activate a variety of scripts on a single physical server and to use it to its maximum potential.