InnoDB
Find out more about InnoDB and see why it’s been selected as the default MySQL database engine.
InnoDB is a storage engine for MySQL databases, which is used by well known PHP script-based apps like Magento and Joomla™ 3.x. It is ideal for scalable applications, since it excels in processing immense volumes of data. Rather than locking the whole table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can perform a lot more tasks for the same period of time. Also, InnoDB offers an improved crash recovery and supports transactions and foreign key constraints – rules that specify how data imports and updates should be treated. If a certain task hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will be kept undamaged and won’t be partially merged with newly entered content.
-
InnoDB in Shared Web Hosting
While InnoDB is either not offered or it is a paid upgrade with other web hosting providers, it’s included in the standard set of services that we are offering with our
shared web hosting plans. If you want to use a script-driven app that needs InnoDB in particular, in order to be installed and to perform properly, you won’t face any impediments because the MySQL database engine is available on our custom-built cloud platform. No matter if you create a brand-new database and activate an application manually or use our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the given application needs it rather than MyISAM. Besides the remarkable crash recovery that InnoDB offers, we also keep regular database backups, so we can quickly recover any database in your shared website hosting account.
-
InnoDB in Semi-dedicated Servers
You can use a PHP-based software app that requires InnoDB with any of our
semi-dedicated server packages, due to the fact that all the accounts are set up on our leading-edge cloud hosting platform where the storage engine is installed. A new database can be created in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our 1-click application installer. Either way, the needed engine will be chosen automatically the moment the app’s installation begins, so you will not have to configure anything manually, regardless of whether the app needs InnoDB or the more frequently used MyISAM. Furthermore, we will always be able to restore any of your MySQL databases if you accidentally remove one, as we carry out a few backups every day, each of which is saved for seven days.
-
InnoDB in VPS Servers
If you get a
VPS server with our Hepsia hosting Control Panel, the InnoDB storage engine will be included in the standard software bundle that will be installed on your server before we give it to you. You will not have to activate anything manually and you will be able to install and manage any PHP-driven app that needs InnoDB as soon as your VPS server is up and running, which takes no more than one hour after the order submission procedure itself. A number of engines are available, so whenever you set up a database using the Hepsia hosting Control Panel, a specific engine will be picked when the app activation commences and our system will automatically recognize the engine that is required by the app in question. In case you need MyISAM, for instance, you won’t have to do anything different than installing the preferred application, whether manually or using our app installer.
-
InnoDB in Dedicated Servers
If you obtain a new
dedicated server, you will be able to select any of the 3 hosting Control Panels offered by our company – cPanel, Hepsia and DirectAdmin. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to install this MySQL database storage engine manually in order to be able to use PHP-driven applications that require it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the resources that you need to manage large-size websites, it is very likely that you will resort to InnoDB. You will be able to make use of other engines too, so if a given app needs MyISAM rather than InnoDB, you will not come across any complication while running it. The engine that will be used will be detected automatically the moment the app installation process starts, so you will not have to tweak any settings manually at any point.