InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, because it provides a much better overall performance and a faster database crash recovery compared to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by a lot of developers that write highly scalable software apps, due to the fact that it works much more efficiently with huge amounts of data, while it keeps the server load low. Also, it uses row-level locking in case any information should be updated, whereas many other engines lock the entire database table and thus need much more time to fulfill multiple sequential tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed successfully for any reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla versions are two instances of widespread PHP script-driven software apps which have switched to InnoDB.

InnoDB in Cloud Hosting

You’ll be able to install any script-powered app that requires InnoDB if you have a cloud hosting with our company, as the MySQL storage engine is present on our avant-garde cloud platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is required. You can install apps that use the MyISAM engine without having to deal with any problem as well and, again, the engine will be selected automatically, so you won’t have to configure anything manually at any point. In addition, we’ll also generate daily backups of all the MySQL databases that you’ve got in the shared web hosting account, so if you delete or overwrite something, we can easily restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

If you create a brand-new MySQL database from the Control Panel included with all our semi-dedicated server plans and you start installing a PHP script-based web application either manually or using our one-click application installer, the MySQL database storage engine will be set automatically on the basis of the prerequisites of the particular app. Since InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for each app that requires it without any manual intervention needed on your end at any moment. To avoid any risk of losing info if you update an app or if you erase a database by mistake, we will generate a backup of all your databases each and every day, so if anything goes wrong, we can restore your content.

InnoDB in VPS Servers

In case our custom-built Hepsia hosting Control Panel is selected during the signup process for a new VPS servers , InnoDB will be activated on the VPS server together with other necessary pieces of software, so you won’t need to do anything if you decide to run script-based apps that need this MySQL database engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a brand-new database and begin installing the app manually or through our single-click installer tool. The system will detect which engine the app in question requires and will assign it to the specific database, so the installation will proceed flawlessly and the app can dump its content in that database. In this way, you can activate applications with different requirements in regard to the MySQL engine without making any changes on your VPS.

InnoDB in Dedicated Servers

All dedicated servers that are ordered with our custom Hepsia Control Panel include a software bundle that’s pre-installed and among everything else, you will get the InnoDB database storage engine, so you will not need to activate it manually in case you wish to run scripts that need it. All it takes to run such a script is to set up a new database and to begin the installation process – once the installation wizard gains access to the database in question and begins entering data into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You’ll also be able to use scripts that need the other very popular MySQL engine, MyISAM, so you won’t need to edit any settings on the server. This will permit you to activate different scripts on a single machine and to use it to its full capacity.