InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it offers a better overall performance and an improved database crash recovery compared with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by lots of developers that build scalable web apps, since it works more efficiently with huge amounts of data, while it keeps the server processing load at a minimum. Additionally, it locks only a single database row in case anything should be updated, while many other engines lock the entire database table and hence require much more time to fulfill several sequential tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification process cannot be completed successfully for whatever reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the newest versions of Joomla are two instances of popular open-source script-powered software apps which have shifted over to InnoDB.

InnoDB in Hosting

Any open-source script-based app that needs InnoDB will run flawlessly on our cutting-edge cloud website hosting platform and the database engine is available with all our hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected based on the app’s prerequisites without the need to modify any setting in your web hosting account. InnoDB will be picked automatically for any app that requires this specific engine and you’ll be able to get the most out of its full potential. We will keep daily content backups, so in case you accidentally delete a MySQL database that you need or you overwrite a certain part of it, we’ll be able to restore everything the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database through the Control Panel provided with each of our semi-dedicated server accounts and you start installing a script-driven software app either manually or using our one-click application installer, the storage engine for the MySQL database will be picked automatically based on the requirements of the given app. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any application that requires it without the need for any manual intervention on your end at any time. To prevent any chance of losing data if you update an app or if you remove a database by mistake, we will generate a backup of all your MySQL databases each day, so if something happens, we can restore your content.

InnoDB in VPS Hosting

If our in-house built Hepsia hosting Control Panel is selected during the signup process for a new Linux VPS hosting packages , InnoDB will be activated on the Virtual Private Server along with other needed pieces of software, so you will not need to do anything if you choose to manage open-source script-powered software apps that require this MySQL storage engine. The default MySQL engine – MyISAM, will be installed too. You can create a new MySQL database and start installing the app manually or through our 1-click installer. The system will recognize which engine the app in question needs and will assign it to the specific database, so the installation will proceed impeccably and the app can dump its content in that database. In this way, you can manage applications with various prerequisites in regard to the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Web Hosting

When you acquire a new dedicated server, you will be able to pick any of the three hosting Control Panels offered by us – Hepsia, cPanel and DirectAdmin. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not have to install this database engine manually so as to be able to use PHP script-based web applications that need it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the resources that you need in order to run large-scale websites, it’s pretty likely that you will resort to InnoDB. You’ll be able to use other engines as well, so in case a given application requires MyISAM rather than InnoDB, you won’t run into any complication while using it. The engine that will be used will be automatically recognized the moment the app installation process begins, so you won’t have to tweak any setting manually at any point.