InnoDB is a database storage engine for MySQL databases, which is used by well known script-based software apps like Joomla™ v3 and Magento. It’s ideal for scalable applications, as it works incredibly well when processing immense amounts of data. Instead of locking the whole table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can handle much more operations for the same length of time. Plus, InnoDB offers a much better crash recovery and supports transactions and foreign keys – a set of rules that specify how data imports and modifications should be treated. In case a specific operation hasn’t been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will be preserved undamaged and won’t be partially merged with newly inserted content.
InnoDB in Cloud Web Hosting
While InnoDB is either a paid upgrade or it is not available at all with other website hosting service providers, it is an integral part of the standard set of services offered with our cloud web hosting
packages. If you wish to use an open-source script-based app that needs InnoDB specifically, in order to be activated and to work properly, you won’t need to deal with any problems since the MySQL database engine is available on our custom-built cloud web hosting platform. Irrespective of whether you set up a brand-new MySQL database and install an app manually or take advantage of our single-click application installer tool, InnoDB will be selected automatically by our system as the default engine if the respective app requires it instead of MyISAM. Besides the incredible database crash recovery offered by InnoDB, we also keep regular backups of all databases, so that we can easily recover any MySQL database in your shared hosting account.
InnoDB in Semi-dedicated Servers
If you create a new MySQL database from the hosting Control Panel coming with all our semi-dedicated server
packages and you begin installing an open-source script-powered application either manually or using our 1-click application installer tool, the storage engine for the MySQL database will be selected automatically depending on the requirements of the given app. As InnoDB is present on the cloud hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that requires it without any manual action needed on your end at any point. To prevent any chance of losing information if you update an application or if you remove a database by mistake, we will perform a backup of all your MySQL databases each and every day, so if anything happens, we can rescue your data.
InnoDB in VPS Servers
If our in-house developed Hepsia hosting Control Panel is selected during the registration process for a new VPS servers
, InnoDB will be activated on the Virtual Private Server together with other essential software, so you will not need to do anything if you decide to run open-source script-driven software apps that require this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can create a new MySQL database and start the app installation procedure manually or using our 1-click installer tool. The system will recognize which engine the app in question needs and will set it for the specific MySQL database, so the installation process will proceed impeccably and the application can dump its data in that database. Therefore, you can install applications with various requirements concerning the MySQL engine without having to make any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is among the options which you can select on the order page when you purchase a dedicated server
from us. Since this is the most powerful kind of website hosting, it is rather likely that you’ll manage popular websites that will draw many individuals, and since InnoDB is one of the best options for such sites, we will activate it along with all the other software apps that are available with a Hepsia-managed dedicated server. When you set up a new database in your dedicated server account, there won’t be any activated storage engine till you begin installing a PHP script, whether manually through your web browser or using the automatic script installation tool that is included in the hosting Control Panel. The necessary engine will be recognized and will be assigned to the database in question, so you can install scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without needing to deal with any complication.