InnoDB is a very popular storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has lots of upsides that make it the preferred engine for lots of open-source script-based software apps, among them Magento and Joomla, which have switched over to InnoDB for good. For instance, adding huge volumes of data will be much faster with InnoDB, because it locks only a single database row to carry out a specific operation, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the data is handled. To put it simply, appending new or editing existent data will either be thoroughly completed, or will be aborted and the procedure will be rolled back if a given issue appears in the meantime, therefore the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

Every open-source script-driven app that requires InnoDB will function impeccably on our innovative cloud web hosting platform and the storage engine comes with all our shared hosting plans. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected on the basis of the app’s requirements without having to configure any setting in your hosting account. InnoDB will be selected automatically for any app that requires this particular engine and you will be able to take advantage of its full capacity. We’ll store daily backups of your content, so in case you accidentally delete a database that is important to you or you overwrite a certain part of it, we’ll be able to restore your data the way it was only several hours earlier.

InnoDB in Semi-dedicated Servers

If you set up a brand new MySQL database through the Control Panel offered with each of our semi-dedicated server plans and you start installing a PHP-based software app either manually or using our one-click app installer, the database storage engine will be picked automatically based on the prerequisites of the specific app. Since InnoDB is available on the cloud web hosting platform where your new account will be set up, it will be set as the default engine for any application that needs it without any manual intervention required on your end at any moment. To avoid any chance of losing data if you update an app or if you delete a database accidentally, we will make a backup of all your MySQL databases each and every day, so if something happens, we can rescue your data.

InnoDB in VPS Servers

When you obtain a VPS server from our company, you’ll be able to take full advantage of our in-house developed Hepsia Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to run any script-powered web application that requires InnoDB, as this particular MySQL storage engine is part of the default software bundle that will be pre-installed on the server during its creation. When you set up a new database through the hosting Control Panel, you just have to begin installing an app – manually or using our app installer tool. InnoDB will be set as the default engine if the app in question requires it, so you will not need to do anything else in your VPS account. Correspondingly, if a certain app needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

All Linux dedicated servers that are ordered with our in-house built Hepsia Control Panel include a software package that’s pre-installed and besides everything else, you will get the InnoDB database engine, so you won’t need to activate it manually if you wish to activate PHP scripts that require it. All it takes to activate such a script is to create a new MySQL database and to begin the installation – as soon as the script setup wizard acquires access to the database in question and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You will also be able to run scripts that need the other very popular MySQL engine, MyISAM, so you will not need to configure any settings on the server. This will permit you to run various scripts on a single physical machine and to use it to its maximum capabilities.