InnoDB is a database storage engine for MySQL databases, which is used by well known PHP-powered web applications like Magento and Joomla v3. It’s perfect for scalable applications, since it performs stunningly well when processing enormous data volumes. Instead of locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can handle much more operations for the same period of time. Also, InnoDB offers an improved database failure recovery and supports database transactions and foreign keys – rules that define how data inserts and modifications should be treated. In case a given operation has not been entirely completed for whatever reason, the action will be rolled back. In this way, the database content will be retained intact and won’t be partially mixed with new content.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database through the hosting Control Panel coming with each of our semi-dedicated server packages and you begin installing a PHP script-powered app either manually or using our single-click app installer tool, the MySQL database storage engine will be set automatically based on the prerequisites of the particular application. Since InnoDB is present on the cloud web hosting platform where your new account will be set up, it will be set as the default engine for each application that requires it without any manual intervention required on your end at any time. To avoid any chance of losing information if you update an application or if you remove a database unintentionally, we will perform backups of all your databases every day, so if anything goes wrong, we can rescue your data.

InnoDB in VPS Servers

If our custom-developed Hepsia Control Panel is picked during the signup process for your new VPS plans , InnoDB will be installed on the Virtual Private Server along with other essential pieces of software, so you will not have to do anything if you decide to run PHP-driven software apps that need this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated as well. You can create a brand-new MySQL database and start the app installation procedure manually or through our one-click installation tool. The system will automatically recognize which engine the app in question requires and will set it for the specific database, so the installation will proceed flawlessly and the app can insert its data into that database. Thus, you can use apps with various requirements about the MySQL engine without making any modifications on your VPS.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you’ll be able to pick one of the 3 Control Panels offered by us – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to activate this database storage engine manually to be able to run script-based web apps that require it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the resources that you need in order to run very large Internet sites, it’s rather possible that you will resort to InnoDB. You will be able to make use of other engines as well, so if a certain app needs MyISAM instead of InnoDB, you will not encounter any complication while using it. The engine that will be used will be recognized automatically as soon as the app installation begins, so you won’t have to edit any setting manually at any moment.