InnoDB is a storage engine for MySQL relational databases, which is used by famous open-source script-driven web apps such as Magento and Joomla v3. It’s perfect for scalable apps, because it works incredibly well when processing large volumes of data. Instead of locking the entire database table to import new information into a database as many other engines do, InnoDB locks only one row, so it can execute much more tasks for the same period of time. What’s more, InnoDB offers a much faster database crash recovery and supports transactions and foreign key constraints – rules that determine how data inserts and modifications should be treated. If a given task has not been entirely completed for whatever reason, the action will be rolled back. In this way, the database content will stay safe and sound and will not be partially merged with newly added content.

InnoDB in Cloud Website Hosting

While InnoDB is either not offered or it is a paid upgrade with many website hosting service providers, it’s included in the default set of services that we’re offering with our cloud website hosting packages. In case you’d like to make use of a PHP script-driven web application that needs InnoDB particularly, in order to be activated and to perform properly, you will not face any problems because the MySQL storage engine is available on our in-house developed cloud Internet hosting platform. Regardless of whether you create a brand new database and install an application manually or take advantage of our 1-click application installer software tool, InnoDB will be selected automatically by our platform as the default engine if the app requires it rather than MyISAM. In addition to the outstanding crash recovery that InnoDB offers, we also generate regular backups of all databases, so that we can quickly restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

You can use a PHP-powered software app that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our innovative cloud web hosting platform where the database engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our one-click application installer. In either case, the needed engine will be selected automatically once the installation of the application begins, so you won’t need to update anything manually, irrespective of whether the application needs InnoDB or the more frequently used MyISAM. On top of that, we will always be able to restore any of your databases in case you unintentionally erase one, as we carry out a couple of backups every day, each of which is saved for 1 whole week.

InnoDB in VPS Servers

All Linux VPS web hosting service that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you will be able to run any open-source script-based software app that requires this storage engine without having to install anything manually. You can select Hepsia on the VPS configuration page and your brand-new server will be set up within 1 hour, so you can log in and start creating your Internet sites straight away. When you create a new database and begin the app activation process, our system will set the engine for this database automatically. In this way, you can run various applications simultaneously without having to modify anything on the Virtual Private Server. You can create a WordPress-based personal blog that makes use of the default MySQL engine – MyISAM, and a Magento-powered web shop that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options which you can pick on the order form when you buy a dedicated server from us. Since this is the most powerful kind of website hosting, it’s rather likely that you will manage highly popular Internet sites that will attract a lot of people, and since InnoDB is among the best options for such websites, we will enable it together with all the other software applications that are offered with a Hepsia-managed dedicated server. When you set up a brand new database in your dedicated account, there won’t be any active MySQL storage engine till you start installing an open-source script, whether manually via your web browser or using the automatic script installer tool that is available in the Control Panel. The needed engine will be detected and will be set for the database in question, so you can use scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without running into any difficulty.