InnoDB is a storage engine for MySQL relational databases, which is used by popular PHP script-based applications such as Joomla 3 and Magento. It’s perfect for scalable applications, because it performs astonishingly well when managing enormous data volumes. Rather than locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same period of time. Additionally, InnoDB offers an improved database crash recovery and supports transactions and foreign key constraints – rules that prescribe how data inserts and modifications should be handled. In case a given task has not been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will be preserved intact and will not be partially mixed with newly entered content.
InnoDB in Shared Hosting
Any open-source script-powered application that requires InnoDB will run flawlessly on our innovative cloud hosting platform and the MySQL storage engine is available with all our shared hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected based on the app’s prerequisites without having to configure any setting in your shared account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to get the most out of its full capacity. We’ll make regular content backups, so if you unintentionally erase a MySQL database that you need or you overwrite some part of it, we will be able to restore your content the way it was only a few hours ago.
InnoDB in Semi-dedicated Hosting
You can make use of a script-based web app that needs InnoDB with any of our semi-dedicated server plans, as all the accounts are set up on our innovative cloud platform where the 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 website hosting Control Panel, or automatically – when you take advantage of our single-click application installer tool. In either case, the needed engine will be selected automatically once the installation of the application begins, so you will not need to update anything manually, no matter if the app requires InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to recover any of your MySQL databases if you unintentionally delete one, as we create several MySQL database backups every day, each of which is stored for one week.
InnoDB in VPS Web Hosting
All Linux VPS web hosting packages that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you will be able to take advantage of any script-driven web app that needs this database engine without needing to install anything manually. You can pick Hepsia on the VPS order page and your brand new VPS server will be up and running within 1 hour, so you can sign in and start setting up your Internet sites straight away. Once you create a brand-new database and start the app installation process, our system will choose the engine for this MySQL database automatically. In this way, you can run different apps simultaneously without the need to configure anything on the Virtual Private Server. You can set up a WordPress-driven personal weblog that uses MyISAM – the default MySQL engine, and a Magento-driven Internet shop that makes use of the InnoDB engine, for instance.
InnoDB in Dedicated Servers Hosting
When you obtain a new dedicated server, you’ll be able to choose one of the 3 Control Panels offered by us – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to activate this MySQL storage engine manually in order to be able to manage script-based software apps that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you need to manage large-scale sites, it’s rather possible that you will use InnoDB. You will be able to use other engines as well, so if a certain app requires MyISAM rather than InnoDB, you won’t run into any impediment while running it. The engine that will be used will be detected automatically the moment the app installation process starts, so you won’t have to change any setting manually at any moment.