InnoDB is a popular database engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has a lot of pluses that have made it the engine of choice for lots of script-powered applications, including Joomla™ and Magento, which have switched to InnoDB permanently. For instance, adding enormous amounts of data will be faster with InnoDB, since it locks only one row to carry out a specific operation, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the data is handled. To put it simply, adding new or updating existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back if a certain problem occurs in the meantime, so the content that remains in the database won’t be damaged.

InnoDB in Cloud Hosting

Any PHP script-based app that needs InnoDB will run impeccably on our innovative cloud website hosting platform and the MySQL storage engine comes with all our cloud hosting plans. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s prerequisites without the need to configure any setting in your hosting account. InnoDB will be picked automatically for any app that requires this specific engine and you will be able to take advantage of its full capacity. We’ll create regular content backups, so if you accidentally remove a MySQL database that is important to you or you overwrite specific parts of it, we’ll be able to restore your database the way it was only a few hours ago.

InnoDB in Semi-dedicated Servers

You can run a script-powered application that requires InnoDB with any of our semi-dedicated server plans, since all the accounts are created on our avant-garde cloud platform where the database engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our one-click application installer tool. Either way, the required engine will be picked automatically once the application’s installation begins, so you won’t have to update anything manually, irrespective of whether the application needs InnoDB or the more frequently used MyISAM. Furthermore, we will always be able to recover any of your MySQL databases in case you unintentionally remove one, as we carry out a couple of MySQL database backups every day, each of which is preserved for 7 days.

InnoDB in VPS Servers

In case our in-house built Hepsia Control Panel is chosen during the signup process for a new VPS servers , InnoDB will be activated on the VPS server together with other needed software, so you will not have to do anything if you choose to install open-source script-powered software apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can set up a brand-new MySQL database and begin the app installation process manually or through our one-click installer. The system will automatically detect the engine that the application in question needs and will assign it to the specific database, so the installation will proceed impeccably and the app can dump its content in that database. In this way, you can make use of applications with various requirements concerning the MySQL engine without having to make any changes on your server.

InnoDB in Dedicated Servers

InnoDB is included as standard with all dedicated servers ordered with the Hepsia Control Panel. It is part of the software bundle that we install on all Hepsia-equipped dedicated servers, so once your machine is ready, you’ll be able to log in and to install any PHP script-based software app that needs this database storage engine. When you create a new MySQL database through the hosting Control Panel, there won’t be any active engine till you start installing an application. Once the app activation wizard starts inserting data into the database, the engine will be selected automatically based on the specific app’s prerequisites, so you can run both MyISAM and InnoDB without the need to select either of them specifically at any point. In this way, you can use an extensive selection of apps for your sites.