InnoDB is a very popular database engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has a lot of strengths which make it the engine of choice for many script-based software applications, such as Joomla and Magento, which have shifted over to InnoDB permanently. For instance, adding huge amounts of data will be faster with InnoDB, as it locks only a single database row to execute an operation, not the entire database table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the information is handled. Simply put, adding new or editing existent data will either be fully completed, or will be aborted and the procedure will be rolled back if a given problem occurs during the process, so the content that remains in the database will not be damaged.
InnoDB in Web Hosting
Every PHP-based application that requires InnoDB will function impeccably on our innovative cloud platform and the database engine is offered with all our web hosting packages. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s specifications without having to edit any setting in your web hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you’ll be able to make the most of its full capacity. We will maintain regular backups of your content, so if you accidentally erase a MySQL database that is important to you or you overwrite a certain part of it, we will be able to restore the database the way it was just a few hours ago.
InnoDB in Semi-dedicated Hosting
You can make use of a PHP script-powered software application that requires InnoDB with any of our semi-dedicated server plans, because all the accounts are set up on our innovative cloud platform where the MySQL database storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you take advantage of our single-click application installer. Either way, the needed engine will be chosen automatically the moment the activation of the app begins, so you will not need to edit anything manually, no matter if the application needs InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases in case you accidentally delete one, as we perform a few backups every day, each of which is saved for 1 whole week.
InnoDB in VPS Hosting
If you get a virtual private server from our company, you’ll be able to use our in-house built Hepsia Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will allow you to use any script-based software application which needs InnoDB, as the MySQL database engine is an essential part of the software package that will be installed on the Virtual Private Server during its setup. When you create a brand-new database via the hosting Control Panel, you’ll just need to start installing an application – manually or using our application installer. InnoDB will be set as the default engine on the condition that the app in question requires it, so you will not have to do anything else in your VPS account. Identically, if an app needs MyISAM, it will be automatically set as the default engine for this specific database.
InnoDB in Dedicated Web Hosting
If you purchase a new dedicated server, you will be able to pick one of the 3 hosting Control Panels that we are offering – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not need to add this MySQL storage engine manually in order to be able to run PHP-driven software applications that need it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the resources that you require to manage very large sites, it’s rather likely that you’ll use InnoDB. You will be able to make use of other engines too, so if a certain application requires MyISAM instead of InnoDB, you will not have to deal with any problem while using it. The engine that will be used will be recognized automatically once the app installation process starts, so you will not have to configure any settings manually at any time.