InnoDB
Learn what a database engine is, what exactly are the advantages of the InnoDB engine and why it's gaining that much popularity.
InnoDB is a storage engine for MySQL relational databases, which is used by widespread script-powered software applications such as Magento and Joomla™ 3. It is excellent for scalable apps, since it works exceptionally well when managing large data volumes. Instead of locking the whole table to add new information to a database as many other engines do, InnoDB locks only one database row, so it can handle a lot more tasks for the same length of time. Furthermore, InnoDB offers an improved crash recovery and supports transactions and foreign key constraints – rules that define how data imports and modifications should be treated. In case a given task has not been fully completed for whatever reason, the action will be rolled back. Thus, the information in the database will remain safe and sound and won’t be partially merged with newly appended content.
-
InnoDB in Shared Hosting
You will be able to run any PHP script-powered web app that needs InnoDB in case you’ve got a
shared plan with our company, as the MySQL database engine is available on our leading-edge cloud web hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably if this engine is needed. You can run apps that require the MyISAM engine without any problem as well and, once again, the engine will be pre-selected, so you will not need to configure anything manually at any point. On top of that, we will also perform daily backups of all the MySQL databases that you have in your shared account, so if you erase or overwrite something, we can swiftly get it back to the way it was on any of the past seven days.
-
InnoDB in Semi-dedicated Servers
All our
semi-dedicated hosting plans include InnoDB and you’ll be able to make the most of all the features offered by this MySQL database storage engine with any PHP script-driven web application that requires it. It is one of the engines that are available on our cloud web hosting platform, so the one that will be used depends on the requirements of the given application. You won’t need to do anything manually to enable InnoDB, because it will be set as the default engine when you install an app – whether manually or using our 1-click app installer tool. To avoid any risk, we will perform daily backups of all your MySQL databases, so if something goes wrong following an update or if you remove some content unintentionally, we will be able to get your database back to the way it was on any of the past seven days.
-
InnoDB in Dedicated Servers
InnoDB is included as standard with all
dedicated web hosting plans that are ordered with the Hepsia Control Panel. It is part of the software bundle that will be installed on all Hepsia-equipped servers, so as soon as your physical machine is ready, you will be able to sign in and to install any type of PHP script-driven software app that requires this particular MySQL storage engine. If you set up a new database through the hosting Control Panel, there won’t be any activated engine till you begin installing an app. As soon as the app setup wizard starts importing data into the database, the engine will be picked automatically on the basis of the prerequisites of the specific application, so you can use both InnoDB and MyISAM without the need to select either one of them specifically at any moment. Therefore, you can make use of a wide selection of applications for your websites.