InnoDB is a database storage engine for MySQL databases, which is used by widespread PHP script-based software apps like Joomla™ 3.x and Magento. It is ideal for scalable apps, as it performs unbelievably well when managing enormous amounts of data. Rather than locking the whole database table to add new information to a database like many other engines do, InnoDB locks only one database row, so it can process much more tasks for the same length of time. Moreover, InnoDB offers an improved database crash recovery and supports database transactions and foreign keys – rules that determine how data imports and modifications should be treated. If a certain operation has not been entirely completed for some reason, the action will be rolled back. In this way, the information in the database will stay safe and sound and won’t be partially merged with newly inserted content.
InnoDB in Shared Web Hosting
InnoDB is offered with all our Linux shared web hosting packages by default, not as a paid upgrade or upon request, so you will be able to activate and manage any PHP script-powered web app which needs the InnoDB database engine without having to deal with any obstacle as soon as you open your shared account. InnoDB will be pre-selected as the default engine for a given database during the app activation process, irrespective of whether you make use of our one-click installer or create the MySQL database and activate the app manually, on the condition that the app requires it instead of the more famous MyISAM engine. We will maintain regular MySQL database backups, so you can be sure that you won’t ever lose any data in case you delete a database by mistake or you overwrite some important information – you just need to inform us and we’ll restore your data back to normal.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with each of our semi-dedicated hosting by default, so as soon as you get a new semi-dedicated account, you can move on and install any open-source script-powered software app that needs the database engine. A couple of engines are installed on our cloud hosting platform, so when you set up a brand new database and start installing an application manually, or decide to make use of the Hepsia Control Panel-integrated app installer, the engine for the database will be set based on the prerequisites of the application in question. This will allow you to activate and run InnoDB-specific apps without the need to cope with any obstacle and without needing to configure any settings in your account. To be on the safe side, we will always keep a 1-week-old backup of all your databases, so if you erase or change any content by accident, we can swiftly recover it.
InnoDB in VPS Hosting
If you pick a virtual private server with our Hepsia Control Panel, the InnoDB storage engine will be an indivisible part of the default software bundle that will be installed on your VPS server before we give it to you. You will not need to activate anything manually and you’ll be able to enable and manage any script-based web application that requires InnoDB as soon as your VPS is ready, which takes no more than sixty minutes after the order submission itself. A number of engines are offered, so whenever you create a MySQL database through the Hepsia Control Panel, a specific engine will be picked once the app installation starts and our system will detect the engine that is required by the app in question. In case you have to use MyISAM, for example, you won’t need to do anything different than installing the app of your preference, whether manually or using our app installer.
InnoDB in Dedicated Web Hosting
All Linux dedicated web hosting that are ordered with our custom-developed Hepsia hosting Control Panel include a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB storage engine, so you won’t need to install it manually in case you would like to activate open-source scripts that require it. All it takes to install such a script is to create a new database and to start the setup process – as soon as the setup wizard acquires access to the database and starts entering content into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You’ll also be able to activate scripts that need the other popular MySQL engine, MyISAM, so you will not have to configure any settings on the server. This will enable you to install different scripts on one single machine and to use it to its maximum capabilities.