InnoDB is a storage engine for MySQL databases, which is used by famous script-based applications like Joomla™ 3 and Magento. It’s perfect for scalable applications, as it excels in managing immense data volumes. Instead of locking the entire table to enter new information into 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. What’s more, InnoDB offers an improved crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and updates should be handled. In case a given task has not been thoroughly completed for any reason, the action will be rolled back. In this way, the information in the database will be preserved safe and sound and won’t be partially mixed with newly imported content.

InnoDB in Shared Web Hosting

You can activate any PHP-driven web app that requires InnoDB if you have a shared web hosting service with us, as the MySQL database storage engine is present on our innovative cloud hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is needed. You can run apps which need the MyISAM engine without the need to deal with any obstacle as well and, again, the engine will be selected automatically, so you will not have to configure anything manually at any point. In addition, we’ll also make daily backups of all the databases that you’ve got in the shared hosting account, so in case you delete or overwrite something, we can swiftly restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

All our Linux semi-dedicated servers come with InnoDB and you will be able to make the most of all the options offered by this database storage engine with any PHP script-driven software application that needs it. It is one of the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the given app’s prerequisites. You will not have to do anything manually to enable InnoDB, as it will be set as the default engine when you install an app – whether manually or using our one-click app installer. To avoid any risk, we’ll maintain regular database backups, so if something goes wrong following some update or if you remove some content by mistake, we will be able to get your database back to the way it was on any of the past seven days.

InnoDB in VPS Servers

In case our custom-developed Hepsia Control Panel is chosen during the registration process for a new VPS servers , InnoDB will be installed on the VPS server together with other essential software, so you won’t have to do anything if you choose to make use of open-source script-based web applications that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed as well. You can create a new database and start installing the app manually or using our single-click installer tool. The system will detect which engine the particular app needs and will assign it to the specific database, so the installation process will continue flawlessly and the app can import its data into that database. Thus, you can install applications with different requirements in regard to the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom-developed Hepsia hosting Control Panel include a software package that is pre-activated and among everything else, you’ll get the InnoDB database engine, so you will not need to add it manually in case you wish to use PHP scripts that need it. All it takes to activate such a script is to create a new MySQL database and to begin the setup – once the installation wizard obtains access to the database in question and starts importing data into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You’ll also be able to use scripts that require MyISAM, the other popular MySQL engine, so you won’t need to modify any settings on the dedicated server. This will enable you to activate a variety of scripts on a single physical server and to use it to its full capacity.