InnoDB is a storage engine for MySQL databases, which is used by widespread open-source script-driven web apps like Magento and Joomla 3.x. It is excellent for scalable apps, since it works stunningly well when processing huge data volumes. Rather than locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can perform a lot more operations for the same length of time. Besides, InnoDB offers a much faster crash recovery and supports database transactions and foreign keys – a set of rules that specify how data inserts and modifications should be handled. If a given operation hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the information in the database will stay intact and won’t be partially mixed with new content.

InnoDB in Website Hosting

While InnoDB is either not offered or it is a paid upgrade with other web hosts, it’s an integral part of the standard set of services that we are offering with our website hosting packages. In case you would like to use an open-source script-based application that needs InnoDB in particular, in order to be installed and to work correctly, you will not need to deal with any difficulties as the storage engine is available on our in-house developed cloud platform. No matter if you set up a brand new MySQL database and install an app manually or make use of our single-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective application requires InnoDB instead of MyISAM. In addition to the excellent database failure recovery offered by InnoDB, we also keep daily backups of all databases, so that we can easily restore any database in your shared web hosting account.

InnoDB in Semi-dedicated Servers

InnoDB is offered with all our semi-dedicated servers by default, so once you obtain a new account, you can move on and activate any PHP-powered app that needs the storage engine. Several engines are installed on our cloud hosting platform, so when you create a brand new database and start installing an app manually, or decide to use the Hepsia Control Panel-integrated app installer tool, the engine for the database will be selected on the basis of the requirements of the specific application. This will allow you to activate and run InnoDB-specific apps without having any difficulty and without needing to configure any settings in your account. To be on the safe side, we’ll always have a 7-day-old backup of all your databases, so if you delete or alter any content accidentally, we can swiftly recover it.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options that you can choose on the order page when you purchase a dedicated server from our company. As this is the most powerful type of website hosting, it’s quite likely that you’ll manage highly popular Internet sites that will draw a lot of individuals, and since InnoDB is among the best options for such sites, we’ll enable it along with all the other software apps that come with a Hepsia-managed dedicated server. When you create a brand new database in your account, there won’t be any activated MySQL storage engine until you start installing an open-source PHP script, whether manually through your browser or using the automatic script installer tool that is available in the hosting Control Panel. The required engine will be recognized automatically and will be set for the database in question, so you can make use of scripts that need InnoDB, as well as ones that need the default MySQL engine, MyISAM, without having any impediment.