InnoDB is a storage engine for MySQL relational databases, which is used by famous PHP script-driven web applications such as Joomla 3 and Magento. It is ideal for scalable applications, because it performs astonishingly well when handling huge data volumes. Instead of locking the entire table to enter new information into a database like many other engines do, InnoDB locks only one row, so it can complete much more tasks for the same period of time. What’s more, InnoDB offers a much better crash recovery and supports transactions and foreign key constraints – a set of rules that specify how data imports and updates should be treated. In case a certain task has not been fully completed for whatever reason, the action will be rolled back. Thus, the information in the database will be retained safe and sound and won’t be partially merged with newly imported content.

InnoDB in Web Hosting

Any open-source script-based app that needs InnoDB will function impeccably on our leading-edge cloud platform and the MySQL database storage engine is available with all our web hosting packages. Whenever you create a MySQL database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will use will be selected based on the app’s specifications without the need to update any setting in your shared account. InnoDB will be chosen automatically for any application that requires this particular engine and you will be able to take advantage of its full capacity. We will store regular backups of your content, so in case you unintentionally remove a database that is important to you or you overwrite a specific part of it, we’ll be able to restore everything the way it was only several hours ago.

InnoDB in Semi-dedicated Servers

You can install an open-source script-based software application that requires InnoDB with any of our semi-dedicated server plans, as all the accounts are created on our avant-garde cloud hosting platform where the database storage engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our one-click app installer tool. Either way, the required engine will be selected automatically once the application’s activation begins, so you will not have to change anything manually, irrespective of whether the app needs InnoDB or the more commonly used MyISAM. On top of that, we will always be able to recover any of your databases in case you delete one by accident, as we perform a couple of database backups every day, each of which is stored for one week.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an indivisible part of the software bundle that will be pre-installed on your server before we hand it over to you. You will not have to configure anything manually and you will be able to install and use any open-source script-based software application that requires InnoDB once your VPS is set up, which takes no more than one hour after the order submission procedure itself. A couple of engines are available, so whenever you set up a database using the Hepsia hosting Control Panel, a particular engine will be activated when the app activation commences and our system will automatically detect the engine that is required by the app in question. In case you have to use MyISAM, for instance, you won’t need to do anything different from installing the chosen application, whether manually or using our app installer.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options that you can choose on the server order page when you buy a dedicated server from us. As this is the most powerful type of website hosting, it’s pretty likely that you will run popular Internet sites that will attract plenty of visitors, and since InnoDB is among the best options for such websites, we will activate it along with all the other software applications that are available with a Hepsia-managed dedicated server. When you create a new database in your dedicated account, there won’t be any activated MySQL database engine until you start installing an open-source PHP script, whether manually via your browser or using the automatic scripts installer that is included in the hosting Control Panel. The necessary engine will be automatically recognized and will be set for the database in question, so you can run scripts that need InnoDB, as well as ones that need MyISAM, the default MySQL engine, without encountering any obstacle.