What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a storage engine for MySQL databases, which is used by famous PHP-driven web apps like Joomla™ 3.x and Magento. It’s excellent for scalable apps, because it works really well when managing huge volumes of data. Instead of locking the whole database table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same length of time. Additionally, InnoDB offers a much faster database failure recovery and supports database transactions and foreign keys – a set of rules that indicate how data inserts and modifications should be treated. If a particular task has not been entirely completed for any reason, the action will be rolled back. Thus, the information in the database will remain intact and will not be partially mixed with newly added content.
InnoDB in Shared Web Hosting
Any script-based app that requires InnoDB will function flawlessly on our cutting-edge cloud hosting platform and the database engine is offered with all our shared web hosting
packages. Every time you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database will make use of will be selected in accordance with the app’s specifications without having to update any setting in your shared hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to make the most of its full potential. We will maintain regular backups of your content, so in case you unintentionally remove a MySQL database that you need or you overwrite specific parts of it, we’ll be able to restore your database the way it was just a few hours ago.
InnoDB in Semi-dedicated Hosting
All our semi-dedicated hosting services
come with InnoDB and you can get the most out of all the options offered by this MySQL database engine with any script-driven web application that requires it. It’s one of the engines that are available on our cloud website hosting platform, so the one that will be picked depends on the prerequisites of the respective app. You will not have to do anything manually in order to activate InnoDB, since it will be set as the default engine when you install an application – whether manually or using our 1-click app installer. To avoid any risk, we will store regular backups of all your MySQL databases, so if something goes wrong after some update or if you delete some data accidentally, we will be able to get your database back to the way it was on any of the past seven days.
InnoDB in VPS Hosting
If our in-house built Hepsia Control Panel is picked during the signup process for your new Linux virtual private servers
, InnoDB will be activated on the VPS server together with other necessary software, so you will not have to do anything if you choose to make use of PHP script-driven software applications that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed too. You can set up a brand-new database and begin the app installation manually or through our 1-click installer. The system will automatically detect the engine that the particular application needs and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the application can insert its data into that database. In this way, you can install apps with various prerequisites about the MySQL engine without having to make any modifications on your Virtual Private Server.
InnoDB in Dedicated Web Hosting
When you acquire a new dedicated server
, you’ll be able to select one of the 3 Control Panels offered by us – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you won’t have to add this database storage engine manually in order to be able to run open-source script-driven web apps that require it. InnoDB is used by scalable apps and since a dedicated server will give you all the system resources that you need to manage large-scale sites, it is pretty possible that you will use InnoDB. You will be able to make use of other engines too, so in case a given app needs MyISAM instead of InnoDB, you will not encounter any impediment while managing it. The engine that will be used will be automatically detected when the app installation procedure starts, so you won’t need to change any settings manually at any moment.