InnoDB is a storage engine for MySQL databases, which is used by famous script-driven software applications such as Magento and Joomla 3.x. It is perfect for scalable apps, since it performs very well when handling large amounts of data. Rather than locking the whole table to add new information to a database as many other engines do, InnoDB locks only one row, so it can execute a lot more tasks for the same length of time. Moreover, InnoDB offers a faster database failure recovery and supports database transactions and foreign keys – a set of rules that specify how data imports and modifications should be treated. In case a certain task hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will stay intact and won’t be partially mixed with newly appended content.
InnoDB in Shared Web Hosting
InnoDB is available with all our shared web hosting plans by default, not upon request or as a paid upgrade, so you’ll be able to install and run any script-driven software application which needs the MySQL database engine without encountering any obstacle once you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app activation process, regardless of whether you make use of our 1-click installer or create the database and activate the app manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We will keep daily MySQL database backups, so you can rest assured that you’ll never lose any content in case you delete a database by accident or you overwrite some key info – you just have to get in touch with us and we will restore the database the way it was.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated servers come with InnoDB and you’ll be able to use all the features offered by this MySQL storage engine with any open-source script-driven web application that needs it. InnoDB is among the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the prerequisites of the given application. You won’t have to do anything manually in order to activate InnoDB, as it will be set as the default engine when you install an application – whether manually or using our single-click app installer. To avoid any risk, we will carry out regular database backups, so if anything goes wrong after some update or if you remove some content accidentally, we will be able to get your database back to the way it was on any of the previous seven days.
InnoDB in VPS Servers
If you choose a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be included in the standard software package that will be pre-installed on your VPS server before we give it to you. You won’t have to configure anything manually and you’ll be able to enable and use any open-source script-based software app that requires InnoDB when your Virtual Private Server is ready, which takes no more than one hour after the order submission itself. A couple of engines are offered, so every time you create a MySQL database through the Hepsia Control Panel, a specific engine will be selected when the app activation starts and our system will automatically recognize which engine is required by the app in question. In case you have to use MyISAM, for example, you won’t have to do anything different than installing the chosen application, whether manually or using our application installer tool.
InnoDB in Dedicated Servers
All dedicated servers that are ordered with our custom-developed Hepsia Control Panel come with a software package that is pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you won’t have to add it manually in case you need to activate PHP scripts that need it. All it takes to use such a script is to set up a new MySQL database and to begin the setup – as soon as the setup wizard obtains access to the database in question and starts entering data into it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the script. You will also be able to use scripts that need MyISAM, the other popular MySQL engine, so you will not have to change any settings on the server. This will allow you to activate different scripts on one single physical machine and to use it to its full capacity.