InnoDB is a database engine for MySQL relational databases, which is used by popular open-source script-powered apps like Magento and Joomla v3. It’s ideal for scalable apps, because it performs amazingly well when handling immense amounts of data. Instead of locking the whole table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can execute much more tasks for the same length of time. Furthermore, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – rules that define how data inserts and updates should be handled. If a particular task has not been fully completed for any reason, the action will be rolled back. In this way, the information in the database will stay safe and sound and will not be partially mixed with newly imported content.

InnoDB in Cloud Website Hosting

You will be able to make use of any open-source script-driven software application that needs InnoDB in case you’ve got a Linux cloud website hosting with us, as the storage engine is available on our cutting-edge cloud web hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is needed. You can install apps which need the MyISAM engine without any obstacles as well and, again, the engine will be pre-selected, so you won’t have to edit any setting manually at any point. In addition, we’ll also create regular backups of all the databases that you have in the shared account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

You can install a script-driven web app that requires InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our innovative cloud hosting platform where the MySQL database storage engine is installed. A new MySQL database can be created in two separate ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our 1-click app installer tool. Either way, the needed engine will be picked automatically once the application’s installation begins, so you will not have to change anything manually, no matter if the app needs InnoDB or the more frequently used MyISAM. In addition, we will always be able to restore any of your MySQL databases in case you remove one by accident, as we perform several backups every day, each of which is kept for one whole week.

InnoDB in VPS Servers

If our custom-built Hepsia hosting Control Panel is chosen during the signup process for a new VPS web hosting plans , InnoDB will be installed on the VPS server together with other required software, so you won’t have to do anything if you decide to run script-powered applications that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be activated as well. You can create a new database and begin installing the application manually or through our 1-click installer. The system will automatically recognize the engine that the particular application needs and will set it for the specific MySQL database, so the installation will continue impeccably and the app can insert its data into that database. Therefore, you can activate apps with different requirements with regard to the MySQL engine without making any changes on your Virtual Private Server.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options which you can pick on the server configuration page when you buy a dedicated server from our company. Since this is the most powerful type of website hosting, it is rather likely that you will run popular sites that will attract lots of individuals, and since InnoDB is one of the very best options for such sites, we will activate it together with all the other software applications that are available with a Hepsia-managed server. When you create a brand new MySQL database in your account, there won’t be any activated database storage engine until you begin installing an open-source PHP script, whether manually through your Internet browser or using the automatic script installer that is included in the hosting Control Panel. The needed engine will be recognized and will be set for that database, so you can activate scripts that require InnoDB, as well as ones that need MyISAM, the default MySQL engine, without running into any problem.