InnoDB is a MySQL storage engine, which has been gaining popularity lately, as it provides a significantly better overall performance and a faster database crash recovery in comparison to the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is used by lots of developers that build scalable web applications, since it works more effectively with large data volumes, while it keeps the server processing load low. Furthermore, it locks only one database row in case anything should be modified, while lots of other engines lock the entire database table and hence require much more time to execute multiple sequential tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – if the entire data modification process cannot be completed successfully for some reason, the action is rolled back to prevent confusion or the loss of data. Magento and the latest versions of Joomla are two examples of famous open-source script-based software apps that have shifted over to InnoDB.

InnoDB in Shared Hosting

You will be able to run any script-powered application that requires InnoDB in case you’ve got a Linux shared hosting service with us, as the database storage engine is available on our avant-garde cloud hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is needed. You can install applications that require the MyISAM engine without any difficulty as well and, again, the engine will be pre-selected, so you will not have to modify any setting manually at any point. In addition, we’ll also carry out daily backups of all the databases that you’ve got in the shared web hosting account, so in case you erase or overwrite something, we can easily restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

You can run a script-powered web app that needs InnoDB with any of our semi-dedicated server plans, because all the accounts are set up on our advanced cloud web hosting platform where the MySQL database storage engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you take advantage of our one-click application installer tool. Either way, the required engine will be selected automatically once the application’s installation begins, so you won’t need to update anything manually, no matter if the app needs InnoDB or the more widely used MyISAM. Also, we’ll always be able to recover any of your MySQL databases if you erase one by accident, as we perform several backups every day, each of which is stored for one week.

InnoDB in VPS Servers

If our custom-built Hepsia Control Panel is selected during the signup process for a new VPS servers , InnoDB will be activated on the VPS server together with other essential pieces of software, so you will not have to do anything if you decide to install open-source script-driven web apps that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated too. You can set up a new database and begin the app installation process manually or through our one-click installation tool. The system will detect which engine the particular application needs and will set it for the specific MySQL database, so the installation will continue flawlessly and the app can import its data into that database. In this way, you can make use of applications with various prerequisites concerning the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Servers

All dedicated servers ordered with our in-house built Hepsia Control Panel include a software package that’s pre-installed and besides everything else, you will get the InnoDB database storage engine, so you won’t have to activate it manually in case you’d like to run open-source PHP scripts that require it. All it takes to activate such a script is to create a new database and to initiate the setup – once the script installation wizard receives access to the database and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You’ll also be able to run scripts that need MyISAM – the other popular MySQL engine, so you won’t have to change any settings on the server. This will allow you to run various scripts on a single machine and to use it to its maximum potential.