InnoDB is a database storage engine for MySQL relational databases, which is used by widespread script-based applications such as Joomla™ 3.x and Magento. It’s excellent for scalable applications, since it performs very well when processing huge volumes of data. Rather than locking the whole table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can handle a lot more tasks for the same period of time. Moreover, InnoDB offers a much better crash recovery and supports database transactions and foreign keys – a set of rules that prescribe how data inserts and modifications should be handled. In case a given operation hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the information in the database will remain intact and won’t be partially merged with newly entered content.
InnoDB in Shared Hosting
Every script-powered application that requires InnoDB will run flawlessly on our leading-edge cloud web hosting platform and the database engine comes with all our shared hosting plans. Every time you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s specifications without the need to edit any setting in your hosting account. InnoDB will be selected automatically for any app that requires this specific engine and you’ll be able to make the most of its full potential. We will maintain daily backups of your content, so in case you accidentally erase a MySQL database that you need or you overwrite specific parts of it, we will be able to restore the database the way it was just several hours earlier.
InnoDB in Semi-dedicated Servers
You can run a PHP script-driven app that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our innovative cloud hosting platform where the storage engine is installed. A new MySQL database can be created in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you take advantage of our one-click app installer tool. In either case, the needed engine will be chosen automatically once the application’s activation begins, so you will not have to edit anything manually, no matter if the app needs InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases if you remove one by mistake, as we perform several database backups every day, each of which is preserved for seven days.
InnoDB in VPS Servers
In case our custom-built Hepsia Control Panel is selected during the registration process for a new VPS servers , InnoDB will be activated on the VPS server together with other necessary pieces of software, so you won’t need to do anything if you choose to install script-driven web apps that need this MySQL storage engine. The default MySQL engine, MyISAM, will be installed as well. You can set up a brand-new database and begin the app installation process manually or through our one-click installer. The system will automatically detect which engine the particular application requires and will assign it to the specific MySQL database, so the installation process will continue flawlessly and the application can insert its data into that database. Thus, you can use apps with various prerequisites in regard to the MySQL engine without having to make any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers
InnoDB is included by default with all Linux dedicated service that are ordered with the Hepsia Control Panel. It is an essential part of the default software package that we install on all Hepsia-managed servers, so once your machine is set up, you will be able to sign in and to install any kind of open-source script-powered web application that needs this MySQL storage engine. When you create a new database through the Control Panel, there won’t be any active engine till you begin installing an application. Once the app configuration wizard begins dumping information in the newly created database, the engine will be chosen automatically in accordance with the prerequisites of the specific app, so you can use both MyISAM and InnoDB without selecting either of them explicitly at any point. Thus, you can make use of an immense range of applications for your Internet sites.