InnoDB is a database engine for MySQL databases, which is used by famous PHP-powered web apps such as Magento and Joomla™ v3. It is excellent for scalable applications, as it performs stunningly well when managing immense data volumes. Instead of locking the entire database table to append new information to a database as many other engines do, InnoDB locks only one database row, so it can handle much more operations for the same period of time. Plus, InnoDB offers a much better crash recovery and supports transactions and foreign key constraints – a set of rules that specify how data inserts and modifications should be handled. If a particular operation hasn’t been fully completed for any reason, the action will be rolled back. Thus, the database content will be retained intact and won’t be partially mixed with newly appended content.
InnoDB in Shared Web Hosting
You can use any script-driven web application that needs InnoDB in case you’ve got a shared web hosting service
with us, as the MySQL database engine is available on our leading-edge cloud platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is required. You can run applications which require the MyISAM engine without any difficulties as well and, once again, the engine will be selected automatically, so you won’t have to update anything manually at any point. Furthermore, we’ll also generate daily backups of all the MySQL databases that you have in your account, so if you delete or overwrite anything, we can easily get it back to the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database through the Control Panel coming with each of our semi-dedicated server
packages and you start installing a script-driven application either manually or using our 1-click app installer tool, the storage engine for the MySQL database will be selected automatically based on the particular app’s requirements. Since InnoDB is available on the cloud website hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that needs it without any manual action needed on your end at any time. To prevent any risk of losing information if you update an app or if you erase a database by accident, we will carry out a backup of all your databases each day, so if something goes wrong, we can retrieve your data.
InnoDB in VPS Servers
In case our in-house built Hepsia hosting Control Panel is selected during the signup process for a new VPS servers
, InnoDB will be installed on the VPS server together with other required software, so you won’t need to do anything if you decide to use PHP-driven software apps that need this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated too. You can create a new database and start installing the app manually or using our 1-click installer tool. The system will detect the engine that the particular application needs and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can dump its data in that database. In this way, you can manage applications with different prerequisites regarding the MySQL engine without having to make any changes on your VPS server.
InnoDB in Dedicated Servers
InnoDB is available by default with all Linux dedicated service
ordered with the Hepsia hosting Control Panel. It is an integral part of the software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so as soon as your machine is assembled, you will be able to log in and to install any type of PHP script-driven app that needs this particular database engine. If you set up a new database via the Control Panel, there won’t be any active engine till you begin installing an application. Once the app activation wizard begins dumping information in the database, the engine will be selected automatically in accordance with the requirements of the app in question, so you can run both InnoDB and MyISAM without selecting either one of them explicitly at any moment. In this way, you can use a broad range of apps for your websites.