InnoDB is a database storage engine for MySQL relational databases, which is used by widespread open-source script-driven applications like Joomla™ 3 and Magento. It is ideal for scalable applications, as it performs astonishingly well when processing immense amounts of data. Instead of locking the entire database table to import new information into a database as many other engines do, InnoDB locks only one row, so it can process much more tasks for the same length of time. Moreover, InnoDB offers a much faster database failure recovery and supports transactions and foreign key constraints – rules that determine how data imports and updates should be handled. If a specific task hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the database content will stay intact and will not be partially merged with newly added content.

InnoDB in Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it is an essential part of the default set of services offered with our website hosting plans. If you’d like to use an open-source script-driven application that needs InnoDB in particular, in order to be activated and to function properly, you won’t encounter any problems since the database engine is available on our custom-developed cloud Internet hosting platform. Irrespective of whether you create a brand-new MySQL database and activate an application manually or take advantage of our single-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the given app requires it rather than MyISAM. In addition to the remarkable database crash recovery offered by InnoDB, we also generate daily database backups, so that we can swiftly restore any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

You can make use of an open-source script-powered software app that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our leading-edge cloud hosting platform where the database storage engine is installed. A new MySQL database can be set up in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you use our single-click app installer. Either way, the needed engine will be selected automatically the moment the application’s installation begins, so you won’t have to change anything manually, regardless of whether the application requires InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases in case you erase one by accident, as we create a few backups every day, each of which is stored for 1 whole week.

InnoDB in VPS

If our in-house built Hepsia hosting Control Panel is chosen during the signup process for your new Linux VPS packages , InnoDB will be installed on the VPS server together with other necessary pieces of software, so you won’t need to do anything if you choose to use open-source script-driven software apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated too. You can create a new database and start the app installation manually or using our single-click installer tool. The system will recognize which engine the application in question requires and will assign it to the specific database, so the installation will proceed flawlessly and the app can enter its content into that database. Therefore, you can activate applications with different prerequisites regarding the MySQL engine without having to make any changes on your VPS.

InnoDB in Dedicated Hosting

InnoDB comes as standard with all dedicated servers hosting packages ordered with the Hepsia hosting Control Panel. It is included in the default software package that we install on all Hepsia-managed dedicated servers, so as soon as your physical machine is ready, you’ll be able to log in and to install any type of PHP script-driven web application that requires this particular MySQL database engine. When you set up a new MySQL database through the Control Panel, there won’t be any activated engine till you begin installing an application. Once the app configuration wizard begins entering content into the newly created database, the engine will be chosen automatically on the basis of the given app’s prerequisites, so you can use both InnoDB and MyISAM without selecting either of them specifically at any point. Therefore, you can use a wide variety of applications for your Internet sites.