InnoDB is a MySQL database storage engine, which has been gaining in popularity lately, as it offers a significantly better overall performance and an improved crash recovery in comparison to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by numerous developers that run scalable applications, as it works much better with huge volumes of data, while it keeps the server processing load low. In addition, it it locks only one row in the database in case any info should be modified, while many other engines lock the entire table and therefore need more time to execute several successive tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the modification of the entire data cannot be completed successfully for some reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the latest versions of Joomla are two examples of popular script-driven web apps that have switched over to InnoDB.

InnoDB in Cloud Hosting

You’ll be able to make use of any open-source script-based software app that needs InnoDB in case you’ve got a cloud hosting service with our company, as the database storage engine is present on our leading-edge cloud platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can activate applications which need the MyISAM engine without any problems as well and, once again, the engine will be selected automatically, so you won’t need to edit anything manually at any time. In addition, we’ll also create daily backups of all the databases that you’ve got in the shared hosting account, so if you delete or overwrite anything, we can easily restore it the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

You can make use of a script-driven web application that needs InnoDB with any of our semi-dedicated server packages, due to the fact that all the accounts are set up on our advanced cloud platform where the storage engine is installed. A new database can be created in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our single-click application installer. In either case, the needed engine will be selected automatically as soon as the installation of the app begins, so you won’t have to modify anything manually, regardless of whether the app requires InnoDB or the more widely used MyISAM. Furthermore, we will always be able to recover any of your MySQL databases if you remove one by accident, as we generate several backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS Servers

If you obtain a VPS server from our company, you will be able to take advantage of our custom-built Hepsia hosting Control Panel to manage your content. A Hepsia-managed VPS will allow you to use any PHP script-driven software application that needs InnoDB, as the MySQL database engine is part of the standard software bundle that will be installed on your VPS server during its setup. When you set up a brand-new MySQL database using the Control Panel, you’ll just have to begin installing an application – manually or using our app installer tool. InnoDB will be set as the default engine as long as the application in question needs it, so you won’t need to do anything else in your account. In the same manner, if a given application requires MyISAM, it will be automatically set as the default engine for this particular database.

InnoDB in Dedicated Servers

All Linux dedicated service ordered with our custom Hepsia Control Panel come with a software package 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’d like to activate open-source PHP scripts that need it. All it takes to run such a script is to create a new database and to start the installation – as soon as the script configuration wizard gains access to the database in question and begins inserting content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You will also be able to run scripts that need MyISAM, the other popular MySQL engine, so you won’t need to modify any settings on the server. This will permit you to activate various scripts on a single machine and to use the latter to its fullest capabilities.