InnoDB is a database storage engine for MySQL databases, which is used by well known PHP-driven web applications such as Magento and Joomla™ 3. It is excellent for scalable apps, as it performs amazingly well when handling large data volumes. Rather than locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same period of time. Furthermore, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – a set of rules that indicate how data imports and modifications should be treated. If a given operation hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will stay undamaged and will not be partially merged with newly appended content.

InnoDB in Shared Website Hosting

You’ll be able to install any PHP script-powered web application that needs InnoDB if you have a shared website hosting plan with our company, as the storage engine is available on our avant-garde cloud web hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably in case this engine is needed. You can run apps which use the MyISAM engine without encountering any problem as well and, again, the engine will be selected automatically, so you will not need to update anything manually at any time. Furthermore, we’ll also carry out daily backups of all the databases that you’ve got in your account, so in case you delete or overwrite something, we can easily get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

InnoDB is available with each of our semi-dedicated hosting plans by default, so the moment you purchase a new semi-dedicated account, you can go ahead and install any PHP script-driven app that requires this particular MySQL database storage engine. Several engines are installed on our cloud website hosting platform, so when you create a brand new database and begin installing an application manually, or decide to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be selected based on the prerequisites of the given application. This will permit you to install and manage InnoDB-specific apps without any difficulty and without editing any settings in your account. To be on the safe side, we will always have a seven-day-old backup of all your MySQL databases, so if you delete or change any content unintentionally, we can quickly recover it.

InnoDB in VPS Servers

If our in-house built Hepsia Control Panel is chosen during the registration process for a new VPS hosting plans , InnoDB will be installed on the VPS server along with other essential pieces of software, so you will not have to do anything if you choose to run PHP-driven software applications that need this MySQL database engine. The default MySQL engine, MyISAM, will be installed too. You can set up a brand-new database and begin the app installation manually or through our single-click installer tool. The system will automatically detect the engine that the particular application needs and will assign it to the specific MySQL database, so the installation process will proceed flawlessly and the application can dump its data in that database. In this way, you can manage applications with different prerequisites with regard to the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our in-house developed Hepsia Control Panel come with a software package that is pre-installed and besides everything else, you will get the InnoDB database storage engine, so you won’t have to activate it manually in case you need to run scripts that require it. All it takes to install such a script is to create a new MySQL database and to begin the installation process – once the setup wizard obtains access to the database in question and begins dumping content in it, InnoDB will be set as the default engine for this database as long as it is the one needed by the particular script. You’ll also be able to install scripts that require MyISAM, the other popular MySQL engine, so you will not need to configure any settings on the server. This will allow you to activate different scripts on one single physical server and to use it to its fullest capabilities.