InnoDB is a database storage engine for MySQL databases, which is used by well known open-source script-based web apps such as Joomla v3 and Magento. It’s perfect for scalable applications, because it performs really well when managing enormous volumes of data. Instead of locking the entire table to import new information into a database as many other engines do, InnoDB locks only one row, so it can perform a lot more operations for the same length of time. In addition, InnoDB offers a much faster database crash recovery and supports transactions and foreign keys – rules that indicate how data imports and updates should be treated. In case a certain operation hasn’t been thoroughly completed for any reason, the action will be rolled back. Thus, the information in the database will stay intact and won’t be partially mixed with newly imported content.
InnoDB in Cloud Hosting
While InnoDB is either a paid upgrade or it is not available at all with many web hosting companies, it is included in the standard set of features that we’re offering with our cloud hosting packages. In case you want to use a PHP script-powered software app that requires InnoDB particularly, in order to be activated and to work correctly, you won’t experience any difficulties since the InnoDB database storage engine is available on our custom-built cloud Internet hosting platform. No matter if you create a brand new database and activate an app manually or take advantage of our 1-click application installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the application requires InnoDB rather than MyISAM. In addition to the excellent crash recovery that InnoDB offers, we also carry out regular backups of all databases, so we can quickly recover any MySQL database in your shared website hosting account.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated hosting service support InnoDB and you can make the most of all the features offered by this database storage engine with any PHP script-based application that requires it. It’s one of the engines that are available on our cloud platform, so the one that will be picked depends on the prerequisites of the specific application. You will not need to do anything manually in order to enable InnoDB, because it will be set as the default engine whenever you install an application – whether manually or using our one-click application installer tool. To avoid any risk, we’ll generate daily backups of all your databases, so if anything goes wrong following an upgrade or if you delete some content unintentionally, we will be able to get the database back to the way it was on any of the previous seven days.
InnoDB in VPS Servers
All Linux VPS hosting service that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to run any PHP-based software app that requires the MySQL database storage engine without setting up anything manually. You can pick Hepsia on the VPS configuration page and your brand new Virtual Private Server will be ready within 1 hour, so you can log in and begin creating your Internet sites straight away. Once you set up a brand new database and start the app activation process, our system will select the engine for this database automatically. Thus, you can make use of various applications simultaneously without the need to edit anything on the server. You can create a WordPress-based personal weblog that uses the default MySQL engine – MyISAM, and a Magento Internet shop that uses the InnoDB engine, for example.
InnoDB in Dedicated Servers
InnoDB is included by default with all dedicated service ordered with the Hepsia Control Panel. It is an essential part of the software bundle that will be installed on all Hepsia-equipped servers, so as soon as your physical machine is ready, you’ll be able to sign in and to activate any script-based software application that requires this particular MySQL database engine. When you set up a new MySQL database through the hosting Control Panel, there won’t be any active engine till you start installing an application. As soon as the app configuration wizard starts importing data into the database, the engine will be selected automatically in accordance with the prerequisites of the application in question, so you can use both MyISAM and InnoDB without having to select either one of them explicitly at any time. Therefore, you can use a large range of apps for your Internet sites.