InnoDB is a popular database storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has a number of strong sides which make it the engine of choice for numerous script-based apps, among them Joomla™ and Magento, which have moved to InnoDB permanently. For instance, adding immense volumes of data will be much faster with InnoDB, as it locks only one row to carry out a particular task, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is tackled. Simply put, adding new or modifying existent data will either be thoroughly completed, or will be canceled and the operation will be rolled back in case a given issue appears in the meantime, so the content that remains in the database won’t be lost.

InnoDB in Shared Web Hosting

You will be able to run any PHP script-powered web application that requires InnoDB in case you have a shared web hosting with us, as the storage engine is present on our innovative cloud website hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably in case this engine is needed. You can activate apps which use the MyISAM engine without having any difficulty as well and, once again, the engine will be selected automatically, so you won’t have to change anything manually at any time. In addition, we’ll also make daily backups of all the databases that you’ve got in the shared account, so if you erase or overwrite anything, we can easily restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

If you set up a new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server plans and you start installing a script-driven web app either manually or using our single-click app installer, the storage engine for the MySQL database will be picked automatically depending on the prerequisites of the given app. Since InnoDB is available on the cloud platform where your new semi-dedicated account will be set up, it will be set as the default engine for each application that needs it without any manual action required on your end at any point. To avoid any risk of losing data if you update an application or if you remove a database by mistake, we will perform backups of all your databases every day, so if something happens, we can retrieve your content.

InnoDB in Dedicated Web Hosting

If you obtain a new dedicated server, you will be able to choose one of the 3 Control Panels that we offer – cPanel, DirectAdmin and Hepsia. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to activate this MySQL storage engine manually so as to be able to run PHP script-powered web applications that need it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the system resources that you need to manage large-size websites, it’s rather likely that you will use InnoDB. You’ll be able to make use of other engines too, so if a particular app requires MyISAM rather than InnoDB, you won’t run into any problem while using it. The engine that will be used will be recognized automatically as soon as the app installation process begins, so you will not need to update any setting manually whatsoever.