InnoDB is a database storage engine for MySQL databases, which is used by famous open-source script-driven apps such as Joomla 3.x and Magento. It’s excellent for scalable apps, because it works very well when processing huge volumes of data. Rather than locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can complete much more tasks for the same length of time. Additionally, InnoDB offers a better database failure recovery and supports database transactions and foreign keys – rules that indicate how data inserts and modifications should be handled. In case a specific task hasn’t been entirely completed for any reason, the action will be rolled back. In this way, the database content will be kept intact and will not be partially mixed with newly appended content.
InnoDB in Shared Web Hosting
You’ll be able to install any PHP-driven software application that requires InnoDB in case you have a shared web hosting with our company, as the MySQL storage engine is available on our avant-garde cloud hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can run applications that need the MyISAM engine without the need to deal with any difficulty as well and, again, the engine will be selected automatically, so you will not have to change any setting manually at any point. What’s more, we will also carry out regular backups of all the MySQL databases that you have in the account, so in case you erase or overwrite anything, we can quickly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
If you create a brand new MySQL database through the hosting Control Panel offered with all our semi-dedicated server packages and you begin installing an open-source script-driven web app either manually or using our single-click app installer, the MySQL database storage engine will be picked automatically on the basis of the prerequisites of the particular app. As InnoDB is present on the cloud platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that requires it without the need for any manual action on your end at any moment. To avoid any risk of losing information if you update an app or if you remove a database by accident, we will make backups of all your databases each day, so if anything goes wrong, we can retrieve your content.
InnoDB in VPS Servers
If you order a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be an essential part of the standard software pack that will be installed on your VPS server before we hand it over to you. You will not need to configure anything manually and you will be able to install and use any open-source script-based web app that needs InnoDB once your VPS is set up, which takes no more than one hour after the order submission process itself. A number of engines are offered, so anytime you set up a MySQL database via the Hepsia Control Panel, a specific engine will be selected when the app installation process begins and our system will automatically detect the engine that is required by the app in question. In case you need to use MyISAM, for instance, you will not need to do anything different than installing the desired application, whether manually or using our app installer.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the features which you can choose on the server configuration page when you purchase a dedicated server from us. Since this is the most powerful kind of website hosting, it is pretty likely that you’ll run highly popular websites that will draw lots of people, and since InnoDB is among the best options for such websites, we’ll activate it along with all the other software apps that are offered with a Hepsia-managed server. When you set up a brand new database in your dedicated account, there won’t be any activated MySQL database engine till you begin installing a script, whether manually through your browser or using the automatic scripts installation tool that is included in the hosting Control Panel. The required engine will be recognized automatically and will be assigned to that database, so you can activate scripts that require InnoDB, as well as ones that need the default MySQL engine – MyISAM, without having to cope with any difficulty.