InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, as it provides a significantly better overall performance and a faster database failure recovery in comparison to the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is used by a lot of programmers that create highly scalable software applications, since it works much more efficiently with enormous volumes of data, while it keeps the server load at a minimum. Moreover, it locks only one database row in case any information should be edited, while many other engines lock the entire database table and hence need more time to perform several consecutive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification procedure cannot be completed successfully for any reason, the operation is rolled back to prevent confusion or data loss. Magento and the latest Joomla™ versions are two instances of widespread script-driven web apps that have switched over to InnoDB.

InnoDB in Shared Hosting

Every open-source script-based software application that requires InnoDB will run flawlessly on our advanced cloud website hosting platform and the MySQL database storage engine is offered with all our shared hosting plans. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected in accordance with the app’s prerequisites without the need to change any setting in your web hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you will be able to take advantage of its full capacity. We’ll store regular content backups, so in case you unintentionally delete a database that you need or you overwrite a certain part of it, we’ll be able to restore your database the way it was just a couple of hours ago.

InnoDB in Semi-dedicated Servers

InnoDB is included with each of our semi-dedicated servers by default, so as soon as you obtain a new semi-dedicated account, you can move on and install any PHP-based web application that requires this particular storage engine. A few engines are pre-installed on our cloud web hosting platform, so when you set up a new database and start installing an app manually, or opt to use the Hepsia Control Panel-integrated app installer, the engine for the database will be set depending on the requirements of the specific application. This will permit you to activate and manage InnoDB-specific apps without running into any problem and without needing to update any settings in your account. To avoid any risk, we’ll always keep a one-week-old backup of all your databases, so if you remove or edit any content by accident, we can quickly rescue it.

InnoDB in VPS Servers

In case our in-house built Hepsia hosting Control Panel is selected during the signup process for a new VPS plans , InnoDB will be activated on the server along with other necessary pieces of software, so you will not need to do anything if you decide to manage PHP script-based web apps that require this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can set up a brand new database and begin the app installation manually or using our one-click installer tool. The system will automatically detect which engine the particular application needs and will assign it to the specific database, so the installation process will proceed impeccably and the application can dump its data in that database. Therefore, you can make use of applications with different prerequisites about the MySQL engine without making any changes on your VPS.

InnoDB in Dedicated Servers

If you get a new dedicated server, you’ll be able to choose one of the 3 hosting Control Panels that we offer – cPanel, DirectAdmin and Hepsia. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to activate this database storage engine manually to be able to manage PHP script-driven software apps that need it. InnoDB is used by scalable applications and since a dedicated server will offer you all the resources that you need to manage large-scale sites, it’s quite possible that you’ll resort to InnoDB. You will be able to make use of other engines as well, so in case a given application requires MyISAM rather than InnoDB, you will not have any complication while running it. The engine that will be used will be automatically detected the moment the app installation procedure begins, so you won’t have to update any setting manually at any moment.