InnoDB is a popular storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got many pluses which have made it the engine of choice for lots of PHP script-powered web apps, among them Magento and Joomla, which have switched to InnoDB for good. For example, adding huge data volumes will be faster with InnoDB, due to the fact that it locks only a single database row to carry out a given task, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the data is treated. Put simply, importing new or updating existing data will either be fully completed, or will be canceled and the operation will be rolled back in case some issue shows up during the process, hence the content that remains in the database won’t be lost.

InnoDB in Web Hosting

Every PHP-based application that needs InnoDB will function flawlessly on our cutting-edge cloud platform and the MySQL database storage engine comes with all our web hosting plans. Each time you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected in accordance with the app’s specifications without the need to edit any setting in your web hosting account. InnoDB will be picked automatically for any app that requires this specific engine and you’ll be able to make the most of its full capacity. We will carry out regular content backups, so in case you accidentally remove a MySQL database that is important to you or you overwrite certain parts of it, we will be able to restore your database the way it was just several hours earlier.

InnoDB in Semi-dedicated Servers

You can install an open-source script-driven application that requires InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are set up on our avant-garde cloud hosting platform where the storage engine is installed. A new database can be created in two different ways – manually through the Database Manager section of the Hepsia website 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 as soon as the activation of the application starts, so you will not need to update anything manually, regardless of whether the app needs InnoDB or the more frequently used MyISAM. Furthermore, we’ll always be able to restore any of your databases in case you remove one by mistake, as we carry out several MySQL database backups every day, each of which is preserved for 1 week.

InnoDB in VPS Servers

If you acquire a VPS server from our company, you’ll be able to take full advantage of our custom-built Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to use any PHP script-based software application which requires InnoDB, as the database engine is an essential part of the standard software package that will be pre-installed on the VPS server during its creation. When you set up a new MySQL database using the Control Panel, you simply have to start installing an app – manually or using our application installer tool. InnoDB will be set as the default engine on the condition that the app in question needs it, so you won’t need to do anything else in your VPS account. Similarly, 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 comes as standard with all dedicated servers ordered with the Hepsia hosting Control Panel. It’s an integral part of the standard software bundle that will be pre-installed on all Hepsia-managed servers, so once your machine is up and running, you’ll be able to log in and to activate a various script-powered software app that needs this particular MySQL database storage engine. When you create a new MySQL database through the Control Panel, there won’t be any active engine until you start installing an application. As soon as the app configuration wizard starts inserting data into the newly created database, the engine will be picked automatically based on the prerequisites of the respective application, so you can run both MyISAM and InnoDB without the need to select either one of them specifically at any time. In this way, you can use a wide selection of applications for your Internet sites.