InnoDB is a database storage engine for MySQL databases, which is used by widespread PHP script-powered applications like Joomla 3 and Magento. It’s perfect for scalable apps, because it performs remarkably well when handling immense amounts of data. Instead of locking the entire database table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can perform much more operations for the same period of time. Furthermore, InnoDB offers a much faster crash recovery and supports transactions and foreign keys – rules that indicate how data imports and modifications should be handled. In case a specific task hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the database content will remain undamaged and won’t be partially mixed with newly entered content.

InnoDB in Hosting

You can install any open-source script-driven web application that needs InnoDB if you have a hosting with our company, as the MySQL storage engine is available on our leading-edge cloud hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can activate applications which need the MyISAM engine without having to deal with any problem as well and, again, the engine will be pre-selected, so you will not need to configure any setting manually at any point. Furthermore, we’ll also perform regular backups of all the databases that you have in the shared account, so in case you erase or overwrite something, we can easily get it back to the way it was on any of the previous seven days.

InnoDB in Dedicated Servers

InnoDB is available as standard with all dedicated servers that are ordered with the Hepsia Control Panel. It is an integral part of the default software package that we install on all Hepsia-equipped dedicated servers, so as soon as your machine is assembled, you will be able to sign in and to activate a various PHP-driven software app that needs this particular MySQL database storage engine. If you create a new MySQL database via the hosting Control Panel, there won’t be any active engine till you begin installing an application. As soon as the app setup wizard begins entering content into the database, the engine will be picked automatically based on the prerequisites of the respective app, so you can use both InnoDB and MyISAM without the need to select either one of them specifically at any time. Therefore, you can make use of a broad selection of apps for your sites.