InnoDB is a database storage engine for MySQL relational databases, which is used by widely used PHP-driven applications like Joomla v3 and Magento. It is ideal for scalable applications, as it performs exceptionally well when managing huge volumes of data. Instead of locking the entire database table to insert new information in a database as many other engines do, InnoDB locks only one row, so it can carry out a lot more tasks for the same length of time. Also, InnoDB offers an improved crash recovery and supports transactions and foreign keys – a set of rules that indicate how data imports and updates should be handled. In case a certain task hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the information in the database will be kept safe and sound and won’t be partially mixed with newly inserted content.

InnoDB in Cloud Web Hosting

You will be able to make use of any script-based software app that requires InnoDB in case you’ve got a cloud web hosting with our company, as the MySQL storage engine is present on our leading-edge cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is required. You can install applications which need the MyISAM engine without any obstacles as well and, once again, the engine will be pre-selected, so you won’t need to configure any setting manually at any point. Furthermore, we’ll also carry out regular backups of all the MySQL databases that you’ve got in your shared web hosting account, so in case you delete or overwrite something, we can quickly restore it the way it was on any of the past seven days.

InnoDB in Semi-dedicated Servers

You can make use of an open-source script-driven web app that needs InnoDB with all of our semi-dedicated server packages, due to the fact that all the accounts are created on our advanced cloud web hosting platform where the database engine is installed. A new MySQL database can be created in two separate ways – manually from the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you take advantage of our one-click application installer tool. In either case, the needed engine will be selected automatically once the application’s activation starts, so you won’t need to change anything manually, no matter if the app requires InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to restore any of your databases in case you accidentally erase one, as we make a couple of backups every day, each of which is preserved for one whole week.

InnoDB in VPS Servers

If you order a VPS server from us, you’ll be able to take advantage of our in-house developed Hepsia hosting Control Panel to manage your web content. A Hepsia-managed VPS will permit you to activate any PHP script-powered web app that needs InnoDB, as this storage engine is an essential part of the software bundle that will be pre-installed on your VPS server during its configuration. When you set up a brand-new database using the Control Panel, you will simply have to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine in case the app in question requires it, so you will not have to do anything else in your VPS account. Identically, if an app requires MyISAM, it will be automatically set as the default engine for this particular MySQL database.

InnoDB in Dedicated Servers

InnoDB is included as standard with all dedicated servers ordered with the Hepsia Control Panel. It’s included in the standard software package that will be pre-installed on all Hepsia-managed servers, so as soon as your physical machine is set up, you’ll be able to log in and to activate any kind of PHP-powered web application that needs this particular MySQL database engine. If you create a new MySQL database through the hosting Control Panel, there won’t be any activated engine till you start installing an application. Once the app setup wizard starts dumping data in the database, the engine will be chosen automatically in accordance with the requirements of the particular application, so you can run both InnoDB and MyISAM without having to select either one explicitly at any time. In this way, you can use a broad selection of applications for your Internet sites.