InnoDB
What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a storage engine for MySQL relational databases, which is used by widely used script-based web apps like Magento and Joomla™ 3. It’s perfect for scalable apps, as it performs astonishingly well when managing enormous data volumes. Instead of locking the entire table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out much more operations for the same period of time. Moreover, InnoDB offers a much faster crash recovery and supports database transactions and foreign keys – a set of rules that define how data imports and modifications should be treated. In case a specific operation has not been fully completed for whatever reason, the action will be rolled back. In this way, the content in the database will be kept intact and will not be partially merged with new content.
-
InnoDB in Cloud Web Hosting
While InnoDB is either not offered or it is a paid upgrade with other website hosting service providers, it’s part of the default set of features that we offer with our
cloud web hosting packages. If you wish to use a script-based app that needs InnoDB specifically, in order to be activated and to work properly, you won’t encounter any problems as the MySQL database storage engine is available on our custom-developed cloud platform. Regardless of whether you set up a new MySQL database and install an app manually or make use of our 1-click application installer software tool, InnoDB will be selected automatically by our system as the default engine if the app requires it rather than MyISAM. In addition to the remarkable database crash recovery that InnoDB offers, we also perform daily database backups, so that we can quickly restore any MySQL database in your shared account.
-
InnoDB in Semi-dedicated Hosting
If you create a new MySQL database through the Control Panel offered with all our
semi-dedicated server plans and you start installing a PHP script-powered application either manually or using our single-click app installer, the storage engine for the database will be picked automatically depending on the requirements of the app in question. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any app that requires it without any manual intervention required on your end at any time. To prevent any risk of losing data if you update an application or if you erase a database by accident, we’ll carry out backups of all your MySQL databases each day, so if anything happens, we can retrieve your data.
-
InnoDB in VPS Hosting
If you choose a
virtual private server with our Hepsia Control Panel, the InnoDB database storage engine will be an indivisible part of the default software pack that will be pre-installed on your VPS server before we hand it over to you. You won’t need to configure anything manually and you’ll be able to enable and use any open-source script-powered app that needs InnoDB as soon as your VPS is up and running, which takes no more than one hour after the order submission itself. Several engines are available, so every time you set up a database via the Hepsia Control Panel, a specific engine will be activated when the app installation process commences and our system will automatically recognize the engine that is required by the app in question. If you need to use MyISAM, for example, you will not have to do anything different than installing the preferred app, whether manually or using our app installer.
-
InnoDB in Dedicated Web Hosting
When you order a new
dedicated server, you’ll be able to pick one 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-activated, so you will not have to activate this storage engine manually so as to be able to use open-source script-powered web apps that need it. InnoDB is used for scalable applications and since a dedicated server will offer you all the system resources that you require in order to run very large websites, it’s quite likely that you’ll use InnoDB. You’ll be able to make use of other engines too, so if a particular application requires MyISAM rather than InnoDB, you will not experience any problem while managing it. The engine that will be used will be recognized automatically when the app installation commences, so you will not need to configure any setting manually at any moment.