Find out about InnoDB and find out why it’s been selected as the default MySQL database engine.
InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it offers a significantly better overall performance and a faster database crash recovery in comparison to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is endorsed by many programmers that write highly scalable apps, because it works more effectively with huge volumes of data, while it keeps the server processing load at a minimum. Also, it it locks only one row in the database if any info should be updated, whereas lots of other engines lock the entire table and thus need much more time to process multiple successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for some reason, the operation is rolled back to prevent scrambling or data loss. Magento and the latest editions of Joomla™ are two instances of widely used PHP script-based web applications that have switched to InnoDB.
InnoDB in Cloud Website Hosting
Any script-based software app that needs InnoDB will function flawlessly on our avant-garde cloud hosting platform and the MySQL database engine comes with all our cloud website hosting
packages. Whenever you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will make use of will be selected based on the app’s specifications without the need to change any setting in your account. InnoDB will be chosen automatically for any app that requires this specific engine and you will be able to make the most of its full capacity. We will carry out regular backups of your content, so if you unintentionally delete a database that is important to you or you overwrite certain parts of it, we’ll be able to restore the database the way it was just a couple of hours ago.
InnoDB in Semi-dedicated Servers
InnoDB is included with all our Linux semi-dedicated plans
by default, so as soon as you get a new semi-dedicated account, you can move on and activate any script-based web application that requires the MySQL database storage engine. Several engines are installed on our cloud platform, so when you create a brand-new MySQL database and start installing an application manually, or opt to make use of the Hepsia Control Panel-integrated application installer, the engine for the database will be set based on the requirements of the given application. This will permit you to install and manage InnoDB-specific applications without having any obstacle and without updating any settings in your semi-dedicated account. To be on the safe side, we’ll always have a 7-day-old backup of all your databases, so if you erase or edit any content unintentionally, we can easily retrieve it.
InnoDB in VPS Servers
When you get a VPS server
from us, you’ll be able to use our custom-built Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will allow you to install any open-source script-based app that needs InnoDB, as this storage engine is an essential part of the standard software bundle that will be installed on the server during its creation. When you set up a brand-new database through the hosting Control Panel, you will just need to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine given that the application in question needs it, so you will not need to do anything else in your VPS account. Correspondingly, if an app needs MyISAM, it will be automatically set as the default engine for this particular database.
InnoDB in Dedicated Servers
If you buy a new dedicated server
, you’ll be able to pick any of the three Control Panels that we are offering – Hepsia, DirectAdmin and cPanel. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-installed, so you will not need to install this MySQL database engine manually so as to be able to manage script-based software apps that need it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the system resources that you need to manage very large sites, it is very likely that you will use InnoDB. You will be able to use other engines as well, so in case a specific app needs MyISAM rather than InnoDB, you won’t encounter any difficulty while managing it. The engine that will be used will be detected automatically the moment the app installation begins, so you will not need to fine-tune any settings manually whatsoever.