InnoDB is a database engine for MySQL databases, which is used by widespread PHP-based web applications such as Joomla v3 and Magento. It is ideal for scalable apps, because it works exceptionally well when processing large amounts of data. Rather than locking the entire table to append new information to a database like many other engines do, InnoDB locks only one row, so it can process much more tasks for the same length of time. Besides, InnoDB offers a much better database failure recovery and supports database transactions and foreign keys – a set of rules that indicate how data imports and modifications should be treated. In case a given task has not been fully completed for some reason, the action will be rolled back. Thus, the information in the database will stay safe and sound and will not be partially merged with new content.
InnoDB in Cloud Web Hosting
InnoDB is available with all our Linux cloud web hosting by default, not as a paid upgrade or upon request, so you’ll be able to install and manage any script-powered application that requires the database storage engine without any problem once you order your shared hosting account. InnoDB will be pre-selected as the default engine for a particular database during the app activation, no matter if you use our one-click installer or create the MySQL database and activate the app manually, as long as the app requires it instead of the more famous MyISAM engine. We’ll store regular backups of all your databases, so you can be sure that you will never lose any content if you delete a database unintentionally or you overwrite some key info – you simply have to notify us and we will restore the database the way it was.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting include InnoDB and you will be able to make use of all the features offered by this MySQL database engine with any script-based application that needs it. InnoDB is one of the engines that we have on our cloud hosting platform, so the one that will be selected depends on the requirements of the specific application. You will not need to do anything manually to enable InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our 1-click application installer. To avoid any risk, we’ll generate regular MySQL database backups, so if something goes wrong after some update or if you erase some data unintentionally, we will be able to get your database back to the way it was on any of the past seven days.
InnoDB in VPS Hosting
All Linux VPS hosting that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to use any PHP script-powered app that needs the database engine without needing to activate anything manually. You can select Hepsia on the VPS order form and your brand-new Virtual Private Server will be ready within 1 hour, so you can log in and begin creating your websites right away. Once you create a brand-new database and start the app installation process, our system will set the engine for that database automatically. In this way, you can use various applications at the same time without changing anything on the VPS server. You can set up a WordPress-powered personal journal that makes use of MyISAM – the default MySQL engine, and a Magento-based web store that makes use of the InnoDB engine, for example.
InnoDB in Dedicated Web Hosting
InnoDB is available by default with all Linux dedicated web hosting ordered with the Hepsia Control Panel. It is part of the software package that we install on all Hepsia-equipped servers, so as soon as your physical machine is ready, you will be able to sign in and to install a various script-driven application that needs this MySQL database storage engine. When you set up a new MySQL database via the Control Panel, there won’t be any active engine till you start installing an app. Once the app installation wizard starts dumping information in the newly created database, the engine will be picked automatically depending on the specific app’s prerequisites, so you can use both MyISAM and InnoDB without having to select either one of them explicitly at any time. Thus, you can use a large variety of applications for your sites.