InnoDB is a storage engine for MySQL databases, which is used by widely used script-based software apps such as Magento and Joomla 3. It is excellent for scalable apps, as it performs unbelievably well when handling large volumes of data. Instead of locking the entire database table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can process a lot more tasks for the same length of time. Additionally, InnoDB offers a much better crash recovery and supports database transactions and foreign keys – a set of rules that define how data inserts and updates should be treated. If a given operation hasn’t been entirely completed for whatever reason, the action will be rolled back. In this way, the content in the database will be kept intact and will not be partially merged with new content.

InnoDB in Cloud Hosting

While InnoDB is either not available or a paid upgrade with many hosting companies, it’s included in the default set of features that we are offering with our cloud hosting plans. If you would like to make use of a PHP script-powered application that needs InnoDB particularly, in order to be installed and to work correctly, you will not have any obstacles since the database engine is available on our custom-built cloud platform. No matter if you create a brand-new database and activate an app manually or use our one-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the given application needs InnoDB rather than MyISAM. Besides the amazing database failure recovery offered by InnoDB, we also perform regular database backups, so we can easily restore any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database from the hosting Control Panel coming with all our semi-dedicated server plans and you begin installing a PHP script-powered software app either manually or using our 1-click application installer, the MySQL database storage engine will be selected automatically depending on the given app’s prerequisites. Since InnoDB is available on the cloud web hosting platform where your new account will be created, it will be set as the default engine for each application that needs it without the need for any manual action on your end at any moment. To prevent any risk of losing data if you update an application or if you delete a database by accident, we’ll perform backups of all your databases each and every day, so if anything goes wrong, we can retrieve your data.

InnoDB in VPS Web Hosting

In case our custom-built Hepsia Control Panel is selected during the registration process for your new Linux VPS web hosting packages , InnoDB will be activated on the Virtual Private Server along with other needed software, so you will not need to do anything if you choose to install PHP-powered web applications that need this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can create a brand-new MySQL database and start installing the application manually or using our single-click installer. The system will automatically detect which engine the app in question requires and will set it for the specific MySQL database, so the installation will continue impeccably and the app can import its content into that database. Therefore, you can run applications with various requirements in regard to the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Servers Hosting

All Linux dedicated servers hosting packages ordered with our custom-developed Hepsia hosting Control Panel come with a software bundle that’s pre-installed and among everything else, you will get the InnoDB database engine, so you will not have to install it manually in case you’d like to run open-source PHP scripts that require it. All it takes to install such a script is to create a new MySQL database and to start the setup – as soon as the setup wizard accesses the database and starts entering data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You’ll also be able to install scripts that require MyISAM, the other very popular MySQL engine, so you will not have to change any settings on the server. This will allow you to use a variety of scripts on a single physical machine and to use the latter to its fullest potential.