InnoDB is a very popular storage engine for MySQL. It is an alternative to the default engine – MyISAM, and it has lots of advantages which make it the preferred engine for plenty of open-source script-powered software applications, such as Joomla™ and Magento, which have switched over to InnoDB permanently. For example, adding huge amounts of data will be much faster with InnoDB, since it locks only one row to execute a particular task, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the information is tackled. In simpler words, adding new or editing existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if some problem appears in the meantime, hence the content that remains in the database will not be damaged.

InnoDB in Shared Hosting

You’ll be able to run any open-source script-based software app that needs InnoDB in case you have a Linux shared hosting with us, as the MySQL storage engine is available on our cutting-edge cloud web hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is needed. You can run apps which need the MyISAM engine without encountering any problem as well and, again, the engine will be selected automatically, so you will not need to change anything manually at any moment. In addition, we will also perform regular backups of all the databases that you have in the shared hosting account, so in case you delete or overwrite anything, we can quickly get it back to the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

You can install a PHP script-based web application that requires InnoDB with any of our semi-dedicated server plans, because all the accounts are created on our advanced cloud web hosting platform where the database storage engine is installed. A new database can be created in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our one-click app installer tool. Either way, the required engine will be selected automatically as soon as the app’s activation starts, so you will not have to update anything manually, regardless of whether the app requires InnoDB or the more commonly used MyISAM. In addition, we’ll always be able to restore any of your databases in case you unintentionally erase one, as we create several backups every day, each of which is saved for seven days.

InnoDB in VPS Servers

If you obtain a VPS server from our company, you’ll be able to make use of our in-house built Hepsia hosting Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will permit you to activate any open-source script-powered software application which requires InnoDB, as the MySQL database engine is included in the standard software bundle that will be pre-installed on your VPS server during its configuration. When you create a new database using the Control Panel, you just need to start installing an application – manually or using our application installer. InnoDB will be set as the default engine as long as the application in question needs it, so you won’t have to do anything else in your account. Identically, if a certain application requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

InnoDB is included by default with all Linux dedicated servers that are ordered with the Hepsia Control Panel. It is an essential part of the standard software bundle that we install on all Hepsia-equipped dedicated servers, so as soon as your machine is assembled, you’ll be able to sign in and to install any kind of open-source script-powered web application that needs this particular MySQL storage engine. If you set up a new database through the Control Panel, there won’t be any active engine till you begin installing an app. Once the app activation wizard starts entering data into the newly created database, the engine will be picked automatically on the basis of the prerequisites of the specific application, so you can run both MyISAM and InnoDB without having to select either one explicitly at any point. In this way, you can make use of a broad variety of applications for your sites.