InnoDB is a database engine for MySQL databases, which is used by famous PHP script-based applications such as Magento and Joomla 3.x. It’s ideal for scalable applications, as it performs really well when managing immense data volumes. Instead of locking the whole database table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can perform a lot more tasks for the same length of time. Also, InnoDB offers a much better database failure recovery and supports database transactions and foreign keys – a set of rules that specify how data inserts and updates should be treated. In case a given task hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the content in the database will stay safe and sound and will not be partially mixed with newly inserted content.

InnoDB in Shared Hosting

Every PHP script-driven software app that requires InnoDB will function impeccably on our cutting-edge cloud web hosting platform and the MySQL database storage engine is available with all our shared hosting plans. Every time you create a database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database will use will be selected in accordance with the app’s requirements without the need to update any setting in your hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you’ll be able to take advantage of its full capacity. We will perform daily content backups, so in case you accidentally remove a database that’s important to you or you overwrite a certain part of it, we will be able to restore your content the way it was just a couple of hours earlier.

InnoDB in Semi-dedicated Hosting

InnoDB is available with each of our Linux semi-dedicated hosting by default, so as soon as you buy a new account, you can move on and install any open-source script-powered software app that needs this storage engine. A few engines are installed on our cloud website hosting platform, so when you create a brand new MySQL database and start installing an application manually, or decide to take advantage of the Hepsia Control Panel-integrated app installer, the engine for the database will be chosen based on the requirements of the app in question. This will permit you to activate and manage InnoDB-specific applications without needing to deal with any difficulty and without configuring any settings in your account. To avoid any risk, we’ll always have a 1-week-old backup of all your databases, so if you delete or edit any content unintentionally, we can easily restore it.

InnoDB in VPS Web Hosting

If our in-house developed Hepsia Control Panel is chosen during the signup process for a new Linux virtual private servers , InnoDB will be installed on the VPS server along with other needed pieces of software, so you will not need to do anything if you choose to activate script-based web apps that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated too. You can create a brand new database and start the app installation procedure manually or through our 1-click installer tool. The system will detect which engine the particular app requires and will assign it to the specific MySQL database, so the installation will proceed flawlessly and the application can insert its data into that database. Therefore, you can activate apps with various prerequisites about the MySQL engine without the need to make any changes on your VPS server.

InnoDB in Dedicated Servers Hosting

InnoDB is included as standard with all dedicated servers hosting ordered with the Hepsia Control Panel. It is part of the default software bundle that we install on all Hepsia-managed dedicated servers, so as soon as your machine is ready, you’ll be able to log in and to install any kind of script-powered web app that needs this particular storage engine. If you set up a new database through the hosting Control Panel, there won’t be any activated engine till you begin installing an app. Once the app installation wizard begins dumping content in the newly created database, the engine will be selected automatically based on the prerequisites of the given application, so you can use both MyISAM and InnoDB without selecting either one of them explicitly at any time. In this way, you can make use of a broad selection of apps for your Internet sites.