InnoDB is a MySQL database storage engine, which has been gaining in popularity in recent years, because it provides a much better overall performance and an improved crash recovery compared to the default engine used by the MySQL DBMS – MyISAM. InnoDB is preferred by plenty of developers that write scalable software applications, due to the fact that it works much better with huge data volumes, while it keeps the server processing load low. Moreover, it uses row-level locking if any information should be edited, while lots of other engines lock the entire database table and therefore require much more time to process several successive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed successfully for whatever reason, the operation is rolled back to avoid scrambling or losing data. Magento and the newest editions of Joomla are two instances of widely used PHP script-powered software applications that have switched over to InnoDB.

InnoDB in Shared Hosting

Any PHP script-driven web application that needs InnoDB will run flawlessly on our cutting-edge cloud website hosting platform and the MySQL storage engine comes with all our shared hosting packages. Each 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 on the basis of the app’s requirements without the need to change any setting in your account. InnoDB will be chosen automatically for any app that requires this specific engine and you will be able to take advantage of its full capacity. We’ll create daily backups of your content, so if you unintentionally delete a MySQL database that is important to you or you overwrite some part of it, we will be able to restore your content the way it was only several hours ago.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database from the hosting Control Panel offered with each of our semi-dedicated server accounts and you start installing a PHP script-based app either manually or using our single-click app installer, the storage engine for the MySQL database will be selected automatically on the basis of the prerequisites of the app in question. As InnoDB is available on the cloud website hosting platform where your new account will be created, it will be set as the default engine for any app that requires it without the need for any manual intervention on your end at any time. To avoid any chance of losing information if you update an application or if you erase a database by accident, we will generate backups of all your MySQL databases each day, so if anything goes wrong, we can retrieve your data.

InnoDB in VPS Servers

In case our in-house developed Hepsia hosting Control Panel is chosen during the signup process for a new VPS web hosting plans , InnoDB will be activated on the VPS server along with other required pieces of software, so you won’t need to do anything if you choose to activate PHP-based applications that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated as well. You can create a brand-new MySQL database and begin installing the application manually or through our single-click installer tool. The system will recognize which engine the application in question needs and will set it for the specific MySQL database, so the installation process will proceed flawlessly and the app can insert its data into that database. Therefore, you can activate applications with various prerequisites concerning the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Servers

InnoDB is available by default with all dedicated web hosting plans ordered with the Hepsia hosting Control Panel. It’s included in the default software package that will be installed on all Hepsia-managed servers, so as soon as your physical machine is up and running, you will be able to log in and to install any type of PHP script-driven web app that needs this MySQL database storage engine. If you create a new database via the hosting Control Panel, there won’t be any active engine until you start installing an app. As soon as the app configuration wizard begins inserting information into the newly created database, the engine will be set automatically on the basis of the specific app’s prerequisites, so you can use both InnoDB and MyISAM without the need to select either one of them specifically at any time. Therefore, you can use an extensive selection of applications for your websites.