InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it offers a significantly better overall performance and an improved database failure recovery in comparison to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is endorsed by plenty of web developers that write scalable web applications, because it works much better with huge data volumes, while it keeps the server processing load at a minimum. Additionally, it locks only a single database row in case any information should be updated, while lots of other engines lock the entire table and hence require more time to accomplish multiple consecutive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – in case the entire data modification cannot be completed successfully for some reason, the operation is rolled back to avoid scrambling or data loss. Magento and the latest Joomla™ editions are two instances of popular open-source script-driven software applications which have switched to InnoDB.

InnoDB in Hosting

Any PHP-based app that needs InnoDB will function flawlessly on our advanced cloud website hosting platform and the MySQL database engine comes with all our hosting packages. Each time you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will make use of will be selected on the basis of the app’s prerequisites without having to change any setting in your shared hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to make the most of its full potential. We will create regular backups of your content, so in case you accidentally erase a MySQL database that is important to you or you overwrite certain parts of it, we will be able to restore your content the way it was only a few hours ago.

InnoDB in Semi-dedicated Servers

You can run a script-driven web application that requires InnoDB with any of our semi-dedicated server packages, since all the accounts are created on our cutting-edge cloud web hosting platform where the database engine is installed. A new MySQL database can be set up in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you use our one-click app installer tool. In either case, the required engine will be chosen automatically as soon as the activation of the app begins, so you won’t have to change anything manually, regardless of whether the app requires InnoDB or the more regularly used MyISAM. In addition, we will always be able to restore any of your databases if you unintentionally remove one, as we generate a couple of database backups every day, each of which is saved for 1 whole week.

InnoDB in VPS Servers

If our custom Hepsia Control Panel is chosen during the registration process for your new VPS plans , InnoDB will be activated on the server together with other essential software, so you will not have to do anything if you choose to install script-driven apps that need this MySQL database storage engine. The default MySQL engine, MyISAM, will be installed as well. You can create a brand-new MySQL database and begin the app installation procedure manually or through our single-click installation tool. The system will detect the engine that the particular application requires and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the application can insert its data into that database. Thus, you can make use of applications with various requirements in regard to the MySQL engine without the need to make any changes on your VPS server.

InnoDB in Dedicated Servers

InnoDB is included by default with all dedicated servers that are ordered with the Hepsia hosting Control Panel. It is an essential part of the standard software package that we install on all Hepsia-equipped servers, so as soon as your machine is ready, you’ll be able to log in and to install any open-source script-driven app that needs this particular database engine. If you create a new database through the hosting Control Panel, there won’t be any active engine until you start installing an application. Once the app configuration wizard starts dumping content in the newly created database, the engine will be picked automatically based on the requirements of the given app, so you can use both MyISAM and InnoDB without selecting either one explicitly at any time. In this way, you can make use of a large range of applications for your sites.