InnoDB is a database engine for MySQL relational databases, which is used by widely used script-driven web applications like Joomla v3 and Magento. It is excellent for scalable apps, because it performs exceptionally well when processing enormous volumes of data. Instead of locking the whole table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can handle a lot more operations for the same length of time. Moreover, InnoDB offers a much better database crash recovery and supports transactions and foreign keys – rules that prescribe how data inserts and modifications should be handled. In case a particular task hasn’t been fully completed for any reason, the action will be rolled back. In this way, the information in the database will remain undamaged and won’t be partially mixed with newly added content.

InnoDB in Cloud Hosting

You can use any script-driven application that requires InnoDB in case you’ve got a Linux cloud hosting with our company, as the database engine is present on our cutting-edge cloud website 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 flawlessly in case this engine is needed. You can activate applications which use the MyISAM engine without having any problem as well and, again, the engine will be pre-selected, so you will not have to update any setting manually at any time. In addition, we will also carry out regular backups of all the MySQL databases that you have in your account, so if you erase or overwrite anything, we can easily restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

If you set up a brand-new MySQL database from the Control Panel offered with all our semi-dedicated server plans and you start installing a PHP-based application either manually or using our one-click application installer tool, the storage engine for the database will be picked automatically based on the specific app’s prerequisites. Since InnoDB is available on the cloud hosting platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for each application that requires it without any manual action needed on your end at any point. To prevent any risk of losing info if you update an app or if you erase a database accidentally, we will perform a backup of all your databases every day, so if anything goes wrong, we can retrieve your data.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you’ll be able to make use of any PHP-driven web application that requires the database storage engine without having to activate anything manually. You can pick Hepsia on the VPS configuration page and your brand-new VPS server will be ready within 1 hour, so you can log in and begin setting up your Internet sites straight away. When you create a brand new database and begin the app activation process, our system will set the engine for this MySQL database automatically. In this way, you can activate various apps at the same time without having to modify anything on the VPS server. You can create a WordPress-driven personal blog that uses MyISAM – the default MySQL engine, and a Magento-based e-commerce site that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

InnoDB is available by default with all Linux dedicated service that are ordered with the Hepsia Control Panel. It’s an essential part of the default software package that we install on all Hepsia-equipped dedicated servers, so as soon as your machine is assembled, you will be able to log in and to activate any type of script-powered software application that requires this particular MySQL storage engine. When you set up a new database via the hosting Control Panel, there won’t be any active engine until you begin installing an app. As soon as the app setup wizard starts entering data into the newly created database, the engine will be set automatically depending on the respective app’s requirements, so you can use both InnoDB and MyISAM without the need to select either of them specifically at any time. Thus, you can make use of an immense variety of apps for your Internet sites.