InnoDB is a database engine for MySQL relational databases, which is used by famous PHP script-driven web apps such as Joomla 3.x and Magento. It’s perfect for scalable applications, since it performs remarkably well when handling immense data volumes. Rather than locking the whole database table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can process much more tasks for the same period of time. Additionally, InnoDB offers a much faster crash recovery and supports database transactions and foreign keys – rules that define how data imports and modifications should be treated. In case a particular operation hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the database content will be preserved safe and sound and will not be partially mixed with newly entered content.

InnoDB in Cloud Hosting

InnoDB is offered with all our Linux cloud packages by default, not upon request or as a paid upgrade, so you’ll be able to install and manage any open-source script-powered software app that requires the database engine without the need to deal with any difficulty once you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation, irrespective of whether you make use of our single-click installation tool or create the MySQL database and install the application manually, provided that the app requires it instead of the more popular MyISAM engine. We’ll create daily database backups, so you can be certain that you won’t ever lose any content if you erase a database unintentionally or you overwrite some crucial info – you will just need to inform us and we’ll restore your database the way it was.

InnoDB in Semi-dedicated Hosting

You can activate an open-source script-based app that requires InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are created on our avant-garde cloud hosting platform where the database engine is installed. A new database can be set up in two ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you make use of our single-click application installer. In either case, the required engine will be selected automatically once the installation of the application starts, so you will not have to modify anything manually, irrespective of whether the app needs InnoDB or the more frequently used MyISAM. On top of that, we’ll always be able to retrieve any of your databases in case you erase one by mistake, as we make a few MySQL database backups every day, each of which is kept for 1 whole week.

InnoDB in VPS

If our in-house developed Hepsia Control Panel is picked during the signup process for a new Linux VPS packages , InnoDB will be installed on the Virtual Private Server along with other necessary software, so you will not have to do anything if you decide to use PHP-powered software apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be activated as well. You can create a brand-new database and begin the app installation procedure manually or through our 1-click installation tool. The system will detect the engine that the particular app requires and will set it for the specific MySQL database, so the installation will proceed impeccably and the app can import its content into that database. Thus, you can run applications with different prerequisites about the MySQL engine without the need to make any modifications on your VPS.

InnoDB in Dedicated Hosting

InnoDB comes as standard with all Linux dedicated servers hosting packages that are ordered with the Hepsia hosting Control Panel. It is an integral part of the standard software bundle that will be pre-installed on all Hepsia-equipped dedicated servers, so once your physical machine is ready, you will be able to sign in and to install any type of open-source script-driven web app that needs this MySQL database engine. If you create a new MySQL database via the hosting Control Panel, there won’t be any activated engine till you begin installing an app. Once the app configuration wizard begins dumping information in the newly created database, the engine will be chosen automatically depending on the given app’s prerequisites, so you can use both InnoDB and MyISAM without the need to select either one explicitly at any time. In this way, you can use an immense selection of applications for your websites.