InnoDB is a database engine for MySQL databases, which is used by popular PHP script-powered web applications like Joomla v3 and Magento. It is excellent for scalable apps, because it performs exceptionally well when processing huge data volumes. Rather than locking the whole table to import new information into a database as many other engines do, InnoDB locks only one row, so it can complete a lot more tasks for the same length of time. In addition, InnoDB offers a much faster crash recovery and supports transactions and foreign key constraints – a set of rules that determine how data imports and modifications should be treated. If a specific operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. In this way, the information in the database will stay safe and sound and won’t be partially merged with newly appended content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting companies, it is an essential part of the default set of services that we are offering with our cloud hosting packages. In case you would like to make use of a PHP script-powered software application that requires InnoDB particularly, in order to be installed and to work correctly, you will not have to deal with any obstacles as the MySQL storage engine is available on our custom cloud hosting platform. Irrespective of whether you create a brand-new database and install an application manually or use our one-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the particular app needs InnoDB rather than MyISAM. Besides the exceptional database crash recovery that InnoDB is offering, we also make daily backups of all databases, so we can quickly recover any database in your shared account.

InnoDB in Semi-dedicated Servers

InnoDB is included with all our semi-dedicated hosting plans by default, so the moment you purchase a new account, you can go ahead and activate any PHP-based software app that requires this MySQL database storage engine. Several engines are installed on our cloud web hosting platform, so when you set up a brand-new MySQL database and begin installing an application manually, or opt to use the Hepsia hosting Control Panel-integrated app installer tool, the engine for the database will be selected on the basis of the given app’s requirements. This will permit you to activate and run InnoDB-specific apps without the need to cope with any problem and without having to change 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 delete or alter any content accidentally, we can quickly restore it.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the options that you can pick on the order form 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 highly popular websites that will draw lots of people, and since InnoDB is one of the very best options for such sites, we will install it along with all the other software applications that are offered with a Hepsia-managed dedicated server. If you create a new MySQL database in your account, there won’t be any active storage engine until you begin installing an open-source PHP script, whether manually via your web browser or using the automatic scripts installation tool that is included in the hosting Control Panel. The necessary engine will be recognized and will be set for that database, so you can activate scripts that need InnoDB, as well as ones that need the default MySQL engine – MyISAM, without having to deal with any obstacle.