InnoDB is a storage engine for MySQL databases, which is used by famous PHP-powered applications like Magento and Joomla v3. It is ideal for scalable applications, since it works remarkably well when managing enormous amounts of data. Instead of locking the whole table to import new information into a database as many other engines do, InnoDB locks only one row, so it can perform much more operations for the same period of time. In addition, InnoDB offers a much better database failure recovery and supports transactions and foreign key constraints – a set of rules that determine how data inserts and modifications should be handled. In case a specific task has not been thoroughly completed for any reason, the action will be rolled back. In this way, the content in the database will remain undamaged and will not be partially mixed with newly added content.

InnoDB in Shared Website Hosting

While InnoDB is either a paid upgrade or it is not available at all with other hosting companies, it is included in the default set of features offered with our shared website hosting plans. If you want to use a script-based web application that requires InnoDB particularly, in order to be installed and to function correctly, you won’t need to deal with any problems since the database storage engine is available on our in-house developed cloud website hosting platform. Irrespective of whether you set up a brand new database and activate an app manually or make use of our one-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the app needs it rather than MyISAM. Besides the remarkable crash recovery offered by InnoDB, we also perform daily database backups, so that we can easily recover any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

If you set up a brand-new MySQL database from the hosting Control Panel provided with all our semi-dedicated server accounts and you start installing a PHP-powered app either manually or using our single-click application installer, the database storage engine will be selected automatically depending on the particular app’s requirements. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each app that requires it without the need for any manual intervention on your end at any point. To avoid any risk of losing information if you update an application or if you delete a database unintentionally, we’ll carry out backups of all your MySQL databases each and every day, so if anything goes wrong, we can recover your data.

InnoDB in VPS Hosting

When you purchase a virtual private server from us, you will be able to use our in-house developed Hepsia Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will allow you to run any open-source script-based application that requires InnoDB, as this database storage engine is an essential part of the standard software bundle that will be pre-installed on the server during its configuration. When you set up a brand-new MySQL database through the hosting Control Panel, you just have to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine as long as the app in question needs it, so you will not need to do anything else in your VPS account. Equivalently, if a given application requires MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Web Hosting

Our Hepsia hosting Control Panel is among the options that you can pick on the server order page when you buy a dedicated server from our company. As this is the most powerful kind of hosting, it’s very likely that you will manage highly popular sites that will draw many individuals, and since InnoDB is one of the best choices for such sites, we will enable it together with all the other software apps that come with a Hepsia-equipped server. If you set up a brand new MySQL database in your dedicated server account, there won’t be any activated MySQL storage engine until you begin installing a PHP script, whether manually through your web browser or using the automatic scripts installer that is included in the hosting Control Panel. The necessary engine will be detected and will be assigned to the database in question, so you can use scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without needing to cope with any difficulty.