What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a storage engine for MySQL databases, which is used by widespread open-source script-powered applications like Joomla™ 3 and Magento. It is excellent for scalable apps, since it performs exceptionally well when processing huge amounts of data. Instead of locking the whole table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can perform a lot more tasks for the same period of time. Additionally, InnoDB offers a faster database failure recovery and supports transactions and foreign key constraints – rules that define how data imports and modifications should be treated. In case a certain operation hasn’t been entirely completed for any reason, the action will be rolled back. In this way, the information in the database will be kept intact and will not be partially merged with newly imported content.
InnoDB in Shared Website Hosting
While InnoDB is either not offered or it is a paid upgrade with other web hosting companies, it is an essential part of the standard set of services that we’re offering with our shared website hosting
plans. If you’d like to make use of a PHP script-powered app that needs InnoDB particularly, in order to be activated and to perform correctly, you will not have to deal with any problems since the database engine is available on our in-house built cloud Internet hosting platform. Regardless of whether you set up a brand new MySQL database and install an app manually or take advantage of our one-click app installer instrument, InnoDB will be selected automatically by our system as the default engine if the app needs it rather than MyISAM. In addition to the amazing crash recovery that InnoDB is offering, we also perform daily backups of all databases, so we can quickly restore any database in your shared hosting account.
InnoDB in Semi-dedicated Hosting
If you set up a brand new MySQL database from the hosting Control Panel provided with all our semi-dedicated server
plans and you begin installing an open-source script-based web app either manually or using our one-click app installer tool, the storage engine for the MySQL database will be selected automatically on the basis of the requirements of the given application. As InnoDB is available on the cloud platform where your new semi-dedicated server account will be set up, it will be set as the default engine for any app that needs it without any manual intervention needed on your end at any moment. To avoid any risk of losing information if you update an application or if you erase a database accidentally, we’ll carry out a backup of all your MySQL databases each day, so if something happens, we can restore your data.
InnoDB in VPS Web Hosting
If you get a virtual private server
with our Hepsia Control Panel, the InnoDB storage engine will be part of the default software bundle that will be pre-installed on your VPS server before we hand it over to you. You won’t have to set up anything manually and you will be able to enable and manage any PHP script-driven web application that requires InnoDB once your Virtual Private Server is set up, which takes no more than one hour after the order submission procedure itself. Several engines are available, so anytime you create a database through the Hepsia Control Panel, a specific engine will be picked when the app installation begins and our system will automatically detect which engine is required by the application in question. In case you need to use MyISAM, for example, you won’t have to do anything different than installing the app of your preference, whether manually or using our application installer tool.
InnoDB in Dedicated Servers Hosting
If you purchase a new dedicated server
, you will be able to choose one of the three hosting Control Panels offered by our company – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t have to add this MySQL storage engine manually in order to be able to manage open-source script-based software apps that require it. InnoDB is used for scalable applications and since a dedicated server will supply you with all the system resources that you require to run large-size websites, it is very possible that you’ll use InnoDB. You’ll be able to make use of other engines too, so if a specific app requires MyISAM rather than InnoDB, you won’t have any obstacle while using it. The engine that will be used will be automatically recognized as soon as the app installation begins, so you won’t need to tweak any setting manually whatsoever.