Find out about InnoDB and find out why it’s been picked out as the default MySQL database engine.
InnoDB is a database engine for MySQL relational databases, which is used by widespread PHP-driven software apps such as Magento and Joomla™ 3.x. It’s excellent for scalable apps, since it performs stunningly well when processing large 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 complete a lot more tasks for the same length of time. Additionally, InnoDB offers a much faster database failure recovery and supports transactions and foreign keys – a set of rules that prescribe how data imports and updates should be treated. If a particular task has not been fully completed for whatever reason, the action will be rolled back. In this way, the information in the database will stay intact and won’t be partially mixed with newly imported content.
InnoDB in Shared Hosting
InnoDB is available with all our shared hosting
by default, not as a paid upgrade or upon request, so you can activate and manage any PHP script-powered web app which requires the MySQL database storage engine without the need to deal with any obstacle as soon as you open your shared account. InnoDB will be pre-selected as the default engine for a certain MySQL database during the app activation process, no matter if you use our 1-click installation tool or create the database and install the application manually, on the condition that the application requires it instead of the more popular MyISAM engine. We will carry out regular backups of all your databases, so you can be certain that you will never lose any data in case you delete a database unintentionally or you overwrite some essential info – you just have to contact us and we will restore everything back to normal.
InnoDB in Semi-dedicated Servers
You can run a PHP script-powered app that requires InnoDB with any of our semi-dedicated server
plans, because all the accounts are set up on our innovative cloud hosting platform where the database storage engine is installed. A new MySQL database can be created in two different ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you take advantage of our one-click app installer. Either way, the required engine will be selected automatically once the activation of the app starts, so you won’t have to change anything manually, no matter if the app needs InnoDB or the more widely used MyISAM. Also, we’ll always be able to retrieve any of your databases in case you unintentionally delete one, as we generate several MySQL database backups every day, each of which is kept for one whole week.
InnoDB in VPS Servers
If you pick a VPS server
with our Hepsia Control Panel, the InnoDB database engine will be part of the standard software package that will be installed on your Virtual Private Server before we hand it over to you. You won’t need to activate anything manually and you’ll be able to enable and run any PHP-based software application that needs InnoDB once your VPS is ready, which takes no more than sixty minutes after the order submission itself. Several engines are offered, so whenever you set up a database through the Hepsia Control Panel, a particular engine will be picked once the app installation starts and our system will automatically recognize which engine is required by the app in question. In case you have to use MyISAM, for example, you won’t need to do anything different from installing the desired application, whether manually or using our application installer.
InnoDB in Dedicated Servers
When you get a new dedicated server
, you’ll be able to choose any of the three hosting Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t need to enable this MySQL database engine manually in order to be able to use PHP script-powered software applications that require it. InnoDB is used by scalable apps and since a dedicated server will give you all the resources that you need to manage large-scale websites, it’s pretty possible that you will resort to InnoDB. You’ll be able to make use of other engines as well, so in case a certain app needs MyISAM instead of InnoDB, you won’t have to deal with any predicament while using it. The engine that will be used will be recognized automatically the moment the app installation process commences, so you will not need to fine-tune any setting manually whatsoever.