InnoDB is a storage engine for MySQL relational databases, which is used by popular PHP-powered software apps such as Magento and Joomla 3.x. It’s excellent for scalable applications, as it performs astonishingly well when handling large data volumes. Rather than locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can complete a lot more operations for the same period of time. Furthermore, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – rules that prescribe how data inserts and updates should be treated. If a given task hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will be retained intact and will not be partially mixed with newly entered content.

InnoDB in Cloud Web Hosting

While InnoDB is either not offered or it is a paid upgrade with many other hosting providers, it is an integral part of the default set of features offered with our cloud web hosting packages. If you’d like to use a PHP-powered software app that needs InnoDB in particular, in order to be installed and to perform properly, you will not need to deal with any obstacles since the InnoDB database engine is available on our in-house built cloud platform. Irrespective of whether you create a new database and install an application manually or make use of our single-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the respective application requires it instead of MyISAM. In addition to the outstanding database failure recovery offered by InnoDB, we also generate daily database backups, so that we can easily restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the Control Panel provided with all our semi-dedicated server accounts and you start installing an open-source script-based app either manually or using our single-click app installer, the storage engine for the database will be selected automatically depending on the prerequisites of the app in question. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated account will be set up, it will be set as the default engine for any application that needs it without any manual intervention needed on your end at any time. To avoid any risk of losing data if you update an application or if you remove a database accidentally, we’ll perform backups of all your MySQL databases every day, so if something happens, we can restore your data.

InnoDB in VPS Servers

All Linux VPS hosting service that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to use any PHP-driven software application that requires this particular MySQL database engine without needing to install anything manually. You can choose Hepsia on the VPS configuration page and your brand-new VPS server will be up and running within 1 hour, so you can sign in and start creating your websites right away. When you set up a brand-new MySQL database and begin the app installation process, our system will select the engine for that database automatically. In this way, you can activate various apps at the same time without the need to modify anything on the VPS server. You can create a WordPress-driven online blog that makes use of MyISAM – the default MySQL engine, and a Magento-based shopping portal that makes use of InnoDB, for example.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the options which you can select on the server configuration page when you purchase a dedicated server from us. As this is the most powerful type of web hosting, it is pretty likely that you’ll manage popular websites that will attract plenty of visitors, and since InnoDB is one of the best choices for such Internet sites, we’ll install it together with all the other software apps that are offered with a Hepsia-managed server. If you set up a new database in your dedicated account, there won’t be any active MySQL storage engine till you start installing an open-source PHP script, whether manually through your Internet browser or using the automatic scripts installation tool that is included in the hosting Control Panel. The necessary engine will be automatically recognized and will be assigned to that database, so you can run scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without any problem.