InnoDB is a storage engine for MySQL databases, which is used by widely used open-source script-based apps like Magento and Joomla 3.x. It’s excellent for scalable applications, as it performs really well when handling huge volumes of data. Rather than locking the entire table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can perform a lot more operations for the same length of time. Furthermore, InnoDB offers a better database crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and modifications should be handled. If a specific task hasn’t been entirely completed for some reason, the action will be rolled back. In this way, the content in the database will stay safe and sound and will not be partially mixed with newly inserted content.

InnoDB in Semi-dedicated Hosting

If you create a brand new MySQL database from the hosting Control Panel offered with each of our semi-dedicated server packages and you begin installing an open-source script-driven web app either manually or using our 1-click app installer tool, the storage engine for the MySQL database will be selected automatically on the basis of the requirements of the particular app. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that needs it without any manual action needed on your end at any point. To avoid any chance of losing information if you update an app or if you delete a database by accident, we will perform backups of all your databases each and every day, so if anything goes wrong, we can rescue your content.

InnoDB in VPS

If our custom-developed Hepsia hosting Control Panel is picked during the registration process for a new Linux virtual private servers , InnoDB will be installed on the Virtual Private Server along with other required software, so you will not have to do anything if you choose to install PHP script-driven web apps that require this MySQL database engine. The default MySQL engine, MyISAM, will be activated too. You can set up a new MySQL database and begin the app installation procedure manually or using our one-click installation tool. The system will recognize the engine that the particular app requires and will set it for the specific MySQL database, so the installation will proceed flawlessly and the app can enter its content into that database. In this way, you can install applications with various prerequisites regarding the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Hosting

All Linux dedicated hosting that are ordered with our custom Hepsia Control Panel include a software package that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you will not have to add it manually if you want to run PHP scripts that require it. All it takes to run such a script is to create a new database and to start the installation process – as soon as the installer wizard receives access to the database in question and starts entering data into it, InnoDB will be set as the default engine for this database on the condition that it is the one needed by the particular script. You will also be able to use scripts that need MyISAM, the other very popular MySQL engine, so you won’t need to edit any settings on the dedicated server. This will enable you to install a variety of scripts on one single physical server and to use the latter to its fullest capabilities.