Discover what a database engine is, what are the merits of the InnoDB engine and why it's gaining that much popularity.
InnoDB is a database storage engine for MySQL relational databases, which is used by famous open-source script-driven software apps such as Joomla™ v3 and Magento. It’s excellent for scalable apps, as it works astonishingly well when processing huge data volumes. Instead of locking the whole table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can complete much more operations for the same period of time. What’s more, InnoDB offers a much faster crash recovery and supports transactions and foreign key constraints – rules that specify how data inserts and updates should be handled. If a specific task has not been thoroughly completed for some reason, the action will be rolled back. Thus, the content in the database will be retained safe and sound and won’t be partially mixed with new content.
InnoDB in Cloud Web Hosting
InnoDB is available with all our cloud web hosting
by default, not upon request or as a paid upgrade, so you can install and run any PHP script-based web application that needs the MySQL database engine without having to deal with any problem once you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation, irrespective of whether you use our 1-click installer or create the database and activate the app manually, on the condition that the application requires it instead of the more popular MyISAM engine. We will create regular backups of all your databases, so you can be sure that you will never lose any content in case you erase a database by mistake or you overwrite some crucial info – you’ll just have to touch base with us and we’ll restore your content back to normal.
InnoDB in Semi-dedicated Hosting
You can run a script-driven software app that requires InnoDB with all of our semi-dedicated server
plans, as all the accounts are set up on our avant-garde cloud platform where the MySQL database storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you make use of our single-click app installer. In either case, the needed engine will be chosen automatically as soon as the installation of the app starts, so you will not have to change anything manually, irrespective of whether the application needs InnoDB or the more widely used MyISAM. Also, we will always be able to restore any of your databases in case you accidentally erase one, as we create a few MySQL database backups every day, each of which is stored for one whole week.
InnoDB in VPS Hosting
In case our custom Hepsia hosting Control Panel is chosen during the signup process for your new Linux VPS hosting packages
, InnoDB will be installed on the server along with other essential software, so you won’t need to do anything if you choose to install open-source script-based web apps that need this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed too. You can set up a brand-new database and begin the app installation process manually or through our one-click installation tool. The system will automatically detect which engine the app in question needs and will assign it to the specific MySQL database, so the installation will continue impeccably and the app can import its content into that database. Therefore, you can manage apps with various requirements concerning the MySQL engine without the need to make any modifications on your VPS.
InnoDB in Dedicated Web Hosting
If you acquire a new dedicated server
, you’ll be able to select one of the three hosting Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to activate this database storage engine manually to be able to use PHP script-based apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the server resources that you need in order to run very large sites, it is rather possible that you will use InnoDB. You’ll be able to use other engines too, so if a particular app needs MyISAM rather than InnoDB, you won’t have to deal with any difficulty while running it. The engine that will be used will be automatically recognized as soon as the app installation starts, so you won’t need to configure any settings manually at any moment.