InnoDB is a database engine for MySQL databases, which is used by famous open-source script-driven software applications such as Magento and Joomla v3. It’s perfect for scalable applications, since it works astonishingly well when managing enormous volumes of data. Instead of locking the entire database table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can process much more operations for the same period of time. Moreover, InnoDB offers a faster crash recovery and supports database transactions and foreign keys – rules that specify how data imports and modifications should be handled. In case a given operation hasn’t been fully completed for some reason, the action will be rolled back. Thus, the information in the database will remain safe and sound and will not be partially merged with newly imported content.

InnoDB in Shared Web Hosting

While InnoDB is either not available or a paid upgrade with many other web hosts, it’s an integral part of the standard set of services offered with our shared web hosting plans. If you’d like to use a PHP script-driven app that needs InnoDB in particular, in order to be installed and to function correctly, you will not encounter any problems as the storage engine is available on our custom-developed cloud hosting platform. Regardless of whether you create a brand new MySQL database and install an app manually or make use of our 1-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application requires InnoDB instead of MyISAM. Besides the incredible crash recovery that InnoDB is offering, we also store daily database backups, so that we can quickly recover any database in your shared hosting account.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated plans support InnoDB and you can make the most of all the features offered by this storage engine with any open-source script-driven web app that needs it. It’s one of the engines that we have on our cloud hosting platform, so the one that will be used depends on the given app’s prerequisites. You will not have to do anything manually in order to enable InnoDB, because it will be set as the default engine when you install an application – whether manually or using our 1-click app installer tool. To be on the safe side, we’ll store daily backups of all your MySQL databases, so if anything goes wrong following an update or if you erase some content by mistake, we will be able to get the database back to the way it was on any of the previous seven days.

InnoDB in VPS Servers

In case our custom-developed Hepsia hosting Control Panel is chosen during the registration process for a new VPS plans , InnoDB will be activated on the Virtual Private Server along with other necessary software, so you won’t need to do anything if you choose to activate script-based web applications that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a new database and start installing the application manually or using our 1-click installation tool. The system will recognize which engine the app in question requires and will set it for the specific MySQL database, so the installation process will proceed flawlessly and the application can enter its data into that database. Therefore, you can activate apps with different prerequisites in regard to the MySQL engine without the need to make any changes on your server.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the features that you can select on the server order page when you purchase a dedicated server from us. Since this is the most powerful type of web hosting, it is pretty likely that you will manage very popular sites that will draw plenty of individuals, and since InnoDB is among the best options for such sites, we will enable it along with all the other software apps that are available with a Hepsia-equipped dedicated server. If you create a brand new database in your dedicated account, there won’t be any active storage engine until you begin installing a script, whether manually through your Internet browser or using the automatic scripts installer that is integrated into the Control Panel. The needed engine will be recognized and will be set for that database, so you can make use of scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without encountering any difficulty.