InnoDB is a database engine for MySQL databases, which is used by widely used script-based web apps such as Magento and Joomla v3. It is excellent for scalable apps, because it performs really well when processing enormous volumes of data. Instead of locking the entire table to add new information to a database as many other engines do, InnoDB locks only one row, so it can complete a lot more operations for the same length of time. Besides, InnoDB offers an improved database failure recovery and supports database transactions and foreign keys – rules that indicate how data inserts and updates should be treated. In case a particular operation has not been fully completed for whatever reason, the action will be rolled back. Thus, the database content will stay undamaged and won’t be partially merged with new content.

InnoDB in Shared Hosting

InnoDB is offered with all our shared hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any PHP script-driven application that needs the InnoDB database engine without any difficulty once you order your shared web hosting account. InnoDB will be pre-selected as the default engine for a given database during the app installation process, no matter if you use our one-click installer or create the database and install the app manually, as long as the app requires it instead of the more popular MyISAM engine. We’ll carry out regular backups of all your databases, so you can be certain that you won’t ever lose any content in case you erase a database by accident or you overwrite some vital info – you will just need to notify us and we’ll restore your data the way it was.

InnoDB in Semi-dedicated Servers

You can run an open-source script-based web application that needs InnoDB with all of our semi-dedicated server packages, since all the accounts are set up on our avant-garde cloud hosting platform where the storage engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our one-click app installer tool. Either way, the needed engine will be chosen automatically as soon as the activation of the app begins, so you will not need to edit anything manually, regardless of whether the app needs InnoDB or the more commonly used MyISAM. In addition, we will always be able to recover any of your databases in case you remove one by mistake, as we carry out a few database backups every day, each of which is stored for one whole week.

InnoDB in VPS Servers

If you select a VPS server with our Hepsia Control Panel, the InnoDB database engine will be part of the standard software pack that will be installed on your server before we give it to you. You will not have to activate anything manually and you will be able to enable and run any PHP script-driven app that needs InnoDB as soon as your VPS is up and running, which takes no more than 60 minutes after the order submission process itself. A number of engines are offered, so every time you set up a MySQL database using the Hepsia hosting Control Panel, a specific engine will be selected once the app installation begins and our system will automatically recognize which engine is required by the app in question. In case you have to use MyISAM, for example, you will not have to do anything different than installing the preferred app, whether manually or using our application installer tool.

InnoDB in Dedicated Servers

InnoDB is included by default with all dedicated servers that are ordered with the Hepsia hosting Control Panel. It’s an integral part of the software bundle that we install on all Hepsia-equipped servers, so as soon as your physical machine is ready, you’ll be able to log in and to activate any script-based web app that requires this particular database storage engine. If you create a new database through the hosting Control Panel, there won’t be any activated engine till you begin installing an application. Once the app configuration wizard begins entering information into the database, the engine will be set automatically depending on the prerequisites of the application in question, so you can run both MyISAM and InnoDB without having to select either one of them explicitly at any point. Thus, you can make use of a vast variety of apps for your websites.