InnoDB is a very popular database engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has many upsides which have made it the preferred engine for a lot of open-source script-driven web applications, such as Joomla and Magento, which have shifted over to InnoDB permanently. For instance, importing enormous volumes of data will be much faster with InnoDB, as it locks only one row to carry out a given task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is treated. In simpler words, importing new or modifying existent data will either be fully completed, or will be annulled and the procedure will be rolled back if a given issue shows up in the meantime, hence the content that remains in the database will not be lost.

InnoDB in Shared Hosting

You will be able to install any script-driven app that requires InnoDB if you’ve got a shared hosting with us, as the MySQL database storage engine is available on our cutting-edge cloud platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is required. You can run applications which use the MyISAM engine without having to deal with any problem as well and, once again, the engine will be pre-selected, so you will not need to update any setting manually at any time. What’s more, we will also carry out regular backups of all the databases that you’ve got in your shared web hosting account, so if you erase or overwrite something, we can quickly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Hosting

You can use an open-source script-powered web application that needs InnoDB with all of our semi-dedicated server packages, because all the accounts are set up on our advanced cloud hosting platform where the storage engine is installed. A new database can be set up in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you make use of our single-click app installer. In either case, the needed engine will be picked automatically once the installation of the app starts, so you will not need to update anything manually, irrespective of whether the app requires InnoDB or the more regularly used MyISAM. Also, we will always be able to recover any of your MySQL databases if you delete one by accident, as we create a couple of MySQL database backups every day, each of which is preserved for 1 whole week.

InnoDB in VPS

When you acquire a virtual private server from our company, you’ll be able to take advantage of our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to use any PHP script-powered web application which requires InnoDB, as this particular MySQL storage engine is included in the standard software bundle that will be installed on your Virtual Private Server during its setup. When you create a brand new MySQL database via the Control Panel, you’ll simply need to start installing an application – manually or using our app installer. InnoDB will be set as the default engine on the condition that the application in question requires it, so you won’t have to do anything else in your VPS account. Identically, if an application needs MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Hosting

When you order a new dedicated server, you’ll be able to choose any of the three Control Panels that we’re offering – Hepsia, DirectAdmin and cPanel. Any server ordered with Hepsia comes with InnoDB pre-activated, so you will not have to install this MySQL storage engine manually to be able to use script-driven web applications that require it. InnoDB is used for scalable apps and since a dedicated server will give you all the resources that you require in order to run large-scale Internet sites, it is rather possible that you’ll use InnoDB. You will be able to use other engines too, so if a particular application needs MyISAM rather than InnoDB, you will not encounter any problem while using it. The engine that will be used will be automatically detected the moment the app installation process commences, so you won’t have to modify any settings manually whatsoever.