InnoDB is a very popular database engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has got many pluses that have made it the preferred engine for lots of PHP-based applications, among them Joomla and Magento, which have moved to InnoDB permanently. For instance, adding huge amounts of data will be much faster with InnoDB, as it locks only one database row to perform an operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the data is treated. In simpler words, importing new or editing existent data will either be entirely completed, or will be aborted and the operation will be rolled back in case a certain problem occurs in the meantime, thus the content that remains in the database won’t be lost.

InnoDB in Cloud Website Hosting

While InnoDB is either not available or a paid upgrade with many hosting companies, it is included in the standard set of services that we’re offering with our cloud website hosting packages. If you would like to make use of a PHP-based app that needs InnoDB particularly, in order to be installed and to perform correctly, you will not come across any impediments because the storage engine is available on our custom-developed cloud website hosting platform. No matter if you create a brand-new MySQL database and install an application manually or make use of our single-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the respective app requires it rather than MyISAM. In addition to the exceptional database crash recovery that InnoDB offers, we also carry out regular database backups, so we can swiftly recover any database in your shared website hosting account.

InnoDB in Dedicated Hosting

Our Hepsia Control Panel is one of the options which you can pick on the order page when you buy a dedicated server from our company. As this is the most powerful type of website hosting, it is pretty likely that you’ll run very popular sites that will attract lots of individuals, and since InnoDB is one of the best choices for such Internet sites, we’ll install it together with all the other software apps that come with a Hepsia-equipped server. When you set up a new MySQL database in your dedicated account, there won’t be any activated storage engine until you start installing an open-source PHP script, whether manually through your Internet browser or using the automatic script installation tool that is integrated into the Control Panel. The required engine will be automatically detected and will be assigned to that database, so you can activate scripts that need InnoDB, as well as ones that need the default MySQL engine, MyISAM, without having any complication.