InnoDB is a MySQL database engine, which has been gaining in popularity lately, because it provides a significantly better overall performance and a faster database failure recovery compared with the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by numerous web developers that build highly scalable software applications, as it works more effectively with huge amounts of data, while it keeps the server processing load low. Additionally, it it locks only one row in the database in case anything should be modified, while lots of other engines lock the entire database table and hence need more time to carry out multiple sequential tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification process cannot be completed for some reason, the operation is rolled back to prevent scrambling or losing data. Magento and the latest versions of Joomla are two examples of popular PHP-powered web applications which have moved to InnoDB.

InnoDB in Shared Hosting

Any script-based software app that needs InnoDB will run flawlessly on our cutting-edge cloud platform and the MySQL database storage engine is available with all our shared hosting packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected based on the app’s specifications without having to change any setting in your web hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to make the most of its full capacity. We will store regular content backups, so in case you unintentionally erase a MySQL database that’s important to you or you overwrite a specific part of it, we will be able to restore your database the way it was only a few hours ago.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the hosting Control Panel coming with all our semi-dedicated server plans and you start installing a script-powered application either manually or using our single-click application installer tool, the storage engine for the MySQL database will be picked automatically on the basis of the prerequisites of the specific app. As InnoDB is available on the cloud platform where your new account will be set up, it will be set as the default engine for each app that requires it without any manual intervention required on your end at any point. To prevent any chance of losing data if you update an application or if you remove a database by mistake, we will carry out backups of all your MySQL databases every day, so if anything goes wrong, we can rescue your content.

InnoDB in VPS Servers

In case our custom-developed Hepsia hosting Control Panel is picked during the registration process for a new VPS plans , InnoDB will be activated on the Virtual Private Server together with other necessary software, so you won’t have to do anything if you choose to manage PHP script-powered applications that need this MySQL database engine. MyISAM, the default MySQL engine, will be installed as well. You can create a brand-new MySQL database and begin the app installation procedure manually or using our single-click installer. The system will automatically detect the engine that the particular app needs and will assign it to the specific database, so the installation will proceed flawlessly and the application can enter its content into that database. In this way, you can activate apps with different prerequisites about the MySQL engine without making any modifications on your VPS server.

InnoDB in Dedicated Servers

When you buy a new dedicated server, you will be able to select one of the 3 hosting Control Panels offered by our company – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you won’t have to activate this MySQL database storage engine manually in order to be able to run PHP script-powered applications that require it. InnoDB is used for scalable apps and since a dedicated server will give you all the server resources that you need in order to manage very large websites, it is rather likely that you’ll resort to InnoDB. You will be able to use other engines too, so in case a specific app needs MyISAM instead of InnoDB, you will not have any complication while managing it. The engine that will be used will be detected automatically when the app installation commences, so you won’t have to update any setting manually at any time.