InnoDB is a storage engine for MySQL databases, which is used by widespread PHP-powered software applications like Joomla 3 and Magento. It’s excellent for scalable apps, as it works exceptionally well when handling huge data volumes. Rather than locking the entire database table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same period of time. Additionally, InnoDB offers a much faster database crash recovery and supports transactions and foreign key constraints – rules that prescribe how data imports and modifications should be handled. If a specific task has not been thoroughly completed for any reason, the action will be rolled back. In this way, the content in the database will remain safe and sound and will not be partially merged with new content.
InnoDB in Web Hosting
Any script-driven software application that needs InnoDB will function flawlessly on our avant-garde cloud platform and the MySQL database engine is offered with all our web hosting plans. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database in question will make use of will be selected on the basis of the app’s requirements without the need to update any setting in your account. InnoDB will be selected automatically for any application that requires this particular engine and you will be able to get the most out of its full capacity. We will store regular backups of your content, so in case you accidentally remove a database that you need or you overwrite a specific part of it, we will be able to restore everything the way it was just a few hours ago.
InnoDB in Semi-dedicated Hosting
You can run a script-powered web application that requires InnoDB with any of our semi-dedicated server plans, because all the accounts are set up on our cutting-edge cloud platform where the MySQL database engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our single-click application installer tool. In either case, the required engine will be chosen automatically the moment the installation of the application begins, so you won’t need to edit anything manually, no matter if the application requires InnoDB or the more regularly used MyISAM. On top of that, we’ll always be able to retrieve any of your databases in case you unintentionally erase one, as we perform several backups every day, each of which is preserved for 1 whole week.
InnoDB in Dedicated Web Hosting
InnoDB is available as standard with all Linux dedicated web hosting ordered with the Hepsia hosting Control Panel. It’s an integral part of the default software package that will be pre-installed on all Hepsia-equipped servers, so once your machine is set up, you will be able to log in and to install any script-based software application that needs this particular storage engine. When you set up a new MySQL database via the hosting Control Panel, there won’t be any active engine until you begin installing an application. As soon as the app configuration wizard starts entering information into the database, the engine will be chosen automatically on the basis of the requirements of the given application, so you can use both InnoDB and MyISAM without the need to select either one explicitly at any point. Thus, you can make use of a large collection of applications for your sites.