InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it offers a much better overall performance and an improved database failure recovery in comparison with the default engine used by the MySQL DBMS – MyISAM. InnoDB is used by plenty of developers that create scalable applications, as it works much better with immense data volumes, while it keeps the server processing load at a minimum. Also, it it locks only one row in the database if any info should be modified, whereas lots of other engines lock the entire database table and therefore need more time to perform several sequential tasks. Last, but not least, InnoDB complies with a set of "all-or-nothing" rules – if the entire data modification process cannot be completed successfully for any reason, the action is rolled back to avoid confusion or the loss of data. Magento and the newest versions of Joomla are two examples of popular PHP script-based web apps that have switched to InnoDB.

InnoDB in Shared Hosting

While InnoDB is either not offered or it is a paid upgrade with many web hosting providers, it’s an integral part of the default set of features that we offer with our shared hosting plans. In case you’d like to make use of a script-based web application that requires InnoDB specifically, in order to be installed and to work correctly, you won’t have to deal with any difficulties because the MySQL storage engine is available on our custom-developed cloud hosting platform. Irrespective of whether you create a brand new database and activate an app manually or make use of our single-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the particular application requires InnoDB rather than MyISAM. In addition to the remarkable database crash recovery that InnoDB offers, we also perform daily database backups, so we can swiftly recover any MySQL database in your shared website hosting account.

InnoDB in Semi-dedicated Servers

You can activate a script-driven app that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are created on our advanced cloud web hosting platform where the MySQL storage engine is installed. A new MySQL database can be set up in two different ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our one-click application installer tool. In either case, the required engine will be selected automatically once the application’s activation starts, so you won’t need to update anything manually, regardless of whether the application requires InnoDB or the more widely used MyISAM. On top of that, we will always be able to restore any of your databases if you remove one by mistake, as we perform several MySQL database backups every day, each of which is saved for seven days.

InnoDB in VPS Servers

All VPS plans that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you’ll be able to use any PHP script-powered app that requires this particular database engine without having to activate anything manually. You can choose Hepsia on the VPS order form and your brand-new Virtual Private Server will be up and running within one hour, so you can log in and begin setting up your Internet sites straight away. Once you set up a new database and start the app activation process, our system will set the engine for that database automatically. Thus, you can manage various applications simultaneously without changing anything on the Virtual Private Server. You can create a WordPress weblog that makes use of MyISAM – the default MySQL engine, and a Magento-based e-commerce site that uses the InnoDB engine, for instance.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house developed Hepsia Control Panel come with a software bundle that is pre-activated and besides everything else, you will get the InnoDB database storage engine, so you will not need to install it manually in case you would like to run scripts that require it. All it takes to activate such a script is to set up a new database and to initiate the setup – as soon as the script installation wizard gets access to the database in question and starts entering 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’ll also be able to run scripts that need MyISAM – the other widely used MySQL engine, so you will not have to configure any settings on the dedicated server. This will permit you to use various scripts on a single physical machine and to use it to its full capabilities.