InnoDB is a database engine for MySQL databases, which is used by widespread script-based software apps like Magento and Joomla v3. It’s perfect for scalable apps, because it excels in managing immense amounts of data. Instead of locking the entire table to import new information into a database as many other engines do, InnoDB locks only one database row, so it can execute much more operations for the same period of time. Also, InnoDB offers a faster database failure recovery and supports transactions and foreign key constraints – rules that specify how data imports and updates should be treated. If a certain task has not been fully completed for some reason, the action will be rolled back. In this way, the database content will be kept safe and sound and will not be partially merged with newly added content.
InnoDB in Shared Website Hosting
You can install any PHP-based web app that needs InnoDB in case you have a shared website hosting plan with us, as the storage engine is available on our innovative cloud platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is required. You can run applications that use the MyISAM engine without having to deal with any problem as well and, again, the engine will be selected automatically, so you will not need to update anything manually at any moment. In addition, we’ll also carry out daily backups of all the databases that you’ve got in the shared web hosting account, so in case you erase or overwrite anything, we can swiftly get it back to the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
All our semi-dedicated hosting plans come with InnoDB and you’ll be able to get the most out of all the features of this MySQL database storage engine with any PHP-driven software application that requires it. It is among the engines that are available on our cloud web hosting platform, so the one that will be picked depends on the requirements of the specific application. You won’t have to do anything manually in order to activate InnoDB, since it will be set as the default engine when you install an application – whether manually or using our one-click app installer tool. To avoid any risk, we will store regular MySQL database backups, so if anything goes wrong after some update or if you erase some content accidentally, we’ll be able to get the database back to the way it was on any of the past 7 days.
InnoDB in VPS Servers
If our custom-developed Hepsia hosting Control Panel is selected during the registration process for a new VPS hosting plans , InnoDB will be activated on the server along with other essential software, so you will not have to do anything if you decide to manage script-powered web applications that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be installed as well. You can create a brand-new MySQL database and start the app installation procedure manually or through our one-click installer tool. The system will recognize which engine the application in question needs and will set it for the specific database, so the installation will proceed impeccably and the application can insert its content into that database. In this way, you can run apps with different requirements about the MySQL engine without having to make any changes on your server.
InnoDB in Dedicated Servers
InnoDB is included as standard with all dedicated web hosting plans ordered with the Hepsia hosting Control Panel. It’s an essential part of the default software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so as soon as your machine is ready, you will be able to sign in and to activate any type of PHP script-based app that needs this MySQL database storage engine. If you set up a new database via the hosting Control Panel, there won’t be any activated engine till you start installing an app. As soon as the app installation wizard begins inserting content into the database, the engine will be selected automatically based on the prerequisites of the given app, so you can use both InnoDB and MyISAM without the need to select either one specifically at any time. Thus, you can use a huge selection of apps for your sites.