InnoDB is a database engine for MySQL relational databases, which is used by widely used open-source script-powered web apps such as Joomla™ v3 and Magento. It is perfect for scalable apps, because it performs exceptionally well when managing immense amounts of data. Instead of locking the whole table to append new information to a database like many other engines do, InnoDB locks only one database row, so it can process a lot more tasks for the same period of time. Also, InnoDB offers a better crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data inserts and modifications should be treated. In case a particular task hasn’t been fully completed for some reason, the action will be rolled back. Thus, the information in the database will be retained undamaged and will not be partially mixed with newly imported content.
InnoDB in Cloud Website Hosting
You can use any script-based software application that needs InnoDB if you have a Linux cloud website hosting with us, as the storage engine is present on our cutting-edge cloud platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is needed. You can activate applications which need the MyISAM engine without having to deal with any difficulty as well and, again, the engine will be pre-selected, so you will not have to configure any setting manually at any moment. Furthermore, we will also make daily backups of all the databases that you have in the shared account, so if you delete or overwrite something, we can swiftly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Hosting
InnoDB comes with all our semi-dedicated hosting by default, so as soon as you buy a new account, you can move on and install any script-powered app that needs this storage engine. A couple of engines are pre-installed on our cloud hosting platform, so when you create a brand new database and start installing an application manually, or decide to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be set based on the requirements of the given app. This will allow you to activate and manage InnoDB-specific applications without having to cope with any difficulty and without needing to modify any settings in your account. To take no chances, we’ll always keep a one-week-old backup of all your databases, so if you remove or edit any content accidentally, we can easily restore it.
InnoDB in VPS
If you pick a virtual private server with our Hepsia Control Panel, the InnoDB storage engine will be an indivisible part of the standard software package that will be installed on your VPS server before we give it to you. You will not have to set up anything manually and you’ll be able to enable and manage any open-source script-powered web app that requires InnoDB when your VPS is ready, which takes no more than one hour after the order process itself. Several engines are offered, so anytime you create a database via the Hepsia Control Panel, a particular engine will be activated when the app activation commences and our system will automatically recognize which engine is required by the application in question. In case you have to use MyISAM, for example, you won’t need to do anything different from installing the preferred app, whether manually or using our application installer.
InnoDB in Dedicated Hosting
InnoDB comes by default with all Linux dedicated hosting that are ordered with the Hepsia Control Panel. It is an integral part of the software bundle that we install on all Hepsia-managed dedicated servers, so as soon as your physical machine is up and running, you will be able to log in and to install a various PHP-driven software application that requires this storage engine. If you create a new database via the Control Panel, there won’t be any active engine till you begin installing an app. Once the app configuration wizard starts inserting data into the database, the engine will be selected automatically in accordance with the prerequisites of the particular application, so you can run both MyISAM and InnoDB without selecting either of them explicitly at any moment. Thus, you can use a wide range of apps for your websites.