InnoDB is a storage engine for MySQL databases, which is used by famous script-powered web applications like Magento and Joomla 3.x. It’s excellent for scalable applications, as it works really well when handling enormous amounts of data. Rather than locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same period of time. In addition, InnoDB offers an improved database failure recovery and supports transactions and foreign keys – a set of rules that define how data inserts and updates should be handled. If a specific operation hasn’t been entirely completed for any reason, the action will be rolled back. In this way, the database content will be preserved safe and sound and won’t be partially merged with newly imported content.

InnoDB in Cloud Hosting

While InnoDB is either a paid upgrade or it is not available at all with other web hosting companies, it’s included in the standard set of features offered with our cloud hosting packages. If you would like to use an open-source script-powered application that requires InnoDB particularly, in order to be activated and to function correctly, you won’t experience any impediments because the MySQL database storage engine is available on our custom-developed cloud platform. No matter if you set up a new MySQL database and install an app manually or use our 1-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the given app requires InnoDB rather than MyISAM. In addition to the exceptional crash recovery offered by InnoDB, we also perform regular backups of all databases, so we can swiftly restore any MySQL database in your shared account.

InnoDB in Dedicated Web Hosting

InnoDB comes as standard with all Linux dedicated web hosting that are ordered with the Hepsia hosting Control Panel. It is an essential part of the standard software package that will be pre-installed on all Hepsia-equipped dedicated servers, so once your machine is up and running, you’ll be able to sign in and to install any type of PHP script-based web application that requires this particular MySQL database engine. When you create a new database via the hosting Control Panel, there won’t be any activated engine until you start installing an application. Once the app activation wizard begins inserting information into the newly created database, the engine will be selected automatically depending on the prerequisites of the specific app, so you can run both MyISAM and InnoDB without the need to select either one explicitly at any moment. In this way, you can make use of a broad selection of apps for your Internet sites.