InnoDB is a very popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has many advantages that have made it the engine of choice for plenty of PHP-powered web apps, including Magento and Joomla, which have switched to InnoDB for good. For instance, adding enormous volumes of data will be much faster with InnoDB, because it locks only one database row to carry out a specific operation, not the entire table, which makes the engine perfect for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the data is tackled. Simply put, adding new or modifying existent data will either be fully completed, or will be canceled and the procedure will be rolled back in case a given problem shows up in the meantime, which means that the content that remains in the database won’t be damaged.

InnoDB in Shared Website Hosting

Any script-driven software app that requires InnoDB will function impeccably on our innovative cloud website hosting platform and the database engine is offered with all our shared website hosting packages. 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 on the basis of the app’s requirements without the need to edit any setting in your hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to get the most out of its full potential. We’ll generate daily backups of your content, so if you accidentally erase a MySQL database that’s important to you or you overwrite some part of it, we will be able to restore your database the way it was just a few hours ago.

InnoDB in Semi-dedicated Servers

You can activate a PHP-driven application that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are set up on our advanced cloud platform where the storage engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our one-click application installer. In either case, the required engine will be chosen automatically the moment the activation of the application starts, so you will not have to edit anything manually, no matter if the application needs InnoDB or the more frequently used MyISAM. Also, we’ll always be able to recover any of your MySQL databases in case you accidentally erase one, as we create a few MySQL database backups every day, each of which is stored for one week.

InnoDB in VPS Servers

If you order a VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be an essential part of the software pack that will be pre-installed on your Virtual Private Server before we give it to you. You won’t have to set up anything manually and you’ll be able to install and run any script-driven software app that needs InnoDB when your VPS is set up, which takes no more than 60 minutes after the order submission procedure itself. A few engines are available, so anytime you create a database via the Hepsia hosting Control Panel, a specific engine will be picked when the app installation process begins and our system will automatically recognize which engine is required by the application in question. In case you need MyISAM, for instance, you won’t have to do anything different than installing the preferred app, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

When you purchase a new dedicated server, you will be able to pick one of the three Control Panels that we’re offering – DirectAdmin, Hepsia and cPanel. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t need to add this database engine manually in order to be able to run PHP-driven apps that require it. InnoDB is used by scalable applications and since a dedicated server will offer you all the system resources that you require in order to run large-scale Internet sites, it’s quite likely that you will resort to InnoDB. You’ll be able to make use of other engines as well, so if a certain application needs MyISAM rather than InnoDB, you will not have to deal with any complication while managing it. The engine that will be used will be automatically detected when the app installation begins, so you will not need to edit any setting manually at any point.