InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and an improved crash recovery in comparison with the default engine used by MySQL – MyISAM. InnoDB is endorsed by numerous programmers that build highly scalable apps, because it works more effectively with enormous amounts of data, while it keeps the server processing load at a minimum. Additionally, it locks only a single database row if anything should be modified, while many other engines lock the entire table and therefore need more time to carry out multiple consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification cannot be completed successfully for some reason, the operation is rolled back to prevent scrambling or data loss. Magento and the newest Joomla versions are two instances of widespread PHP script-powered web apps which have moved to InnoDB.
InnoDB in Shared Website Hosting
InnoDB is available with all our Linux shared website hosting by default, not as a paid upgrade or upon request, so you can activate and manage any script-powered software app that requires the MySQL database engine without any impediments once you open your shared hosting account. InnoDB will be selected automatically as the default engine for a specific database during the app installation, irrespective of whether you make use of our 1-click installer or create the database and install the application manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We will maintain regular backups of all your MySQL databases, so you can be certain that you will never lose any content if you erase a database by mistake or you overwrite some important info – you simply have to alert us and we will restore your database the way it was.
InnoDB in Semi-dedicated Hosting
You can make use of an open-source script-driven application that needs InnoDB with any of our semi-dedicated server plans, because all the accounts are set up on our leading-edge cloud platform where the 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 hosting Control Panel, or automatically – when you take advantage of our single-click app installer tool. In either case, the needed engine will be picked automatically once the activation of the application starts, so you will not need to update anything manually, regardless of whether the application requires InnoDB or the more widely used MyISAM. In addition, we will always be able to retrieve any of your MySQL databases in case you remove one by mistake, as we make several backups every day, each of which is preserved for 7 days.
InnoDB in Dedicated Web Hosting
If you obtain a new dedicated server, you will be able to pick any of the three Control Panels that we are offering – cPanel, Hepsia and DirectAdmin. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not have to add this database engine manually in order to be able to manage script-driven applications that require it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the system resources that you need in order to manage large-size sites, it is rather likely that you will resort to InnoDB. You’ll be able to use other engines as well, so if a specific app needs MyISAM instead of InnoDB, you won’t experience any problem while managing it. The engine that will be used will be recognized automatically once the app installation process commences, so you will not need to fine-tune any setting manually whatsoever.