InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it provides a much better overall performance and a faster database crash recovery compared with the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is used by a lot of programmers that create highly scalable apps, as it works better with large amounts of data, while it keeps the server load at a minimum. Moreover, it locks only one database row if any information should be modified, while many other engines lock the entire database table and thus need much more time to execute multiple consecutive tasks. Last, but not least, InnoDB observes the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed for some reason, the action is rolled back to avoid confusion or the loss of data. Magento and the latest editions of Joomla are two examples of popular PHP-driven web apps which have switched to InnoDB.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting providers, it is included in the default set of services that we’re offering with our cloud hosting packages. In case you would like to use an open-source script-driven web app that requires InnoDB specifically, in order to be installed and to perform correctly, you won’t face any obstacles since the InnoDB database storage engine is available on our in-house built cloud hosting platform. No matter if you create a brand-new database and install an application manually or make use of our one-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular app needs InnoDB rather than MyISAM. Besides the exceptional database crash recovery that InnoDB offers, we also generate regular database backups, so we can swiftly recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

If you set up a new MySQL database through the hosting Control Panel coming with all our semi-dedicated server plans and you start installing an open-source script-driven web application either manually or using our 1-click application installer tool, the database storage engine will be picked automatically on the basis of the specific app’s prerequisites. As InnoDB is present on the cloud platform where your new semi-dedicated account will be created, it will be set as the default engine for any app that needs it without any manual action required on your end at any point. To avoid any chance of losing information if you update an application or if you erase a database by accident, we will make backups of all your databases every day, so if anything happens, we can retrieve your data.

InnoDB in VPS Web Hosting

If you pick a virtual private server with our Hepsia Control Panel, the InnoDB storage engine will be an essential part of the software package that will be pre-installed on your VPS server before we give it to you. You will not have to set up anything manually and you’ll be able to install and run any script-driven application that needs InnoDB as soon as your Virtual Private Server is up and running, which takes no more than one hour after the order submission itself. A number of engines are available, so whenever you set up a database through the Hepsia Control Panel, a particular engine will be selected when the app activation process commences and our system will automatically recognize which engine is required by the app in question. If you need MyISAM, for example, you will not need to do anything different from installing the desired application, whether manually or using our app installer.

InnoDB in Dedicated Servers Hosting

All dedicated servers hosting ordered with our custom-developed Hepsia Control Panel come with a software bundle that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not need to install it manually if you need to run scripts that need it. All it takes to use such a script is to set up a new database and to initiate the setup – as soon as the script setup wizard gains access to the database and starts dumping content in it, InnoDB will be set as the default engine for this database provided that it is the one required by the script. You will also be able to activate scripts that require the other popular MySQL engine – MyISAM, so you won’t have to update any settings on the server. This will permit you to run a variety of scripts on a single physical server and to use it to its fullest capacity.