InnoDB is a database storage engine for MySQL relational databases, which is used by widely used script-based software applications such as Joomla 3.x and Magento. It’s perfect for scalable apps, since it excels in handling huge amounts 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 carry out much more operations for the same period of time. In addition, InnoDB offers a better database failure recovery and supports transactions and foreign keys – rules that define how data inserts and updates should be handled. If a certain operation hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will stay intact and will not be partially merged with newly inserted content.
InnoDB in Shared Hosting
InnoDB is available with all our Linux shared hosting packages by default, not as a paid upgrade or upon request, so you can activate and manage any PHP script-based web application which requires the MySQL database storage engine without having to deal with any obstacle as soon as you open your shared hosting account. InnoDB will be selected automatically as the default engine for a certain database during the app activation process, irrespective of whether you take advantage of our 1-click installation tool or create the database and set up the app manually, as long as the application requires InnoDB instead of the more famous MyISAM engine. We’ll generate regular backups of all your MySQL databases, so you can be certain that you won’t ever lose any data if you delete a database by accident or you overwrite some key information – you will simply need to get in touch with us and we will restore your database back to normal.
InnoDB in Semi-dedicated Hosting
InnoDB is included with each of our semi-dedicated packages by default, so as soon as you obtain a new semi-dedicated account, you can move on and activate any open-source script-powered application that needs this particular database engine. Several engines are installed on our cloud platform, so when you create a brand new MySQL database and begin installing an application manually, or decide to use the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be chosen based on the requirements of the respective app. This will allow you to install and manage InnoDB-specific apps without any impediments and without the need to configure any settings in your semi-dedicated account. To avoid any risk, we’ll always have a one-week-old backup of all your databases, so if you erase or alter any content by accident, we can swiftly restore it.
InnoDB in VPS
All Linux VPS that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you’ll be able to take advantage of any PHP-powered software application that requires this particular MySQL storage engine without the need to configure anything manually. You can choose Hepsia on the VPS configuration page and your brand-new VPS server will be ready within the hour, so you can sign in and start building your websites straight away. Once you create a brand-new MySQL database and begin the app activation process, our system will select the engine for this MySQL database automatically. In this way, you can run various apps at the same time without editing anything on the VPS server. You can create a WordPress-based personal blog that makes use of MyISAM – the default MySQL engine, and a Magento-based shopping portal that uses the InnoDB engine, for example.
InnoDB in Dedicated Hosting
InnoDB comes as standard with all dedicated servers hosting packages that are ordered with the Hepsia Control Panel. It’s part of the default software bundle that we install on all Hepsia-managed dedicated servers, so as soon as your machine is assembled, you’ll be able to log in and to activate any type of open-source script-powered web application that requires this MySQL database storage engine. If you set up a new database through the Control Panel, there won’t be any active engine till you start installing an application. As soon as the app activation wizard begins importing information into the newly created database, the engine will be set automatically depending on the requirements of the application in question, so you can use both MyISAM and InnoDB without having to select either one specifically at any point. Therefore, you can make use of a broad range of applications for your sites.