InnoDB is a database engine for MySQL databases, which is used by widely used open-source script-driven software applications like Magento and Joomla v3. It is ideal for scalable apps, as it works exceptionally well when managing huge data volumes. Rather than locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can carry out a lot more operations for the same length of time. Furthermore, InnoDB offers a much faster database crash recovery and supports transactions and foreign key constraints – a set of rules that indicate how data imports and updates should be treated. If a specific operation has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will stay intact and won’t be partially merged with newly appended content.

InnoDB in Hosting

While InnoDB is either not offered or it is a paid upgrade with many hosting companies, it’s an essential part of the standard set of services that we are offering with our hosting plans. In case you would like to use a PHP script-powered software app that needs InnoDB particularly, in order to be installed and to perform correctly, you will not need to deal with any obstacles because the database storage engine is available on our in-house developed cloud hosting platform. No matter if you set up a brand new MySQL database and install an app manually or make use of our one-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective app needs InnoDB rather than MyISAM. In addition to the incredible database crash recovery offered by InnoDB, we also generate daily database backups, so that we can swiftly restore any MySQL database in your shared hosting account.

InnoDB in Semi-dedicated Servers

You can activate an open-source script-powered application that needs InnoDB with any of our semi-dedicated server plans, because all the accounts are created on our avant-garde cloud hosting platform where the MySQL database storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our single-click app installer. Either way, the required engine will be selected automatically the moment the application’s installation starts, so you will not need to modify anything manually, regardless of whether the app requires InnoDB or the more regularly used MyISAM. On top of that, we will always be able to recover any of your databases in case you delete one by accident, as we create a few MySQL database backups every day, each of which is stored for 1 whole week.

InnoDB in VPS Servers

If you get a VPS server from us, you will be able to take full advantage of our custom-developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will permit you to install any open-source script-powered application which needs InnoDB, as the MySQL database storage engine is an essential part of the standard software bundle that will be pre-installed on the Virtual Private Server during its creation. When you create a brand new MySQL database via the Control Panel, you just need to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine as long as the app in question requires it, so you won’t need to do anything else in your VPS account. Analogously, if a given app requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options that you can pick on the server order page when you buy a dedicated server from our company. Since this is the most powerful type of hosting, it is quite likely that you will manage popular websites that will attract a lot of people, and since InnoDB is one of the best choices for such sites, we’ll activate it together with all the other software apps that are offered with a Hepsia-managed server. If you set up a brand new MySQL database in your dedicated server account, there won’t be any active database storage engine till you begin installing a PHP script, whether manually via your web browser or using the automatic script installation tool that is included in the Control Panel. The required engine will be detected and will be assigned to that database, so you can use scripts that require InnoDB, as well as ones that need the default MySQL engine, MyISAM, without coming across any problem.