InnoDB is a very popular database storage engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has numerous pluses that have made it the engine of choice for a lot of script-powered software apps, among them Joomla™ and Magento, which have switched to InnoDB permanently. For instance, importing enormous data volumes will be faster with InnoDB, since it locks only one database row to complete a given task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the information is treated. In simpler words, adding new or updating existing data will either be thoroughly completed, or will be aborted and the procedure will be rolled back in case a given issue occurs during the process, therefore the content that remains in the database will not be lost.

InnoDB in Cloud Hosting

You’ll be able to make use of any script-based web application that requires InnoDB in case you’ve got a cloud hosting plan with our company, as the MySQL database storage engine is available on our leading-edge cloud web hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly in case this engine is needed. You can run apps which use the MyISAM engine without any obstacles as well and, once again, the engine will be selected automatically, so you won’t have to edit any setting manually at any point. In addition, we’ll also create daily backups of all the MySQL databases that you’ve got in your shared account, so in case you erase or overwrite anything, we can quickly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the hosting Control Panel offered with all our semi-dedicated server plans and you start installing a PHP-powered application either manually or using our one-click application installer, the database storage engine will be picked automatically on the basis of the requirements of the specific application. As InnoDB is present on the cloud website hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that needs it without the need for any manual action on your end at any moment. To avoid any risk of losing data if you update an app or if you delete a database by mistake, we’ll make backups of all your databases each day, so if something goes wrong, we can recover your data.

InnoDB in Dedicated Servers

If you order a new dedicated server, you’ll be able to choose any of the 3 hosting Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Any server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to enable this storage engine manually so as to be able to use PHP script-powered web applications that require it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the server resources that you need to manage large-scale sites, it is quite likely that you will resort to InnoDB. You will be able to make use of other engines too, so in case a specific application needs MyISAM instead of InnoDB, you won’t encounter any impediment while managing it. The engine that will be used will be automatically recognized when the app installation process commences, so you won’t have to tweak any setting manually at any time.