InnoDB is a very popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got numerous advantages that make it the engine of choice for a lot of PHP-powered web applications, such as Magento and Joomla, which have switched over to InnoDB for good. For instance, adding enormous volumes of data will be faster with InnoDB, as it locks only a single row to accomplish a specific task, not the entire table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is tackled. Simply put, appending new or modifying existing data will either be fully completed, or will be aborted and the operation will be rolled back in case a certain problem shows up in the meantime, so the content that remains in the database will not be lost.

InnoDB in Shared Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it is an integral part of the standard set of services that we offer with our shared website hosting plans. If you wish to make use of a PHP-driven software application that requires InnoDB particularly, in order to be installed and to operate correctly, you will not have to deal with any difficulties because the MySQL database storage engine is available on our in-house built cloud Internet hosting platform. No matter if you create a brand-new database and activate an application manually or take advantage of our single-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the specific app requires it instead of MyISAM. Besides the amazing crash recovery that InnoDB is offering, we also maintain regular database backups, so that we can swiftly recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB is available with each of our semi-dedicated plans by default, so the moment you obtain a new semi-dedicated account, you can go ahead and activate any PHP-powered software application that needs the MySQL database storage engine. A couple of engines are installed on our cloud website hosting platform, so when you create a brand-new MySQL database and begin installing an application manually, or decide to use the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be set on the basis of the requirements of the specific application. This will permit you to install and run InnoDB-specific apps without running into any problem and without needing to change any settings in your account. To take no chances, we will always keep a seven-day-old backup of all your databases, so if you remove or edit any content by mistake, we can easily recover it.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom-built Hepsia hosting Control Panel include a software package that’s pre-installed and besides everything else, you will get the InnoDB storage engine, so you will not need to activate it manually if you would like to activate scripts that need it. All it takes to run such a script is to set up a new database and to start the setup process – once the script configuration wizard gains access to the database in question and starts dumping data in it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You’ll also be able to run scripts that require the other widely used MySQL engine, MyISAM, so you will not need to update any settings on the dedicated server. This will allow you to run a variety of scripts on a single machine and to use it to its full capacity.