InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it offers a much better overall performance and a faster database crash recovery compared to the default engine used by the MySQL DBMS – MyISAM. InnoDB is endorsed by lots of programmers that write highly scalable software applications, because it works better with enormous data volumes, while it keeps the server load at a minimum. What’s more, it locks only a single row in the database if anything should be modified, whereas lots of other engines lock the entire table and thus need more time to handle multiple successive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed for any reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the latest versions of Joomla are two examples of widely used PHP-based web apps which have switched to InnoDB.
InnoDB in Shared Web Hosting
InnoDB is offered with all our Linux shared web hosting by default, not upon request or as a paid upgrade, so you can install and manage any open-source script-based software app that requires the MySQL database storage engine without any obstacles as soon as you activate your account. InnoDB will be pre-selected as the default engine for a given database during the app activation process, regardless of whether you make use of our single-click installation tool or create the MySQL database and set up the application manually, as long as the application requires it instead of the more famous MyISAM engine. We will maintain daily backups of all your MySQL databases, so you can be sure that you will never lose any data in case you erase a database by accident or you overwrite some vital info – you will simply need to alert us and we’ll restore everything back to normal.
InnoDB in Semi-dedicated Servers
You can run a PHP script-based application that requires InnoDB with any of our semi-dedicated server packages, as all the accounts are set up on our advanced cloud web hosting platform where the database engine is installed. A new database can be created in two ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you make use of our single-click app installer. In either case, the needed engine will be chosen automatically the moment the installation of the application starts, so you will not have to update anything manually, regardless of whether the application needs InnoDB or the more frequently used MyISAM. On top of that, we will always be able to retrieve any of your MySQL databases if you unintentionally delete one, as we generate a couple of backups every day, each of which is preserved for 1 whole week.
InnoDB in VPS Servers
If you get a VPS server from our company, you will be able to make use of our in-house developed Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will permit you to install any open-source script-driven software application which needs InnoDB, as this particular database storage engine is an essential part of the software bundle that will be installed on your Virtual Private Server during its setup. When you set up a brand new database through the hosting Control Panel, you simply need to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine given that the application in question requires it, so you will not need to do anything else in your account. Similarly, if a certain app requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Servers
When you acquire a new dedicated server, you will be able to pick one of the 3 hosting Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to enable this database engine manually to be able to manage PHP script-driven web apps that need it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the system resources that you need in order to manage large-size sites, it is quite likely that you’ll use InnoDB. You will be able to make use of other engines as well, so if a particular application needs MyISAM rather than InnoDB, you will not have any obstacle while managing it. The engine that will be used will be recognized automatically the moment the app installation procedure begins, so you won’t need to tweak any settings manually at any moment.