InnoDB is a popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has got a lot of advantages which have made it the engine of choice for lots of open-source script-driven web applications, among them Magento and Joomla™, which have switched to InnoDB permanently. For example, adding large amounts of data will be faster with InnoDB, because it locks only one row to carry out a certain 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 treated. In simpler words, adding new or updating existing data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case some problem occurs during the process, so the content that remains in the database won’t be damaged.

InnoDB in Cloud Website Hosting

While InnoDB is either not offered or it is a paid upgrade with other web hosting providers, it’s an essential part of the default set of features that we are offering with our cloud website hosting packages. If you want to use an open-source script-driven web application that needs InnoDB in particular, in order to be installed and to work correctly, you won’t encounter any problems as the MySQL database engine is available on our in-house developed cloud hosting platform. Irrespective of whether you create a brand-new MySQL database and install an app 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 particular app needs it rather than MyISAM. In addition to the incredible database failure recovery offered by InnoDB, we also perform regular database backups, so that we can swiftly recover any MySQL database in your shared account.

InnoDB in Dedicated Web Hosting

All dedicated web hosting ordered with our custom Hepsia Control Panel include a software bundle that is pre-installed and among everything else, you will get the InnoDB database engine, so you will not need to install it manually if you would like to activate open-source scripts that need it. All it takes to install such a script is to create a new MySQL database and to start the installation – once the installation wizard receives access to the database in question and starts importing data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the particular script. You’ll also be able to run scripts that require the other widely used MySQL engine – MyISAM, so you will not have to change any settings on the server. This will enable you to run different scripts on a single server and to use it to its fullest potential.