InnoDB is a storage engine for MySQL databases, which is used by popular PHP-based apps such as Joomla 3 and Magento. It is ideal for scalable applications, as it performs really well when processing enormous amounts 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 handle a lot more operations for the same length of time. Besides, InnoDB offers an improved crash recovery and supports database transactions and foreign keys – rules that define how data inserts and updates should be handled. If a certain task has not been thoroughly completed for whatever reason, the action will be rolled back. Thus, the content in the database will stay intact and won’t be partially merged with newly imported content.
InnoDB in Shared Web Hosting
InnoDB is offered with all our shared web hosting by default, not upon request or as a paid upgrade, so you will be able to install and manage any script-powered web app which requires the database storage engine without having any difficulty once you order your shared web hosting account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation, no matter if you take advantage of our 1-click installation tool or create the MySQL database and set up the application manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We will create daily backups of all your MySQL databases, so you can be certain that you won’t ever lose any data in case you erase a database by mistake or you overwrite some vital information – you’ll just have to inform us and we will restore your data back to normal.
InnoDB in Semi-dedicated Hosting
InnoDB comes with each of our semi-dedicated hosting by default, so as soon as you order a new semi-dedicated account, you can move on and install any open-source script-based web application that needs this database storage engine. A couple of engines are installed on our cloud hosting platform, so when you create a brand new database and begin installing an application manually, or decide to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be chosen on the basis of the prerequisites of the given app. This will allow you to activate and run InnoDB-specific apps without needing to deal with any difficulty and without updating any settings in your account. To take no chances, we will always have a one-week-old backup of all your databases, so if you delete or alter any content unintentionally, we can easily recover it.
InnoDB in VPS
If you obtain a virtual private server from our company, you will be able to use our custom-developed Hepsia Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to use any script-driven software app which needs InnoDB, as this particular MySQL database storage engine is an integral part of the software bundle that will be pre-installed on the Virtual Private Server during its creation. When you set up a new database through the hosting Control Panel, you’ll just have to start installing an app – manually or using our application installer. InnoDB will be set as the default engine given that the app in question requires it, so you won’t have to do anything else in your account. Similarly, if a certain application requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Hosting
All Linux dedicated hosting services that are ordered with our custom-developed Hepsia hosting Control Panel include a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB database engine, so you won’t need to add it manually if you want to use scripts that require it. All it takes to activate such a script is to set up a new database and to initiate the installation – once the script configuration wizard gets access to the database in question and starts entering content into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You’ll also be able to install scripts that need the other widely used MySQL engine, MyISAM, so you will not have to modify any settings on the server. This will allow you to run different scripts on one single physical server and to use the latter to its fullest capacity.