InnoDB is a storage engine for MySQL databases, which is used by well known script-based web applications like Magento and Joomla™ 3.x. It’s ideal for scalable apps, as it performs exceptionally well when processing enormous volumes of data. Instead of locking the entire table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can handle much more tasks for the same period of time. Additionally, InnoDB offers an improved crash recovery and supports database transactions and foreign keys – a set of rules that determine how data imports and modifications should be treated. If a given task has not been fully completed for whatever reason, the action will be rolled back. In this way, the database content will remain intact and won’t be partially merged with newly entered content.
InnoDB in Shared Hosting
InnoDB is available with all our Linux shared hosting by default, not upon request or as a paid upgrade, so you can install and run any open-source script-powered software application which requires the database engine without having to deal with any impediment once you order your shared account. InnoDB will be pre-selected as the default engine for a specific MySQL database during the app installation, regardless of whether you use our one-click installer or create the MySQL database and set up the application manually, as long as the app requires it instead of the more popular MyISAM engine. We’ll maintain regular MySQL database backups, so you can be sure that you won’t ever lose any data in case you delete a database unintentionally or you overwrite some essential info – you will just have to contact us and we’ll restore your content the way it was.
InnoDB in Semi-dedicated Servers
You can activate an open-source script-powered app that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are set up on our innovative cloud platform where the storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our single-click app installer tool. In either case, the required engine will be chosen automatically as soon as the installation of the application begins, so you won’t have to update anything manually, regardless of whether the application needs InnoDB or the more frequently used MyISAM. Also, we’ll always be able to recover any of your databases in case you delete one by mistake, as we carry out a couple of backups every day, each of which is stored for 1 week.
InnoDB in VPS Servers
If you choose a VPS server with our Hepsia Control Panel, the InnoDB database engine will be an integral part of the standard software bundle that will be installed on your VPS server before we give it to you. You won’t need to configure anything manually and you will be able to install and manage any open-source script-based software app that needs InnoDB once your VPS is ready, which takes no more than sixty minutes after the order submission procedure itself. A number of engines are available, so anytime you set up a MySQL database via the Hepsia hosting Control Panel, a specific engine will be picked when the app activation commences and our system will recognize which engine is required by the application in question. In case you need to use MyISAM, for example, you will not have to do anything different from installing the chosen app, whether manually or using our application installer.
InnoDB in Dedicated Servers
InnoDB comes by default with all Linux dedicated service ordered with the Hepsia Control Panel. It is part of the standard software package that we install on all Hepsia-managed dedicated servers, so once your physical machine is up and running, you’ll be able to log in and to install any PHP-driven web application that needs this MySQL database storage engine. When you set up a new MySQL database through the hosting Control Panel, there won’t be any active engine till you begin installing an application. Once the app setup wizard begins inserting content into the newly created database, the engine will be selected automatically depending on the respective app’s requirements, so you can use both MyISAM and InnoDB without having to select either of them specifically at any time. Therefore, you can use a large collection of applications for your sites.