InnoDB is a very popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has many strong sides that make it the engine of choice for a lot of PHP script-powered web apps, such as Joomla and Magento, which have switched to InnoDB for good. For example, importing enormous amounts of data will be faster with InnoDB, because it locks only a single row to perform a given task, not the entire database table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the info is handled. To put it simply, appending new or updating existent data will either be thoroughly completed, or will be annulled and the procedure will be rolled back if a certain problem shows up during the process, hence the content that remains in the database won’t be lost.

InnoDB in Shared Hosting

You’ll be able to use any open-source script-driven web app that requires InnoDB if you have a Linux shared hosting package with us, as the MySQL database storage engine is available on our innovative cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly in case this engine is required. You can run applications that need the MyISAM engine without having any difficulty as well and, again, the engine will be pre-selected, so you won’t have to update anything manually at any moment. On top of that, we will also generate daily backups of all the databases that you have in the shared web hosting account, so if you erase or overwrite anything, we can quickly get it back to the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Hosting

You can make use of a PHP script-powered app that requires InnoDB with any of our semi-dedicated server packages, since all the accounts are created on our advanced cloud platform where the MySQL database storage engine is installed. A new database can be created in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our single-click app installer. In either case, the needed engine will be selected automatically the moment the activation of the app begins, so you won’t need to change anything manually, irrespective of whether the app needs InnoDB or the more frequently used MyISAM. Furthermore, we’ll always be able to recover any of your MySQL databases if you accidentally erase one, as we perform several database backups every day, each of which is saved for 1 whole week.

InnoDB in Dedicated Hosting

InnoDB comes by default with all Linux dedicated servers hosting packages ordered with the Hepsia hosting Control Panel. It’s an integral part of the standard software bundle that will be installed on all Hepsia-equipped servers, so once your machine is assembled, you will be able to sign in and to install any kind of PHP-driven web application that requires this MySQL database storage engine. When you create a new MySQL database via the hosting Control Panel, there won’t be any active engine till you start installing an application. Once the app setup wizard begins importing information into the database, the engine will be set automatically based on the requirements of the given application, so you can run both MyISAM and InnoDB without selecting either of them specifically at any time. In this way, you can use an immense collection of applications for your sites.