InnoDB is a storage engine for MySQL relational databases, which is used by well known PHP script-based web applications like Magento and Joomla 3.x. It’s excellent for scalable applications, as it performs exceptionally well when processing enormous data volumes. Instead of locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can handle a lot more tasks for the same period of time. Moreover, InnoDB offers an improved database crash recovery and supports transactions and foreign key constraints – a set of rules that indicate how data imports and updates should be handled. If a given task hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will remain intact and won’t be partially merged with newly added content.
InnoDB in Shared Website Hosting
Every PHP-based app that requires InnoDB will function flawlessly on our avant-garde cloud web hosting platform and the database storage engine is available with all our shared website hosting packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will make use of will be selected in accordance with the app’s prerequisites without the need to configure any setting in your account. InnoDB will be chosen automatically for any application that requires this particular engine and you’ll be able to make the most of its full potential. We’ll store regular backups of your content, so if you accidentally delete a database that is important to you or you overwrite a certain part of it, we’ll be able to restore your data the way it was only a couple of hours ago.
InnoDB in Semi-dedicated Servers
You can activate a PHP-powered software app that requires InnoDB with any of our semi-dedicated server plans, because all the accounts are set up on our advanced cloud platform where the database engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our 1-click app installer. In either case, the needed engine will be picked automatically as soon as the app’s installation starts, so you will not have to modify anything manually, regardless of whether the app requires InnoDB or the more frequently used MyISAM. In addition, we’ll always be able to restore any of your MySQL databases in case you unintentionally erase one, as we carry out a couple of MySQL database backups every day, each of which is preserved for 1 week.
InnoDB in VPS Servers
If our custom-built Hepsia Control Panel is picked during the registration process for your new VPS servers , InnoDB will be installed on the Virtual Private Server together with other required pieces of software, so you won’t have to do anything if you choose to activate PHP-driven software applications that require this MySQL storage engine. The default MySQL engine – MyISAM, will be installed too. You can create a new database and start installing the app manually or using our single-click installer. The system will detect which engine the particular application needs and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the app can insert its content into that database. Thus, you can manage applications with various requirements regarding the MySQL engine without having to make any changes on your VPS.
InnoDB in Dedicated Servers
InnoDB is included by default with all dedicated service that are ordered with the Hepsia hosting Control Panel. It’s part of the default software package that will be pre-installed on all Hepsia-equipped servers, so as soon as your machine is assembled, you will be able to sign in and to activate any kind of PHP script-powered web application that requires this particular database engine. If you set up a new MySQL database via the Control Panel, there won’t be any activated engine until you begin installing an application. Once the app setup wizard starts dumping content in the database, the engine will be selected automatically based on the respective app’s prerequisites, 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 an immense variety of applications for your Internet sites.