InnoDB is a very popular database engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has got numerous pluses that have made it the preferred engine for a lot of open-source script-driven software applications, among them Joomla™ and Magento, which have switched to InnoDB permanently. For instance, importing enormous volumes of data will be much faster with InnoDB, since it locks only a single database row to complete a particular operation, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the info is treated. In simpler words, appending new or modifying existent data will either be entirely completed, or will be canceled and the procedure will be rolled back in case a given issue occurs in the meantime, thus the content that remains in the database will not be damaged.

InnoDB in Web Hosting

Every script-powered software application that requires InnoDB will function impeccably on our leading-edge cloud website hosting platform and the MySQL storage engine comes with all our web hosting packages. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will make use of will be selected in accordance with the app’s requirements without the need to change any setting in your hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you will be able to make the most of its full potential. We’ll carry out daily content backups, so if you unintentionally delete a database that you need or you overwrite some part of it, we will be able to restore the database the way it was just several hours earlier.

InnoDB in Dedicated Servers

All dedicated web hosting plans that are ordered with our in-house developed Hepsia hosting Control Panel come with a software bundle that’s pre-activated and besides everything else, you’ll get the InnoDB database engine, so you won’t need to install it manually if you want to run PHP scripts that require it. All it takes to use such a script is to create a new MySQL database and to begin the setup process – as soon as the setup wizard acquires access to the database in question and begins entering data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one required by the script. You’ll also be able to activate scripts that need the other widely used MySQL engine, MyISAM, so you will not have to edit any settings on the dedicated server. This will enable you to use different scripts on one single machine and to use the latter to its full capabilities.