InnoDB is a database engine for MySQL relational databases, which is used by popular PHP script-driven software applications like Joomla™ v3 and Magento. It’s perfect for scalable apps, since it excels in handling large data volumes. Instead of locking the entire database table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same length of time. What’s more, InnoDB offers a much better database failure recovery and supports transactions and foreign key constraints – rules that determine how data imports and updates should be handled. If a specific operation hasn’t been fully completed for whatever reason, the action will be rolled back. Thus, the information in the database will be preserved intact and won’t be partially mixed with newly added content.
InnoDB in Shared Website Hosting
You’ll be able to run any script-based application that requires InnoDB in case you’ve got a shared website hosting plan with us, as the database engine is available on our innovative cloud website hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is needed. You can install apps that use the MyISAM engine without having any difficulty as well and, again, the engine will be selected automatically, so you will not need to modify anything manually at any moment. What’s more, we’ll also carry out regular backups of all the MySQL databases that you’ve got in the account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
InnoDB comes with each of our semi-dedicated plans by default, so once you create a new account, you can go on and activate any script-driven software app that needs this particular MySQL database storage engine. A few engines are pre-installed on our cloud hosting platform, so when you set up a new database and begin installing an application manually, or opt to use the Hepsia Control Panel-integrated application installer, the engine for the database will be chosen on the basis of the requirements of the given app. This will allow you to install and run InnoDB-specific applications without having to cope with any complication and without having to change any settings in your account. To avoid any risk, we’ll always keep a 7-day-old backup of all your MySQL databases, so if you delete or alter any content by accident, we can swiftly retrieve it.
InnoDB in VPS Servers
All VPS plans that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you’ll be able to make use of any open-source script-driven app that requires this database engine without the need to install anything manually. You can select Hepsia on the VPS configuration page and your brand new Virtual Private Server will be up and running within the hour, so you can log in and begin setting up your sites right away. Once you set up a new database and begin the app installation process, our system will select the engine for that database automatically. Thus, you can manage various apps simultaneously without having to configure anything on the server. You can set up a WordPress-driven weblog that uses the default MySQL engine – MyISAM, and a Magento-based web store that makes use of InnoDB, for example.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the features which you can select on the order page when you buy a dedicated server from us. Since this is the most powerful type of web hosting, it is quite likely that you’ll manage popular websites that will attract lots of people, and since InnoDB is one of the very best options for such websites, we will enable it together with all the other software applications that are offered with a Hepsia-equipped server. If you create a brand-new MySQL database in your dedicated server account, there won’t be any activated database engine until you begin installing an open-source PHP script, whether manually through your Internet browser or using the automatic script installer tool that is integrated into the hosting Control Panel. The necessary engine will be automatically detected and will be set for that database, so you can install scripts that need InnoDB, as well as ones that require MyISAM, the default MySQL engine, without any predicaments.