What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a database engine for MySQL databases, which is used by well known open-source script-powered web apps such as Magento and Joomla™ 3.x. It is excellent for scalable apps, since it performs incredibly well when handling large amounts of data. Rather than locking the entire 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 length of time. Additionally, InnoDB offers a faster crash recovery and supports database transactions and foreign key constraints – a set of rules that determine how data imports and updates should be treated. In case a given operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. Thus, the information in the database will be retained undamaged and will not be partially mixed with newly entered content.
InnoDB in Shared Hosting
You’ll be able to install any PHP-powered application that needs InnoDB if you have a shared hosting
with us, as the MySQL database storage engine is present on our innovative cloud hosting platform as standard. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can activate apps which use the MyISAM engine without any obstacles as well and, again, the engine will be pre-selected, so you won’t need to edit anything manually at any time. In addition, we will also carry out regular backups of all the MySQL databases that you have in your shared web hosting account, so in case you erase or overwrite anything, we can swiftly get it back to the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
You can install a PHP script-based application that needs InnoDB with all of our semi-dedicated server
packages, due to the fact that all the accounts are set up on our advanced cloud hosting platform where the MySQL storage engine is installed. A new database can be created in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you make use of our single-click app installer tool. In either case, the required engine will be picked automatically as soon as the activation of the app starts, so you won’t need to update anything manually, no matter if the app needs InnoDB or the more widely used MyISAM. Furthermore, we’ll always be able to restore any of your MySQL databases if you accidentally delete one, as we perform a couple of database backups every day, each of which is saved for 1 whole week.
InnoDB in VPS Servers
All VPS hosting plans
that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you will be able to use any PHP-driven software app that needs this particular database engine without setting up anything manually. You can choose Hepsia on the VPS order page and your brand-new Virtual Private Server will be up and running within 60 minutes, so you can log in and begin setting up your Internet sites right away. When you set up a brand new MySQL database and start the app activation process, our system will set the engine for this database automatically. Thus, you can install different apps simultaneously without having to change anything on the server. You can set up a WordPress online journal that makes use of the default MySQL engine – MyISAM, and a Magento-based e-commerce site that uses InnoDB, for example.
InnoDB in Dedicated Servers
InnoDB is available as standard with all dedicated servers
that are ordered with the Hepsia hosting Control Panel. It’s an essential part of the standard software package that will be installed on all Hepsia-equipped servers, so as soon as your physical machine is up and running, you will be able to sign in and to install any kind of script-powered app that needs this storage engine. When you set up a new database through the Control Panel, there won’t be any activated engine until you begin installing an app. Once the app setup wizard begins importing data into the database, the engine will be chosen automatically on the basis of the requirements of the respective application, so you can use both MyISAM and InnoDB without having to select either one explicitly at any time. In this way, you can use a broad selection of applications for your Internet sites.