Find out more about InnoDB and find out why it’s already been selected as the default MySQL database engine.
InnoDB is a database storage engine for MySQL databases, which is used by widespread script-powered software apps like Joomla™ v3 and Magento. It’s perfect for scalable apps, because it performs astonishingly well when processing enormous volumes of data. Instead of locking the whole database table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can perform a lot more operations for the same length of time. Besides, InnoDB offers a much faster database failure recovery and supports transactions and foreign key constraints – rules that prescribe how data imports and modifications should be handled. If a given task has not been fully completed for whatever reason, the action will be rolled back. Thus, the database content will be kept intact and won’t be partially mixed with newly appended content.
InnoDB in Shared Web Hosting
Any PHP script-powered application that requires InnoDB will run flawlessly on our advanced cloud website hosting platform and the database storage engine is offered with all our shared web hosting
packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected on the basis of the app’s prerequisites without having to edit any setting in your account. InnoDB will be chosen automatically for any app that requires this particular engine and you will be able to take advantage of its full capacity. We’ll generate daily content backups, so if you accidentally erase a database that you need or you overwrite specific parts of it, we will be able to restore your content the way it was only a couple of hours ago.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated packages
support InnoDB and you can take advantage of all the options offered by this database engine with any script-powered software application that needs it. It is among the engines that are available on our cloud website hosting platform, so the one that will be used depends on the prerequisites of the specific application. You won’t have to do anything manually in order to enable InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our one-click application installer. To avoid any risk, we’ll keep regular database backups, so if something goes wrong following an upgrade or if you erase some data by accident, we will be able to get your database back to the way it was on any of the previous 7 days.
InnoDB in VPS Web Hosting
When you purchase a virtual private server
from our company, you will be able to take full advantage of our custom-built Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will permit you to install any PHP-driven web app which requires InnoDB, as this MySQL storage engine is included in the software package that will be installed on the Virtual Private Server during its setup. When you create a brand-new MySQL database through the Control Panel, you just need to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine as long as the app in question requires it, so you will not have to do anything else in your VPS account. Similarly, if a given app needs MyISAM, it will be automatically set as the default engine for this specific database.
InnoDB in Dedicated Servers Hosting
If you get a new dedicated server
, you’ll be able to choose one of the 3 Control Panels that we’re offering – Hepsia, DirectAdmin and cPanel. Any server ordered with Hepsia comes with InnoDB pre-installed, so you will not need to add this database engine manually so as to be able to run PHP-driven web apps that require it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you require to manage large-size sites, it’s rather likely that you will resort to InnoDB. You’ll be able to use other engines as well, so in case a certain app requires MyISAM instead of InnoDB, you won’t have any obstacle while managing it. The engine that will be used will be recognized automatically the moment the app installation begins, so you will not need to edit any settings manually at any time.