InnoDB is a popular database storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got many advantages which have made it the preferred engine for numerous open-source script-based web applications, including Magento and Joomla, which have moved to InnoDB permanently. For example, importing enormous data volumes will be much faster with InnoDB, due to the fact that it locks only a single row to accomplish a certain task, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the information is tackled. Put simply, adding new or updating existent data will either be fully completed, or will be annulled and the operation will be rolled back if some problem appears in the meantime, which is why the content that remains in the database will not be damaged.

InnoDB in Cloud Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many other website hosting service providers, it is an essential part of the default set of services that we are offering with our cloud web hosting packages. In case you’d like to make use of a PHP-based web app that requires InnoDB particularly, in order to be activated and to work correctly, you will not have to deal with any impediments as the database engine is available on our custom cloud hosting platform. Regardless of whether you set up a new MySQL database and activate an application manually or make use of our 1-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective app needs InnoDB rather than MyISAM. Besides the amazing database failure recovery that InnoDB is offering, we also perform regular backups of all databases, so that we can swiftly restore any MySQL database in your shared account.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting ordered with our in-house built Hepsia Control Panel come with a software package that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you will not have to add it manually if you need to use open-source PHP scripts that require it. All it takes to use such a script is to create a new MySQL database and to initiate the installation – once the script installation wizard accesses the database in question and starts importing content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You’ll also be able to activate scripts that need MyISAM, the other popular MySQL engine, so you won’t need to edit any settings on the dedicated server. This will enable you to install a variety of scripts on one single server and to use it to its maximum capacity.