InnoDB is a popular database storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has got lots of advantages that have made it the engine of choice for numerous PHP script-powered web apps, including Magento and Joomla™, which have switched over to InnoDB permanently. For instance, adding large data volumes will be much faster with InnoDB, due to the fact that it locks only a single database row to complete a particular task, not the entire database table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. In simpler words, appending new or editing existent data will either be thoroughly completed, or will be annulled and the operation will be rolled back in case any issue occurs during the process, hence the content that remains in the database will not be lost.

InnoDB in Shared Web Hosting

While InnoDB is either not available or a paid upgrade with many web hosts, it is an integral part of the default set of features that we offer with our shared web hosting plans. If you wish to use an open-source script-based software application that requires InnoDB particularly, in order to be activated and to perform properly, you will not encounter any obstacles because the database storage engine is available on our custom-developed cloud hosting platform. No matter if you set up a brand-new MySQL database and activate an app manually or take advantage of our one-click application installer instrument, InnoDB will be selected automatically by our platform as the default engine if the respective application requires InnoDB instead of MyISAM. Besides the outstanding database crash recovery offered by InnoDB, we also make regular database backups, so that we can quickly restore any database in your shared website hosting account.

InnoDB in Dedicated Servers

InnoDB is available as standard with all dedicated web hosting plans ordered with the Hepsia hosting Control Panel. It is an integral part of the software bundle that we install on all Hepsia-equipped dedicated servers, so as soon as your machine is up and running, you’ll be able to log in and to activate any kind of PHP-driven software app that requires this particular database engine. When you create a new MySQL database through the hosting Control Panel, there won’t be any activated engine until you start installing an app. As soon as the app configuration wizard begins entering data into the newly created database, the engine will be chosen automatically depending on the prerequisites of the app in question, so you can use both InnoDB and MyISAM without the need to select either one specifically at any point. Thus, you can use a broad range of apps for your Internet sites.