InnoDB is a popular database storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has a lot of strengths which have made it the engine of choice for a lot of open-source script-powered web applications, such as Joomla and Magento, which have shifted over to InnoDB for good. For example, adding huge amounts of data will be much faster with InnoDB, because it locks only one database row to carry out a specific operation, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is treated. In simpler words, importing new or editing existing data will either be fully completed, or will be canceled and the operation will be rolled back if a certain problem occurs during the process, so the content that remains in the database won’t be lost.

InnoDB in Shared Web Hosting

While InnoDB is either not offered or it is a paid upgrade with other web hosts, it’s part of the standard set of services offered with our shared web hosting packages. In case you wish to make use of a PHP script-driven software app that needs InnoDB specifically, in order to be activated and to work properly, you will not have any obstacles since the MySQL database engine is available on our custom-developed cloud Internet hosting platform. Irrespective of whether you create a new database and install an app manually or take advantage of our single-click application installer software 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 outstanding crash recovery that InnoDB is offering, we also generate regular database backups, so that we can quickly recover any database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB is offered with each of our semi-dedicated plans by default, so once you order a new account, you can move on and activate any PHP-based software app that requires this particular database storage engine. A few engines are pre-installed on our cloud web hosting platform, so when you create a new database and begin installing an app manually, or decide to make use of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be set on the basis of the requirements of the app in question. This will allow you to install and manage InnoDB-specific apps without any impediments and without having to update any settings in your account. To avoid any risk, we will always have a one-week-old backup of all your databases, so if you delete or change any content unintentionally, we can quickly retrieve it.

InnoDB in VPS Servers

If our custom-developed Hepsia Control Panel is selected during the registration process for your new VPS hosting plans , InnoDB will be installed on the Virtual Private Server along with other essential pieces of software, so you will not need to do anything if you decide to make use of script-powered web apps that need this MySQL database engine. MyISAM, the default MySQL engine, will be installed too. You can create a new database and begin the app installation procedure manually or through our single-click installer tool. The system will detect which engine the particular application needs and will set it for the specific database, so the installation will proceed flawlessly and the application can dump its content in that database. Thus, you can manage apps with various requirements concerning the MySQL engine without the need to make any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

All Linux dedicated web hosting plans that are ordered with our custom-developed Hepsia hosting Control Panel come with a software package that is pre-activated and besides everything else, you will get the InnoDB database storage engine, so you won’t have to activate it manually if you wish to use PHP scripts that require it. All it takes to install such a script is to create a new MySQL database and to begin the setup – once the installer wizard accesses the database in question and begins entering 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 run scripts that require MyISAM, the other popular MySQL engine, so you won’t have to configure any settings on the dedicated server. This will enable you to use a variety of scripts on one single physical server and to use it to its fullest capacity.