InnoDB is a popular storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has got plenty of upsides which make it the preferred engine for many PHP-powered software applications, including Joomla and Magento, which have switched over to InnoDB permanently. For example, importing large data volumes will be faster with InnoDB, since it locks only one database row to accomplish a given task, not the entire table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the info is treated. To put it simply, importing new or updating existent data will either be fully completed, or will be aborted and the operation will be rolled back if a certain problem shows up during the process, therefore the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

While InnoDB is either a paid upgrade or it is not available at all with many hosting providers, it is an essential part of the default set of features that we are offering with our shared hosting plans. In case you want to make use of a script-driven software app that needs InnoDB in particular, in order to be activated and to work correctly, you won’t encounter any difficulties since the InnoDB database storage engine is available on our in-house developed cloud hosting platform. No matter if you create a brand new MySQL database and activate an application manually or make use of our single-click app installer tool, InnoDB will be selected automatically by our platform as the default engine if the respective app requires InnoDB instead of MyISAM. Besides the remarkable crash recovery offered by InnoDB, we also perform regular database backups, so that we can quickly recover any MySQL database in your shared account.

InnoDB in Semi-dedicated Hosting

If you create a brand-new MySQL database from the hosting Control Panel offered with each of our semi-dedicated server packages and you begin installing an open-source script-based web application either manually or using our single-click app installer tool, the storage engine for the database will be picked automatically depending on the requirements of the particular app. Since InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any application that requires it without any manual action needed on your end at any moment. To avoid any risk of losing info if you update an application or if you remove a database by accident, we will perform backups of all your MySQL databases every day, so if something goes wrong, we can restore your content.

InnoDB in VPS Hosting

All VPS hosting that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to use any open-source script-powered web application that requires the MySQL storage engine without needing to activate anything manually. You can choose Hepsia on the VPS order page and your brand-new server will be up and running within sixty minutes, so you can sign in and start creating your websites right away. When you set up a new MySQL database and start the app installation process, our system will pick the engine for this MySQL database automatically. In this way, you can install different applications simultaneously without having to change anything on the Virtual Private Server. You can have a WordPress personal weblog that makes use of the default MySQL engine – MyISAM, and a Magento-based e-store that uses the InnoDB engine, for instance.

InnoDB in Dedicated Web Hosting

Our Hepsia Control Panel is among the options which you can pick on the server configuration page when you buy a dedicated server from our company. As this is the most powerful kind of web hosting, it is very likely that you’ll manage highly popular sites that will draw a lot of individuals, and since InnoDB is among the best options for such sites, we’ll enable it along with all the other software applications that are offered with a Hepsia-managed dedicated server. When you set up a new MySQL database in your dedicated server account, there won’t be any active database storage engine till you begin installing an open-source script, whether manually through your Internet browser or using the automatic scripts installer that is included in the hosting Control Panel. The necessary engine will be automatically detected and will be assigned to that database, so you can make use of scripts that require InnoDB, as well as ones that need MyISAM, the default MySQL engine, without running into any impediment.