InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it provides a significantly better overall performance and a faster database crash recovery compared to the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is used by lots of developers that create highly scalable applications, as it works much better with enormous data volumes, while it keeps the server processing load at a minimum. Also, it locks only a single row in the database in case anything should be modified, whereas lots of other engines lock the entire database table and therefore need more time to fulfill several successive tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed for some reason, the operation is rolled back to prevent scrambling or data loss. Magento and the newest Joomla™ editions are two examples of widely used script-powered software applications that have switched to InnoDB.

InnoDB in Shared Hosting

You can make use of any PHP script-powered software app that needs InnoDB in case you’ve got a shared hosting plan with our company, as the database storage engine is present on our cutting-edge cloud website hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can activate apps which need the MyISAM engine without any problem as well and, once again, the engine will be selected automatically, so you will not need to change any setting manually at any point. What’s more, we’ll also carry out regular backups of all the MySQL databases that you’ve got in your shared web hosting account, so if you erase or overwrite something, we can easily get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

If you create a new MySQL database through the hosting Control Panel provided with all our semi-dedicated server plans and you begin installing a PHP-driven software app either manually or using our single-click application installer, the storage engine for the database will be set automatically on the basis of the requirements of the particular app. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any app that requires it without the need for any manual intervention on your end at any point. To prevent any risk of losing info if you update an app or if you remove a database unintentionally, we’ll make backups of all your MySQL databases every day, so if anything goes wrong, we can rescue your data.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house built Hepsia hosting Control Panel include a software package that is pre-activated and among everything else, you will get the InnoDB database storage engine, so you won’t need to add it manually if you want to use scripts that require it. All it takes to use such a script is to set up a new MySQL database and to begin the installation – once the script setup wizard acquires access to the database in question and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the particular script. You will also be able to activate scripts that need MyISAM – the other popular MySQL engine, so you won’t need to update any settings on the server. This will enable you to use different scripts on a single machine and to use the latter to its full potential.