InnoDB is a very popular storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has many strong sides that have made it the preferred engine for a lot of open-source script-driven apps, including Magento and Joomla, which have switched over to InnoDB for good. For example, adding huge data volumes will be faster with InnoDB, as it locks only a single row to accomplish a certain operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the information is tackled. Put simply, importing new or updating existent data will either be fully completed, or will be canceled and the procedure will be rolled back if any issue appears during the process, thus the content that remains in the database won’t be damaged.

InnoDB in Cloud Web Hosting

While InnoDB is either not available or a paid upgrade with other web hosting providers, it’s included in the default set of features that we’re offering with our cloud web hosting plans. In case you want to make use of a PHP-driven web application that requires InnoDB particularly, in order to be installed and to operate properly, you will not face any obstacles as the InnoDB storage engine is available on our in-house built cloud website hosting platform. Regardless of whether you set up a brand new database and activate an application manually or take advantage of our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the respective app needs it instead of MyISAM. Besides the outstanding database failure recovery that InnoDB is offering, we also generate regular database backups, so that we can easily restore any database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our Linux semi-dedicated servers by default, so the moment you purchase a new account, you can move on and activate any PHP script-based software app that needs the MySQL database storage engine. Several engines are pre-installed on our cloud website hosting platform, so when you set up a brand new MySQL database and begin installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be selected depending on the prerequisites of the specific app. This will permit you to activate and run InnoDB-specific applications without having to deal with any complication and without having to edit any settings in your account. To take no chances, we’ll always keep a one-week-old backup of all your MySQL databases, so if you delete or change any content accidentally, we can quickly recover it.

InnoDB in VPS Servers

In case our custom-developed Hepsia hosting Control Panel is selected during the registration process for a new VPS plans , InnoDB will be activated on the server together with other necessary software, so you won’t have to do anything if you choose to make use of PHP-based web apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed as well. You can set up a brand new MySQL database and start the app installation process manually or through our single-click installer tool. The system will detect which engine the application in question needs and will set it for the specific database, so the installation process will continue flawlessly and the app can dump its content in that database. In this way, you can run applications with different prerequisites regarding the MySQL engine without making any changes on your server.

InnoDB in Dedicated Servers

If you acquire a new dedicated server, you will be able to pick one of the three Control Panels that we offer – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to install this database storage engine manually so as to be able to run PHP-based applications that require it. InnoDB is used for scalable applications and since a dedicated server will offer you all the system resources that you need to run very large websites, it’s pretty possible that you’ll use InnoDB. You’ll be able to use other engines too, so if a certain app needs MyISAM instead of InnoDB, you won’t come across any problem while using it. The engine that will be used will be recognized automatically the moment the app installation procedure starts, so you will not have to configure any settings manually at any moment.