Find what a database engine is, what exactly are the pros of the InnoDB engine and why it's gaining so much global popularity.
InnoDB is a very popular storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got lots of advantages that have made it the engine of choice for plenty of script-based apps, including Magento and Joomla™, which have switched over to InnoDB permanently. For example, importing enormous data volumes will be much faster with InnoDB, since it locks only a single row to perform a particular operation, not the entire table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the information is treated. To put it simply, adding new or modifying existing data will either be thoroughly completed, or will be aborted and the procedure will be rolled back in case a given issue occurs during the process, hence the content that remains in the database will not be lost.
InnoDB in Shared Website Hosting
InnoDB is available with all our Linux shared website hosting packages
by default, not as a paid upgrade or upon request, so you’ll be able to install and run any open-source script-based software application that requires the MySQL storage engine without encountering any problem as soon as you order your shared account. InnoDB will be selected automatically as the default engine for a particular database during the app installation process, irrespective of whether you make use of our 1-click installer or create the database and set up the app manually, as long as the app requires it instead of the more famous MyISAM engine. We’ll keep regular backups of all your MySQL databases, so you can be certain that you won’t ever lose any content if you delete a database by mistake or you overwrite some essential information – you simply have to notify us and we will restore your data back to normal.
InnoDB in Semi-dedicated Hosting
You can use an open-source script-driven software app that needs InnoDB with all of our semi-dedicated server
packages, because all the accounts are set up on our cutting-edge cloud hosting platform where the MySQL database storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our 1-click app installer. Either way, the required engine will be selected automatically the moment the application’s activation begins, so you will not need to change anything manually, irrespective of whether the application needs InnoDB or the more regularly used MyISAM. On top of that, we will always be able to restore any of your MySQL databases in case you erase one by accident, as we carry out a few MySQL database backups every day, each of which is kept for 7 days.
InnoDB in VPS
If our in-house built Hepsia Control Panel is picked during the registration process for a new Linux VPS packages
, InnoDB will be installed on the Virtual Private Server along with other essential software, so you will not need to do anything if you decide to use open-source script-powered applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed as well. You can create a new MySQL database and begin the app installation manually or using our 1-click installer tool. The system will automatically detect which engine the application in question requires and will set it for the specific MySQL database, so the installation process will proceed impeccably and the application can insert its data into that database. Therefore, you can make use of apps with various prerequisites in regard to the MySQL engine without the need to make any changes on your server.
InnoDB in Dedicated Hosting
When you get a new dedicated server
, you will be able to pick one of the 3 hosting Control Panels that we’re offering – Hepsia, DirectAdmin and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to enable this database engine manually so as to be able to use script-based web apps that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you need to manage large-scale Internet sites, it’s pretty possible that you will resort to InnoDB. You will be able to make use of other engines as well, so if a given application requires MyISAM instead of InnoDB, you will not need to deal with any impediment while using it. The engine that will be used will be detected automatically when the app installation starts, so you won’t need to alter any setting manually at any point.