InnoDB is a very popular database engine for the MySQL DBMS. It’s an alternative to the default engine – MyISAM, and it has got a lot of strengths which make it the preferred engine for numerous script-powered software apps, among them Magento and Joomla, which have switched to InnoDB permanently. For instance, adding large data volumes will be faster with InnoDB, as it locks only a single database row to perform a particular task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the data is treated. Simply put, importing new or editing existing data will either be thoroughly completed, or will be aborted and the operation will be rolled back if a given issue appears in the meantime, which is why the content that remains in the database won’t be lost.

InnoDB in Shared Website Hosting

Any script-driven software app that requires InnoDB will function flawlessly on our avant-garde cloud hosting platform and the database storage engine comes with all our shared website hosting packages. Each time you create a database manually or our app installer tool 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 requirements without the need to modify any setting in your shared hosting account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to take advantage of its full potential. We will perform daily content backups, so if you unintentionally erase a MySQL database that you need or you overwrite some part of it, we’ll be able to restore your content the way it was only several hours earlier.

InnoDB in Semi-dedicated Servers

You can make use of a PHP-based app that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are created on our cutting-edge cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our single-click app installer. In either case, the required engine will be selected automatically the moment the application’s activation starts, so you will not need to change anything manually, regardless of whether the app needs InnoDB or the more regularly used MyISAM. On top of that, we will always be able to recover any of your databases in case you erase one by accident, as we carry out a couple of database backups every day, each of which is stored for one week.

InnoDB in Dedicated Servers

InnoDB comes as standard with all dedicated servers ordered with the Hepsia hosting Control Panel. It’s part of the software bundle that we install on all Hepsia-managed servers, so once your physical machine is set up, you will be able to sign in and to activate any type of PHP-driven software application that needs this particular MySQL database storage engine. When you set up a new database through the hosting Control Panel, there won’t be any active engine until you begin installing an application. Once the app setup wizard starts inserting information into the database, the engine will be chosen automatically based on the respective app’s prerequisites, so you can run both InnoDB and MyISAM without having to select either of them explicitly at any time. Thus, you can use an immense collection of apps for your Internet sites.