InnoDB
What?s InnoDB? Why has it been used as the standard MySQL storage engine?
InnoDB is a storage engine for MySQL relational databases, which is used by popular script-based web applications such as Joomla™ 3 and Magento. It is perfect for scalable apps, because it excels in handling large data volumes. Instead of locking the whole table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can execute a lot more tasks for the same period of time. Additionally, InnoDB offers a faster database crash recovery and supports database transactions and foreign key constraints – a set of rules that prescribe how data inserts and modifications should be treated. If a specific task has not been entirely completed for some reason, the action will be rolled back. In this way, the information in the database will be retained undamaged and will not be partially merged with newly appended content.
-
InnoDB in Shared Website Hosting
You will be able to make use of any script-driven application that needs InnoDB if you’ve got a
shared website hosting with us, as the database storage engine is available on our cutting-edge cloud website hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is required. You can activate applications that require the MyISAM engine without having any difficulty as well and, once again, the engine will be selected automatically, so you won’t need to configure any setting manually at any moment. On top of that, we’ll also make regular backups of all the databases that you’ve got in your shared web hosting account, so in case you erase or overwrite something, we can easily restore it the way it was on any of the past seven days.
-
InnoDB in Semi-dedicated Servers
InnoDB is available with each of our
Linux semi-dedicated plans by default, so the moment you obtain a new semi-dedicated account, you can move on and install any PHP-driven web app that needs this MySQL storage engine. A number of engines are installed on our cloud website hosting platform, so when you set up a brand-new database and begin installing an application manually, or decide to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be set on the basis of the prerequisites of the respective app. This will permit you to install and run InnoDB-specific apps without running into any complication and without needing to update any settings in your account. To avoid any risk, we will always keep a 7-day-old backup of all your MySQL databases, so if you delete or edit any content by accident, we can swiftly restore it.
-
InnoDB in VPS Servers
If you select a
VPS server with our Hepsia hosting Control Panel, the InnoDB database storage engine will be an essential part of the standard software bundle that will be installed on your server before we give it to you. You won’t have to configure anything manually and you’ll be able to install and run any PHP-driven web app that needs InnoDB when your Virtual Private Server is set up, which takes no more than one hour after the order submission itself. A couple of engines are offered, so every time you set up a database through the Hepsia Control Panel, a specific engine will be picked when the app installation process commences and our system will detect which engine is required by the app in question. If you need MyISAM, for instance, you will not need to do anything different than installing the desired app, whether manually or using our application installer tool.
-
InnoDB in Dedicated Servers
If you buy a new
dedicated server, you will be able to select 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 will not have to install this database storage engine manually to be able to manage PHP-based applications that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the resources that you require to run large-scale websites, it is pretty likely that you’ll use InnoDB. You will be able to make use of other engines too, so in case a certain app requires MyISAM instead of InnoDB, you won’t run into any complication while running it. The engine that will be used will be automatically recognized as soon as the app installation procedure commences, so you will not need to fine-tune any setting manually at any point.