InnoDB is a database storage engine for MySQL relational databases, which is used by popular open-source script-powered apps such as Magento and Joomla™ 3. It’s excellent for scalable applications, as it works astonishingly well when processing large data volumes. Instead of locking the whole table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can carry out much more tasks for the same length of time. Furthermore, InnoDB offers a better crash recovery and supports transactions and foreign keys – rules that specify how data imports and modifications should be handled. In case a specific task has not been thoroughly completed for some reason, the action will be rolled back. In this way, the content in the database will stay undamaged and will not be partially merged with newly entered content.
InnoDB in Hosting
You will be able to run any PHP-based web application that needs InnoDB if you have a Linux hosting plan with our company, as the MySQL storage engine is present on our cutting-edge cloud hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is required. You can activate apps that require the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be selected automatically, so you won’t have to modify anything manually at any point. On top of that, we will also create regular backups of all the databases that you’ve got in the shared hosting account, so if you erase or overwrite anything, we can swiftly get it back to the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
You can make use of an open-source script-based app that requires InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our innovative cloud platform where the MySQL storage engine is installed. A new MySQL database can be created in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – if you use our 1-click application installer. Either way, the needed engine will be chosen automatically as soon as the activation of the app starts, so you will not have to configure anything manually, no matter if the app needs InnoDB or the more widely used MyISAM. Also, we’ll always be able to restore any of your databases if you accidentally remove one, as we create several database backups every day, each of which is preserved for 1 whole week.
InnoDB in VPS Servers
All VPS plans that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to make use of any script-based software application that needs this particular MySQL database engine without having to set up anything manually. You can choose Hepsia on the VPS configuration page and your brand new Virtual Private Server will be up and running within sixty minutes, so you can sign in and start building your sites right away. Once you create a brand new MySQL database and start the app installation process, our system will choose the engine for that MySQL database automatically. Thus, you can install different apps simultaneously without editing anything on the VPS server. You can create a WordPress-based personal journal that makes use of the default MySQL engine – MyISAM, and a Magento-powered online shopping portal that makes use of InnoDB, for example.
InnoDB in Dedicated Servers
When you acquire a new dedicated server, you’ll be able to select any of the 3 Control Panels offered by us – Hepsia and cPanel. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to add this MySQL storage engine manually so as to be able to use script-based software apps that need it. InnoDB is used by scalable applications and since a dedicated server will give you all the system resources that you require to manage large-size Internet sites, it is rather likely that you’ll use InnoDB. You will be able to use other engines too, so if a particular application needs MyISAM instead of InnoDB, you won’t run into any complication while running it. The engine that will be used will be detected automatically as soon as the app installation procedure starts, so you will not need to change any settings manually whatsoever.