InnoDB is a very popular storage engine for MySQL. It’s an alternative to the default engine – MyISAM, and it has plenty of strengths which make it the engine of choice for many script-driven web applications, including Magento and Joomla™, which have switched to InnoDB for good. For example, importing large volumes of data will be faster with InnoDB, as it locks only one database row to perform a specific task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the information is handled. To put it simply, importing new or modifying existing data will either be fully completed, or will be aborted and the procedure will be rolled back in case some problem occurs in the meantime, therefore the content that remains in the database will not be lost.

InnoDB in Shared Web Hosting

Every open-source script-powered web application that needs InnoDB will function impeccably on our avant-garde cloud web hosting platform and the database storage engine comes with all our shared web hosting plans. Whenever you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s prerequisites without the need to modify any setting in your shared account. InnoDB will be picked automatically for any app that requires this specific engine and you’ll be able to make the most of its full capacity. We’ll create daily backups of your content, so in case you accidentally delete a MySQL database that is important to you or you overwrite a certain part of it, we’ll be able to restore the database the way it was just a few hours earlier.

InnoDB in Semi-dedicated Hosting

InnoDB is available with all our Linux semi-dedicated hosting by default, so the moment you order a new account, you can go ahead and install any PHP script-powered software app that needs this particular MySQL database storage engine. A number of engines are installed on our cloud hosting platform, so when you create a new MySQL database and start installing an app manually, or opt to make use of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be chosen in accordance with the given app’s requirements. This will permit you to activate and run InnoDB-specific applications without the need to deal with any difficulty and without having to edit any settings in your semi-dedicated account. To avoid any risk, we’ll always keep a seven-day-old backup of all your MySQL databases, so if you delete or alter any content unintentionally, we can easily restore it.

InnoDB in VPS Hosting

If you acquire a virtual private server from us, you’ll be able to use our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to use any script-based software app which needs InnoDB, as this MySQL database engine is an integral part of the software bundle that will be pre-installed on the VPS server during its setup. When you create a brand-new database through the hosting Control Panel, you’ll just need to start installing an application – manually or using our application installer tool. InnoDB will be set as the default engine on the condition that the application in question needs it, so you won’t have to do anything else in your VPS account. Likewise, if an app needs MyISAM, it will be automatically set as the default engine for this specific database.

InnoDB in Dedicated Web Hosting

All Linux dedicated web hosting that are ordered with our custom Hepsia Control Panel include a software package that’s pre-activated and among everything else, you will get the InnoDB database engine, so you will not have to activate it manually in case you want to run open-source PHP scripts that require it. All it takes to install such a script is to create a new MySQL database and to start the setup – once the setup wizard gets access to the database in question and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You will also be able to install scripts that need the other widely used MySQL engine – MyISAM, so you will not have to modify any settings on the server. This will permit you to install various scripts on a single machine and to use it to its full potential.