InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and an improved database failure recovery in comparison to the default engine that’s used by MySQL – MyISAM. InnoDB is used by many web developers that build highly scalable software applications, because it works more efficiently with enormous amounts of data, while it keeps the server load at a minimum. In addition, it locks only one database row if any info should be updated, while many other engines lock the entire table and thus require more time to complete multiple successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed successfully for some reason, the action is rolled back to avoid confusion or data loss. Magento and the latest editions of Joomla are two instances of famous open-source script-based applications that have switched to InnoDB.
InnoDB in Web Hosting
InnoDB is offered with all our web hosting service by default, not upon request or as a paid upgrade, so you will be able to install and manage any script-driven software application which requires the MySQL storage engine without encountering any obstacle once you open your account. InnoDB will be selected automatically as the default engine for a given database during the app installation process, no matter if you make use of our 1-click installation tool or create the database and activate the application manually, provided that the application requires it instead of the more famous MyISAM engine. We’ll perform daily backups of all your databases, so you can be certain that you will never lose any content in case you delete a database by mistake or you overwrite some key info – you just need to alert us and we will restore your data the way it was.
InnoDB in Semi-dedicated Servers
InnoDB comes with all our Linux semi-dedicated servers by default, so the moment you obtain a new account, you can move on and activate any PHP-based web application that requires this particular database storage engine. A number of engines are installed on our cloud web hosting platform, so when you create a brand-new database and start installing an app manually, or decide to use the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be selected in accordance with the requirements of the respective application. This will allow you to install and manage InnoDB-specific apps without the need to cope with any difficulty and without the need to edit any settings in your semi-dedicated account. To avoid any risk, we’ll always have a one-week-old backup of all your MySQL databases, so if you remove or alter any content accidentally, we can easily retrieve it.
InnoDB in VPS Servers
All Linux VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you will be able to use any PHP script-based web application that needs this particular MySQL database storage engine without needing to configure anything manually. You can pick Hepsia on the VPS order page and your new VPS server will be ready within the hour, so you can sign in and start building your Internet sites straight away. Once you create a new database and begin the app activation process, our system will pick the engine for that database automatically. In this way, you can make use of various apps simultaneously without the need to modify anything on the VPS server. You can set up a WordPress-based online journal that uses MyISAM – the default MySQL engine, and a Magento-powered Internet shop that makes use of the InnoDB engine, for example.
InnoDB in Dedicated Servers
All dedicated service ordered with our custom-developed Hepsia hosting Control Panel include a software package that’s pre-activated and among everything else, you will get the InnoDB database engine, so you will not need to install it manually if you would like to activate open-source PHP scripts that require it. All it takes to activate such a script is to create a new database and to start the installation – once the script configuration wizard obtains access to the database in question and begins entering content into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the script. You will also be able to install scripts that need MyISAM, the other widely used MySQL engine, so you will not have to change any settings on the dedicated server. This will permit you to use various scripts on one single physical server and to use the latter to its full capabilities.