InnoDB is a database engine for MySQL relational databases, which is used by famous open-source script-powered software apps such as Joomla 3 and Magento. It’s excellent for scalable apps, because it works amazingly well when processing huge volumes of data. Rather than locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same length of time. Plus, InnoDB offers an improved database failure recovery and supports database transactions and foreign keys – rules that determine how data inserts and updates should be handled. If a specific task has not been entirely completed for whatever reason, the action will be rolled back. In this way, the information in the database will remain undamaged and will not be partially mixed with newly appended content.
InnoDB in Shared Website Hosting
You will be able to use any PHP script-powered web app that needs InnoDB if you’ve got a shared website hosting service with our company, as the storage engine is available on our leading-edge cloud website hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is required. You can install apps that need the MyISAM engine without encountering any problem as well and, again, the engine will be pre-selected, so you won’t have to configure any setting manually at any point. Furthermore, we will also perform regular backups of all the databases that you have in your account, so if you erase or overwrite something, we can quickly restore it the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Hosting
If you set up a brand new MySQL database through the Control Panel provided with each of our semi-dedicated server packages and you start installing a PHP-powered application either manually or using our single-click app installer, the database storage engine will be picked automatically based on the prerequisites of the specific application. As InnoDB is present on the cloud website hosting platform where your new account will be created, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any point. To prevent any risk of losing information if you update an application or if you erase a database accidentally, we’ll carry out a backup of all your MySQL databases each and every day, so if something happens, we can retrieve your data.
InnoDB in VPS Web Hosting
All VPS web hosting services that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to make use of any open-source script-based web app that requires the MySQL database engine without the need to configure anything manually. You can choose Hepsia on the VPS configuration page and your brand-new Virtual Private Server will be set up within one hour, so you can log in and start setting up your websites right away. When you create a brand new MySQL database and start the app activation process, our system will set the engine for that MySQL database automatically. In this way, you can manage various apps at the same time without having to configure anything on the server. You can create a WordPress-driven online blog that makes use of MyISAM – the default MySQL engine, and a Magento e-commerce site that makes use of the InnoDB engine, for example.
InnoDB in Dedicated Servers Hosting
If you acquire a new dedicated server, you’ll be able to select any of the 3 Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t have to add this MySQL database engine manually to be able to manage script-powered software applications that require it. InnoDB is used by scalable apps and since a dedicated server will provide you with all the server resources that you require to run large-scale Internet sites, it’s very likely that you’ll use InnoDB. You will be able to make use of other engines as well, so if a particular application requires MyISAM instead of InnoDB, you will not encounter any impediment while running it. The engine that will be used will be detected automatically once the app installation commences, so you won’t need to alter any setting manually at any point.