Find out more on InnoDB and find out why it’s recently been selected as the default MySQL database engine.
InnoDB is a storage engine for MySQL relational databases, which is used by popular script-based applications such as Joomla™ 3 and Magento. It is excellent for scalable apps, since it works stunningly well when processing enormous data volumes. Rather than locking the entire table to add new information to a database as many other engines do, InnoDB locks only one row, so it can process much more tasks for the same period of time. Also, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – a set of rules that define how data imports and updates should be treated. In case a certain operation hasn’t been entirely completed for whatever reason, the action will be rolled back. Thus, the content in the database will be preserved intact and will not be partially mixed with newly inserted content.
InnoDB in Shared Hosting
You will be able to run any open-source script-powered web application that requires InnoDB if you’ve got a Linux shared hosting
with our company, as the database engine is present on our leading-edge cloud website hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is needed. You can run applications that need the MyISAM engine without any problem as well and, once again, the engine will be pre-selected, so you won’t need to configure any setting manually at any point. Furthermore, we’ll also generate daily backups of all the MySQL databases that you have in the shared account, so in case you delete or overwrite anything, we can easily restore it the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting
support InnoDB and you’ll be able to take advantage of all the options offered by this MySQL database engine with any PHP-powered software app that requires it. It’s among the engines that are available on our cloud platform, so the one that will be selected depends on the given app’s requirements. You will not have to do anything manually to enable InnoDB, because it will be set as the default engine when you install an application – whether manually or using our single-click app installer tool. To avoid any risk, we’ll keep daily MySQL database backups, so if anything goes wrong following an update or if you remove some content unintentionally, we will be able to get your database back to the way it was on any of the previous 7 days.
InnoDB in VPS
If you order a virtual private server
with our Hepsia hosting Control Panel, the InnoDB database storage engine will be part of the standard software package that will be installed on your Virtual Private Server before we hand it over to you. You will not have to set up anything manually and you’ll be able to install and use any script-driven app that needs InnoDB once your Virtual Private Server is set up, which takes no more than one hour after the order submission procedure itself. A couple of engines are offered, so every time you create a MySQL database via the Hepsia hosting Control Panel, a specific engine will be selected when the app installation process commences and our system will automatically recognize which engine is required by the app in question. If you need to use MyISAM, for instance, you will not need to do anything different than installing the chosen app, whether manually or using our app installer.
InnoDB in Dedicated Hosting
When you buy a new dedicated server
, you’ll be able to select any of the 3 Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Each server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to enable this MySQL database storage engine manually in order to be able to use PHP script-driven software apps that need it. InnoDB is used for scalable applications and since a dedicated server will provide you with all the resources that you require to manage very large websites, it’s rather possible that you’ll use InnoDB. You will be able to make use of other engines too, so if a certain app requires MyISAM rather than InnoDB, you won’t run into any impediment while using it. The engine that will be used will be automatically detected once the app installation process begins, so you won’t need to edit any setting manually at any time.