InnoDB is a popular database storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has got plenty of strong sides which have made it the preferred engine for lots of PHP-powered software apps, including Magento and Joomla™, which have switched over to InnoDB permanently. For example, adding immense amounts of data will be faster with InnoDB, since it locks only a single database row to perform a certain task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is handled. To put it simply, importing new or modifying existent data will either be fully completed, or will be aborted and the procedure will be rolled back in case some problem appears in the meantime, so the content that remains in the database won’t be lost.

InnoDB in Web Hosting

While InnoDB is either a paid upgrade or it is not available at all with many web hosts, it’s an essential part of the standard set of features that we offer with our web hosting packages. If you’d like to make use of a PHP script-driven app that needs InnoDB specifically, in order to be installed and to work correctly, you won’t need to deal with any obstacles as the MySQL database storage engine is available on our custom-built cloud web hosting platform. No matter if you set up a brand new database and activate an application manually or take advantage of our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the specific application requires InnoDB instead of MyISAM. Besides the exceptional crash recovery that InnoDB offers, we also maintain daily database backups, so we can quickly restore any database in your shared web hosting account.

InnoDB in Dedicated Servers

InnoDB is available as standard with all dedicated web hosting plans that are ordered with the Hepsia hosting Control Panel. It’s an integral part of the standard software bundle that will be installed on all Hepsia-equipped dedicated servers, so as soon as your physical machine is assembled, you’ll be able to sign in and to activate any PHP script-powered application that requires this particular database storage engine. If you set up a new MySQL database via the hosting Control Panel, there won’t be any activated engine until you begin installing an app. Once the app installation wizard starts inserting content into the newly created database, the engine will be chosen automatically depending on the respective app’s prerequisites, so you can run both MyISAM and InnoDB without having to select either of them specifically at any point. Thus, you can use a vast collection of applications for your Internet sites.