InnoDB is a popular database engine for the MySQL RDBMS. It is an alternative to the default MyISAM engine and it has got plenty of advantages which make it the preferred engine for numerous PHP script-based applications, such as Magento and Joomla, which have moved to InnoDB for good. For instance, importing large volumes of data will be much faster with InnoDB, because it locks only one database row to carry out a task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the data is treated. Put simply, appending new or editing existent data will either be fully completed, or will be aborted and the operation will be rolled back in case a given issue shows up during the process, therefore the content that remains in the database will not be lost.

InnoDB in Semi-dedicated Hosting

You can install an open-source script-powered software application that requires InnoDB with all of our semi-dedicated server plans, because all the accounts are set up on our innovative cloud platform where the MySQL storage engine is installed. A new database can be set up in two separate ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you make use of our single-click app installer. Either way, the needed engine will be picked automatically once the activation of the application begins, so you won’t need to edit anything manually, irrespective of whether the app needs InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to retrieve any of your MySQL databases in case you delete one by mistake, as we generate a couple of MySQL database backups every day, each of which is preserved for 7 days.

InnoDB in VPS Hosting

If our in-house developed Hepsia Control Panel is chosen during the signup process for your new Linux virtual private servers , InnoDB will be installed on the VPS server along with other required pieces of software, so you won’t have to do anything if you decide to manage open-source script-powered applications that need this MySQL database engine. The default MySQL engine – MyISAM, will be activated as well. You can set up a brand-new database and start the app installation process manually or through our 1-click installation tool. The system will recognize the engine that the particular app needs and will assign it to the specific MySQL database, so the installation process will continue impeccably and the application can insert its content into that database. In this way, you can install applications with different prerequisites about the MySQL engine without the need to make any modifications on your VPS server.

InnoDB in Dedicated Web Hosting

Our Hepsia Control Panel is among the features which you can choose on the server configuration page when you purchase a dedicated server from us. Since this is the most powerful type of web hosting, it is very likely that you will manage popular sites that will attract plenty of visitors, and since InnoDB is one of the very best choices for such sites, we’ll enable it along with all the other software applications that come with a Hepsia-managed server. If you create a brand-new MySQL database in your dedicated server account, there won’t be any activated storage engine till you start installing an open-source PHP script, whether manually via your browser or using the automatic script installation tool that is integrated into the hosting Control Panel. The needed engine will be recognized and will be set for the database in question, so you can run scripts that require InnoDB, as well as ones that require MyISAM, the default MySQL engine, without running into any problem.