Find out about InnoDB and see why it’s recently been chosen as the default MySQL database engine.
InnoDB is a database storage engine for MySQL databases, which is used by widely used open-source script-based web applications such as Joomla™ 3.x and Magento. It’s ideal for scalable apps, since it performs really well when handling huge data volumes. Rather than locking the entire database table to append new information to a database like many other engines do, InnoDB locks only one row, so it can complete a lot more tasks for the same period of time. Furthermore, InnoDB offers a much faster crash recovery and supports transactions and foreign key constraints – a set of rules that determine how data inserts and modifications should be treated. In case a certain task has not been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will stay undamaged and won’t be partially mixed with newly added content.
InnoDB in Cloud Web Hosting
Any script-powered software application that needs InnoDB will function impeccably on our avant-garde cloud platform and the MySQL database storage engine comes with all our cloud web hosting
plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected on the basis of the app’s prerequisites without the need to edit any setting in your shared account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to make the most of its full potential. We’ll keep daily backups of your content, so if you unintentionally erase a MySQL database that is important to you or you overwrite a certain part of it, we’ll be able to restore your content the way it was only a few hours ago.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with each of our semi-dedicated hosting
by default, so as soon as you buy a new semi-dedicated account, you can go on and install any PHP script-based app that requires this MySQL database storage engine. A number of engines are installed on our cloud website hosting platform, so when you create a brand new database and begin installing an app manually, or decide to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be selected based on the prerequisites of the specific application. This will permit you to activate and run InnoDB-specific apps without needing to deal with any difficulty and without needing to modify any settings in your account. To be on the safe side, we will always have a 7-day-old backup of all your MySQL databases, so if you erase or change any content by mistake, we can easily rescue it.
InnoDB in VPS Web Hosting
In case our custom-developed Hepsia hosting Control Panel is picked during the signup process for a new Linux VPS web hosting packages
, InnoDB will be activated on the server along with other needed software, so you will not have to do anything if you choose to use PHP script-driven software apps that need this MySQL storage engine. MyISAM, the default MySQL engine, will be installed too. You can set up a brand-new MySQL database and start the app installation procedure manually or through our one-click installation tool. The system will automatically recognize which engine the particular application needs and will assign it to the specific MySQL database, so the installation process will proceed flawlessly and the application can insert its content into that database. In this way, you can use applications with different requirements with regard to the MySQL engine without making any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers Hosting
Our Hepsia Control Panel is one of the features which you can pick on the server configuration page when you purchase a dedicated server
from us. As this is the most powerful kind of website hosting, it is rather likely that you will manage very popular Internet sites that will draw lots of people, and since InnoDB is one of the best choices for such websites, we’ll activate it along with all the other software applications that are offered with a Hepsia-equipped dedicated server. When you set up a brand new MySQL database in your dedicated server account, there won’t be any activated MySQL database engine till you start installing a script, whether manually through your browser or using the automatic script installation tool that is integrated into the Control Panel. The required engine will be automatically detected and will be assigned to that database, so you can activate scripts that need InnoDB, as well as ones that need MyISAM – the default MySQL engine, without having to deal with any problem.