InnoDB is a very popular storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has numerous advantages which have made it the preferred engine for numerous PHP-powered web apps, such as Magento and Joomla, which have switched to InnoDB permanently. For instance, adding huge data volumes will be faster with InnoDB, as it locks only one row to carry out a certain operation, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is tackled. To put it simply, importing new or modifying existent data will either be entirely completed, or will be canceled and the operation will be rolled back if a given issue appears in the meantime, so the content that remains in the database won’t be damaged.

InnoDB in Website Hosting

While InnoDB is either not available or a paid upgrade with many other web hosting companies, it’s part of the default set of services offered with our website hosting plans. If you would like to make use of a script-driven web application that requires InnoDB specifically, in order to be activated and to perform properly, you won’t have to deal with any impediments because the MySQL database engine is available on our custom-developed cloud website hosting platform. Regardless of whether you create a brand new database and install an app manually or use our 1-click application installer tool, InnoDB will be selected automatically by our platform as the default engine if the specific application requires it rather than MyISAM. In addition to the amazing database failure recovery offered by InnoDB, we also make daily backups of all databases, so we can easily recover any database in your shared hosting account.

InnoDB in Semi-dedicated Hosting

All our semi-dedicated hosting support InnoDB and you can use all the options offered by this database engine with any open-source script-based web application that requires it. It’s one of the engines that we have on our cloud platform, so the one that will be used depends on the prerequisites of the specific application. You will not have to do anything manually to activate InnoDB, as it will be set as the default engine when you install an app – whether manually or using our single-click application installer. To be on the safe side, we will create regular MySQL database backups, so if something goes wrong after an update or if you delete some data unintentionally, we’ll be able to get your database back to the way it was on any of the past 7 days.

InnoDB in VPS

In case our custom-developed Hepsia hosting Control Panel is selected during the registration process for a new Linux VPS packages , InnoDB will be installed on the VPS server along with other essential pieces of software, so you won’t need to do anything if you choose to activate PHP-powered web applications that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed too. You can set up a new MySQL database and start the app installation manually or using our single-click installer. The system will automatically recognize which engine the particular app requires and will assign it to the specific database, so the installation process will proceed impeccably and the app can enter its content into that database. Thus, you can manage applications with different requirements regarding the MySQL engine without having to make any modifications on your VPS server.

InnoDB in Dedicated Hosting

Our Hepsia Control Panel is among the features which you can select on the order page when you buy a dedicated server from us. As this is the most powerful type of hosting, it is quite likely that you’ll manage popular websites that will attract plenty of visitors, and since InnoDB is one of the best choices for such websites, we’ll enable it together with all the other software applications that come with a Hepsia-managed dedicated server. When you set up a new MySQL database in your dedicated account, there won’t be any active MySQL storage engine until you start installing a PHP script, whether manually through your browser or using the automatic script installer tool that is available in the hosting Control Panel. The necessary engine will be detected automatically and will be assigned to that database, so you can install scripts that need InnoDB, as well as ones that require the default MySQL engine – MyISAM, without any predicaments.