InnoDB is a storage engine for MySQL databases, which is used by popular script-driven software apps like Joomla v3 and Magento. It is excellent for scalable apps, since it performs stunningly well when processing enormous data volumes. Rather than locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can handle a lot more operations for the same period of time. Moreover, InnoDB offers a much better database failure recovery and supports transactions and foreign keys – rules that determine how data imports and modifications should be handled. In case a certain task has not been fully completed for some reason, the action will be rolled back. Thus, the database content will be kept intact and won’t be partially mixed with newly appended content.

InnoDB in Semi-dedicated Servers

You can make use of a script-based app that needs InnoDB with all of our semi-dedicated server plans, as all the accounts are created on our advanced cloud web hosting platform where the MySQL storage engine is installed. A new database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you make use of our one-click app installer. In either case, the required engine will be chosen automatically the moment the app’s activation begins, so you will not have to configure anything manually, irrespective of whether the application needs InnoDB or the more commonly used MyISAM. In addition, we’ll always be able to recover any of your databases if you remove one by accident, as we perform a couple of MySQL database backups every day, each of which is stored for seven days.

InnoDB in VPS Servers

When you get a VPS server from us, you will be able to take advantage of our custom-built Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will allow you to use any open-source script-driven web application that needs InnoDB, as this particular storage engine is part of the software bundle that will be installed on the VPS server during its configuration. When you create a new MySQL database via the hosting Control Panel, you’ll just have to start installing an application – manually or using our app installer tool. InnoDB will be set as the default engine given that the application in question requires it, so you won’t need to do anything else in your account. In the same manner, if an app requires MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the options which you can choose on the order page when you buy a dedicated server from our company. As this is the most powerful type of website hosting, it is quite likely that you will manage highly popular websites that will attract many visitors, and since InnoDB is one of the best options for such websites, we will activate it along with all the other software applications that are available with a Hepsia-managed dedicated server. If you set up a new database in your dedicated server account, there won’t be any activated MySQL database engine until you start installing a PHP script, whether manually through your web browser or using the automatic script installer that is integrated into the hosting Control Panel. The needed engine will be detected automatically and will be assigned to the database in question, so you can activate scripts that need InnoDB, as well as ones that need MyISAM, the default MySQL engine, without encountering any problem.