InnoDB is a popular storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has got lots of advantages that have made it the engine of choice for numerous PHP script-based software apps, including Joomla™ and Magento, which have switched to InnoDB permanently. For instance, adding immense volumes of data will be faster with InnoDB, because it locks only a single database row to complete a particular task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is treated. In simpler words, importing new or modifying existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if a certain problem appears during the process, therefore the content that remains in the database will not be damaged.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with other hosting providers, it’s an essential part of the standard set of services that we offer with our shared hosting packages. In case you’d like to make use of an open-source script-driven web app that requires InnoDB particularly, in order to be installed and to operate correctly, you won’t face any impediments as the MySQL storage engine is available on our custom cloud Internet hosting platform. Regardless of whether you create a new database and install an application manually or use our 1-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular app requires InnoDB rather than MyISAM. Besides the excellent database failure recovery that InnoDB offers, we also store regular database backups, so that we can easily restore any database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database through the Control Panel provided with each of our semi-dedicated server accounts and you begin installing a PHP-driven software application either manually or using our single-click app installer tool, the storage engine for the MySQL database will be selected automatically on the basis of the requirements of the particular application. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any app that needs it without any manual intervention required on your end at any point. To avoid any chance of losing info if you update an application or if you delete a database accidentally, we will generate a backup of all your databases every day, so if something happens, we can recover your data.

InnoDB in VPS Web Hosting

All Linux VPS web hosting packages that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you will be able to make use of any PHP script-driven software app that needs the database engine without needing to set up anything manually. You can pick Hepsia on the VPS configuration page and your new server will be up and running within the hour, so you can log in and begin setting up your sites right away. When you create a brand new database and start the app installation process, our system will choose the engine for that database automatically. In this way, you can run different apps at the same time without having to update anything on the Virtual Private Server. You can set up a WordPress online blog that uses the default MySQL engine – MyISAM, and a Magento-driven web store that uses InnoDB, for instance.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting ordered with our custom-built Hepsia hosting Control Panel come with a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB database storage engine, so you won’t need to activate it manually in case you wish to run open-source PHP scripts that require it. All it takes to use such a script is to create a new MySQL database and to start the installation – once the script setup wizard gains access to the database in question and begins importing data 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 need the other very popular MySQL engine – MyISAM, so you won’t need to modify any settings on the server. This will enable you to activate different scripts on one single machine and to use the latter to its fullest capacity.