InnoDB is a popular database storage engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has got lots of strong sides which make it the preferred engine for many PHP-based applications, such as Joomla™ and Magento, which have switched over to InnoDB for good. For example, adding immense data volumes will be faster with InnoDB, due to the fact that it locks only a single database row to perform a specific operation, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is tackled. In simpler words, importing new or updating existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case a certain issue shows up in the meantime, so the content that remains in the database will not be lost.

InnoDB in Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many other hosting service providers, it is part of the default set of features that we’re offering with our web hosting plans. In case you want to use a PHP script-driven software app that needs InnoDB particularly, in order to be activated and to perform correctly, you won’t have any obstacles because the InnoDB storage engine is available on our custom cloud hosting platform. No matter if you create a brand new database and activate an app manually or use our one-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the given application requires InnoDB instead of MyISAM. Besides the amazing database crash recovery that InnoDB is offering, we also maintain regular database backups, so that we can easily restore any database in your shared account.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-developed Hepsia Control Panel come with a software package that’s pre-installed and among everything else, you will get the InnoDB storage engine, so you won’t need to add it manually in case you need to use open-source PHP scripts that require it. All it takes to activate such a script is to create a new database and to begin the setup – as soon as the installation wizard receives access to the database in question and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You will also be able to use scripts that require the other widely used MySQL engine, MyISAM, so you will not need to modify any settings on the dedicated server. This will allow you to install a variety of scripts on a single physical machine and to use it to its maximum capacity.