InnoDB is a database engine for MySQL relational databases, which is used by widely used PHP-driven web applications like Magento and Joomla v3. It’s perfect for scalable applications, because it works very well when processing immense amounts of data. Instead of locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same period of time. In addition, InnoDB offers a much better database crash recovery and supports database transactions and foreign key constraints – a set of rules that determine how data inserts and modifications should be treated. If a given task has not been fully completed for some reason, the action will be rolled back. Thus, the database content will be retained undamaged and won’t be partially mixed with new content.
InnoDB in Shared Hosting
While InnoDB is either not offered or it is a paid upgrade with many web hosting companies, it is an integral part of the default set of features that we’re offering with our shared hosting plans. If you want to make use of an open-source script-driven web app that needs InnoDB particularly, in order to be activated and to function correctly, you won’t face any obstacles because the database engine is available on our custom cloud Internet hosting platform. Regardless of whether you set up a brand new database and install an application manually or make use of our single-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the given application requires InnoDB rather than MyISAM. In addition to the exceptional crash recovery that InnoDB is offering, we also generate daily database backups, so we can quickly restore any MySQL database in your shared account.
InnoDB in Semi-dedicated Hosting
You can install a script-driven web app that needs InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are set up on our innovative cloud web hosting platform where the MySQL storage engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our one-click app installer. In either case, the needed engine will be picked automatically once the activation of the application begins, so you won’t need to update anything manually, regardless of whether the app needs InnoDB or the more widely used MyISAM. On top of that, we will always be able to retrieve any of your databases in case you remove one by mistake, as we generate a couple of backups every day, each of which is preserved for one whole week.
InnoDB in VPS Web Hosting
When you buy a virtual private server from our company, you’ll be able to use our custom Hepsia hosting Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will permit you to run any open-source script-driven web app which requires InnoDB, as this MySQL storage engine is an integral part of the software package that will be installed on your VPS server during its setup. When you set up a brand new MySQL database through the Control Panel, you simply need to start installing an app – manually or using our app installer tool. InnoDB will be set as the default engine on the condition that the application in question needs it, so you won’t have to do anything else in your account. In the same manner, if a certain app requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.
InnoDB in Dedicated Servers Hosting
If you buy a new dedicated server, you will be able to select any of the 3 Control Panels that we offer – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t need to add this MySQL database engine manually to be able to manage open-source script-based applications that need it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the system resources that you require in order to manage very large sites, it’s rather likely that you’ll use InnoDB. You will be able to use other engines as well, so in case a particular app requires MyISAM rather than InnoDB, you will not need to deal with any impediment while running it. The engine that will be used will be detected automatically once the app installation starts, so you will not have to tweak any setting manually whatsoever.