InnoDB is a very popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has a lot of advantages which have made it the preferred engine for a lot of PHP script-powered applications, including Magento and Joomla™, which have shifted over to InnoDB for good. For example, importing immense volumes of data will be much faster with InnoDB, since it locks only a single row to complete a specific task, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is treated. Simply put, appending new or editing existing data will either be fully completed, or will be canceled and the operation will be rolled back if a given problem occurs in the meantime, therefore the content that remains in the database will not be lost.

InnoDB in Cloud Hosting

Every PHP-based application that needs InnoDB will function flawlessly on our advanced cloud website hosting platform and the database storage engine is offered with all our cloud hosting plans. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation process 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 having to change any setting in your account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to get the most out of its full potential. We will carry out daily content backups, so in case you accidentally erase a database that you need or you overwrite certain parts of it, we will be able to restore your database the way it was only a few hours earlier.

InnoDB in Semi-dedicated Servers

You can run a PHP script-powered web app that needs InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are set up on our cutting-edge cloud hosting platform where the MySQL database storage engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our one-click app installer tool. In either case, the needed engine will be picked automatically the moment 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 regularly used MyISAM. Furthermore, we will always be able to recover any of your MySQL databases in case you remove one by mistake, as we make a few MySQL database backups every day, each of which is saved for one whole week.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our in-house developed Hepsia Control Panel include a software package that is pre-activated and besides everything else, you will get the InnoDB database engine, so you won’t need to install it manually in case you need to use scripts that need it. All it takes to install such a script is to create a new database and to begin the installation process – as soon as the script configuration wizard gets access to the database and starts entering data into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You will also be able to activate scripts that need the other very popular MySQL engine, MyISAM, so you won’t need to configure any settings on the dedicated server. This will allow you to run different scripts on a single physical server and to use the latter to its fullest capacity.