InnoDB is a database engine for MySQL databases, which is used by widespread open-source script-powered web applications such as Magento and Joomla 3. It’s perfect for scalable applications, because it performs unbelievably well when managing huge volumes of data. Instead of locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same period of time. Besides, InnoDB offers a much better database failure recovery and supports transactions and foreign key constraints – rules that specify how data imports and modifications should be treated. In case a specific operation has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the information in the database will be kept undamaged and will not be partially mixed with newly appended content.

InnoDB in Shared Web Hosting

InnoDB is available with all our Linux shared web hosting service by default, not as a paid upgrade or upon request, so you will be able to install and run any PHP script-powered application which requires the database engine without any impediments as soon as you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app installation, regardless of whether you make use of our single-click installer or create the database and set up the application manually, provided that the application requires it instead of the more popular MyISAM engine. We’ll store regular backups of all your MySQL databases, so you can be certain that you will never lose any data if you delete a database accidentally or you overwrite some crucial info – you will just need to notify us and we will restore your content the way it was.

InnoDB in Semi-dedicated Servers

You can make use of a script-powered software app that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our leading-edge cloud hosting platform where the database storage engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you use our 1-click app installer tool. Either way, the needed engine will be picked automatically as soon as the application’s activation begins, so you won’t have to edit anything manually, regardless of whether the application needs InnoDB or the more regularly used MyISAM. In addition, we will always be able to recover any of your databases in case you remove one by mistake, as we perform several database backups every day, each of which is kept for 1 week.

InnoDB in VPS Servers

If our custom-developed Hepsia hosting Control Panel is chosen during the signup process for a new VPS servers , InnoDB will be activated on the server together with other needed pieces of software, so you won’t have to do anything if you choose to install script-driven apps that need this MySQL database engine. The default MySQL engine – MyISAM, will be activated too. You can create a brand new MySQL database and start installing the application manually or using our one-click installation tool. The system will recognize the engine that the particular application needs and will assign it to the specific database, so the installation will proceed impeccably and the application can insert its content into that database. Thus, you can activate apps with various prerequisites with regard to the MySQL engine without making any changes on your server.

InnoDB in Dedicated Servers

All dedicated servers ordered with our custom-built Hepsia Control Panel include a software bundle that is pre-activated and besides everything else, you will get the InnoDB storage engine, so you will not have to add it manually if you want to activate open-source PHP scripts that require it. All it takes to install such a script is to create a new database and to initiate the installation – once the script setup wizard acquires access to the database and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You’ll also be able to run scripts that require MyISAM, the other very popular MySQL engine, so you won’t have to edit any settings on the dedicated server. This will permit you to run a variety of scripts on one single machine and to use the latter to its maximum capacity.