InnoDB is a database engine for MySQL relational databases, which is used by widely used open-source script-powered web apps like Magento and Joomla v3. It is excellent for scalable applications, because it works very well when managing huge volumes of data. Rather than locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can carry out a lot more operations for the same length of time. Also, InnoDB offers an improved database failure recovery and supports database transactions and foreign key constraints – a set of rules that define how data imports and modifications should be handled. If a specific operation hasn’t been fully completed for any reason, the action will be rolled back. Thus, the content in the database will be preserved intact and won’t be partially mixed with newly imported content.

InnoDB in Shared Hosting

While InnoDB is either not available or a paid upgrade with many web hosting companies, it’s an essential part of the standard set of services that we’re offering with our shared hosting packages. In case you wish to use a PHP script-powered software app that needs InnoDB in particular, in order to be installed and to work correctly, you will not come across any problems because the database storage engine is available on our in-house developed cloud website hosting platform. Irrespective of whether you create a brand-new MySQL database and activate an application manually or use our single-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the particular app requires it instead of MyISAM. In addition to the amazing database failure recovery offered by InnoDB, we also store daily database backups, so that we can swiftly restore any MySQL database in your shared account.

InnoDB in Semi-dedicated Hosting

InnoDB is offered with all our Linux semi-dedicated hosting by default, so the moment you buy a new semi-dedicated account, you can move on and install any PHP-driven web app that needs this particular MySQL storage engine. A couple of engines are pre-installed on our cloud platform, so when you set up a brand new MySQL database and start installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be set depending on the particular app’s prerequisites. This will permit you to install and manage InnoDB-specific apps without encountering any impediment and without the need to configure any settings in your account. To be on the safe side, we’ll always keep a one-week-old backup of all your databases, so if you erase or alter any content by accident, we can quickly restore it.

InnoDB in VPS Hosting

When you obtain a virtual private server from us, you’ll be able to take full advantage of our in-house built Hepsia Control Panel to manage your content. A Hepsia-managed VPS will permit you to manage any PHP-based web application that requires InnoDB, as this particular database storage engine is an essential part of the default software bundle that will be installed on your server during its configuration. When you set up a new MySQL database via the hosting Control Panel, you will simply have to begin installing an application – manually or using our app installer. InnoDB will be set as the default engine in case the application in question requires it, so you will not need to do anything else in your VPS account. In the same manner, if an app needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.

InnoDB in Dedicated Web Hosting

Our Hepsia hosting Control Panel is among the options which you can pick on the server configuration page when you purchase a dedicated server from our company. As this is the most powerful kind of website hosting, it’s quite likely that you will run very popular websites that will draw plenty of individuals, and since InnoDB is among the best options for such websites, we will enable it together with all the other software apps that are offered with a Hepsia-equipped dedicated server. If you create a brand new MySQL database in your account, there won’t be any activated MySQL database storage engine until you begin installing a script, whether manually via your browser or using the automatic scripts installer tool that is integrated into the hosting Control Panel. The necessary engine will be automatically detected and will be assigned to the database in question, so you can run scripts that require InnoDB, as well as ones that need the default MySQL engine, MyISAM, without the need to deal with any complication.