InnoDB

Learn what a database engine is, what exactly are the pros of the InnoDB engine and why it's gaining a lot of global popularity.

InnoDB is a very popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has plenty of advantages that make it the engine of choice for numerous PHP script-powered software applications, such as Magento and Joomla^™, which have shifted over to InnoDB permanently. For example, importing enormous volumes of data will be faster with InnoDB, as it locks only a single database row to complete a specific operation, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. Put simply, appending new or updating existent data will either be thoroughly completed, or will be aborted and the procedure will be rolled back if a given issue occurs in the meantime, which is why the content that remains in the database won’t be lost.

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-powered web app either manually or using our one-click app installer, the MySQL database storage engine will be selected automatically on the basis of the requirements of the particular application. Since InnoDB is present on the cloud platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that requires it without the need for any manual action on your end at any point. To prevent any chance of losing information if you update an application or if you delete a database unintentionally, we’ll make a backup of all your MySQL databases each day, so if anything goes wrong, we can recover your content.

InnoDB in Dedicated Web Hosting

InnoDB comes by default with all dedicated web hosting that are ordered with the Hepsia Control Panel. It is part of the software bundle that we install on all Hepsia-managed dedicated servers, so as soon as your machine is assembled, you will be able to sign in and to activate any kind of PHP script-powered software app that needs this MySQL storage engine. When you set up a new MySQL database via the Control Panel, there won’t be any activated engine until you start installing an application. Once the app setup wizard starts entering data into the database, the engine will be set automatically depending on the requirements of the particular application, so you can use both MyISAM and InnoDB without the need to select either one of them explicitly at any point. Thus, you can use a broad selection of applications for your sites.