InnoDB is a very popular storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has a lot of strong sides that make it the engine of choice for lots of PHP-based web apps, among them Magento and Joomla, which have switched to InnoDB for good. For example, adding huge volumes of data will be much faster with InnoDB, due to the fact that it locks only one database row to accomplish a particular task, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the information is treated. To put it simply, adding new or editing existing data will either be entirely completed, or will be annulled and the procedure will be rolled back in case a certain issue appears in the meantime, thus the content that remains in the database will not be lost.

InnoDB in Cloud Hosting

InnoDB is offered with all our cloud hosting plans by default, not as a paid upgrade or upon request, so you can install and manage any open-source script-powered software application which needs the InnoDB database storage engine without having any difficulty as soon as you order your shared account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app installation, regardless of whether you take advantage of our single-click installation tool or create the database and set up the app manually, as long as the app requires InnoDB instead of the more popular MyISAM engine. We’ll keep regular backups of all your databases, so you can be certain that you won’t ever lose any data in case you erase a database unintentionally or you overwrite some vital info – you just have to contact us and we will restore your database back to normal.

InnoDB in Semi-dedicated Servers

You can activate a PHP script-based web app that needs InnoDB with all of our semi-dedicated server packages, as all the accounts are created on our cutting-edge cloud platform where the MySQL database storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you use our one-click application installer. In either case, the needed engine will be selected automatically the moment the activation of the app starts, so you will not need to configure anything manually, irrespective of whether the app requires InnoDB or the more frequently used MyISAM. Furthermore, we’ll always be able to retrieve any of your databases in case you remove one by accident, as we carry out a couple of database backups every day, each of which is saved for 1 week.

InnoDB in VPS Servers

If our in-house built Hepsia Control Panel is picked during the signup process for your new VPS plans , InnoDB will be installed on the VPS server together with other required software, so you will not have to do anything if you decide to activate PHP script-based software apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be activated too. You can set up a brand new database and begin the app installation procedure manually or through our 1-click installation tool. The system will detect the engine that the particular app requires and will assign it to the specific database, so the installation will proceed flawlessly and the application can insert its data into that database. Therefore, you can manage apps with various requirements in regard to the MySQL engine without having to make any changes on your server.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our custom-developed Hepsia Control Panel come with a software bundle that’s pre-installed and among everything else, you will get the InnoDB database storage engine, so you will not have to activate it manually if you’d like to activate PHP scripts that need it. All it takes to run such a script is to create a new database and to begin the setup process – once the script installation wizard receives access to the database and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one required by the script. You will also be able to use scripts that need MyISAM, the other popular MySQL engine, so you won’t have to configure any settings on the dedicated server. This will enable you to install a variety of scripts on one single physical machine and to use it to its fullest capabilities.