InnoDB is a database engine for MySQL databases, which is used by widely used PHP-driven applications such as Joomla™ 3 and Magento. It is perfect for scalable apps, because it performs very well when managing large amounts of data. Rather than 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 carry out much more operations for the same period of time. Plus, InnoDB offers a much better database failure recovery and supports transactions and foreign keys – rules that define how data imports and modifications should be treated. If a particular 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 preserved intact and will not be partially merged with newly inserted content.
InnoDB in Hosting
InnoDB is offered with all our hosting plans
by default, not upon request or as a paid upgrade, so you can activate and manage any PHP script-based software app that needs the MySQL storage engine without the need to deal with any complication as soon as you open your shared hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app installation process, no matter if you use our 1-click installer or create the database and set up the app manually, on the condition that the application requires it instead of the more popular MyISAM engine. We will perform regular backups of all your databases, so you can be certain that you won’t ever lose any content if you erase a database unintentionally or you overwrite some important info – you’ll just have to get in touch with us and we will restore everything the way it was.
InnoDB in Semi-dedicated Servers
You can activate a PHP script-powered software application that requires InnoDB with any of our semi-dedicated server
plans, as all the accounts are set up on our avant-garde cloud platform where the database engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our one-click app installer. Either way, the needed engine will be chosen automatically the moment the installation of the app starts, so you will not have to modify anything manually, regardless of whether the app needs InnoDB or the more frequently used MyISAM. Also, we will always be able to recover any of your databases in case you accidentally erase one, as we carry out a couple of backups every day, each of which is stored for one week.
InnoDB in VPS Servers
If you order a VPS server
from our company, you’ll be able to take advantage of our in-house built Hepsia Control Panel to manage your content. A Hepsia-managed VPS will permit you to run any open-source script-based app that requires InnoDB, as this MySQL database storage engine is an integral part of the standard software package that will be pre-installed on the server during its configuration. When you set up a new database via the hosting Control Panel, you’ll just need to begin installing an application – manually or using our app installer. InnoDB will be set as the default engine in case the app in question needs it, so you will not need to do anything else in your VPS account. Equivalently, if a given app requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Servers
InnoDB comes by default with all dedicated web hosting plans
that are ordered with the Hepsia hosting Control Panel. It is part of the software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so as soon as your physical machine is set up, you’ll be able to log in and to install any type of PHP-based software application that needs this storage engine. When you set up a new MySQL database through the Control Panel, there won’t be any activated engine till you begin installing an application. Once the app installation wizard starts entering data into the newly created database, the engine will be set automatically on the basis of the requirements of the app in question, so you can use both InnoDB and MyISAM without having to select either of them specifically at any time. In this way, you can make use of an immense range of applications for your websites.