Read more about InnoDB and see why it’s been chosen as the default MySQL database engine.
InnoDB is a storage engine for MySQL relational databases, which is used by widely used PHP script-driven software apps such as Joomla™ 3 and Magento. It’s perfect for scalable applications, because it works incredibly well when processing enormous data volumes. Instead of locking the whole table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can handle a lot more tasks for the same length of time. Also, InnoDB offers a better database failure recovery and supports transactions and foreign key constraints – rules that define how data imports and updates should be handled. If a given operation has not been thoroughly completed for some reason, the action will be rolled back. Thus, the information in the database will be preserved safe and sound and will not be partially merged with newly appended content.
InnoDB in Cloud Hosting
InnoDB is available with all our Linux cloud packages
by default, not upon request or as a paid upgrade, so you’ll be able to activate and run any PHP-based web application which requires the InnoDB database engine without encountering any obstacle once you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app activation, irrespective of whether you take advantage of our 1-click installation tool or create the database and install the app manually, provided that the application requires InnoDB instead of the more famous MyISAM engine. We’ll keep regular database backups, so you can rest assured that you won’t ever lose any data in case you erase a database unintentionally or you overwrite some essential info – you’ll simply have to inform us and we’ll restore your data the way it was.
InnoDB in Semi-dedicated Hosting
If you set up a brand-new MySQL database from the hosting Control Panel offered with each of our semi-dedicated server
packages and you begin installing an open-source script-based software app either manually or using our one-click application installer, the storage engine for the database will be picked automatically depending on the requirements of the given application. As InnoDB is present on the cloud platform where your new account will be created, it will be set as the default engine for any app that needs it without the need for any manual action on your end at any time. To prevent any chance of losing information if you update an app or if you remove a database accidentally, we’ll make a backup of all your databases each and every day, so if anything goes wrong, we can rescue your content.
InnoDB in VPS
In case our custom-built Hepsia Control Panel is picked during the signup process for a new Linux VPS packages
, InnoDB will be activated on the VPS server along with other required software, so you won’t have to do anything if you choose to install PHP script-based apps that need this MySQL database engine. The default MySQL engine – MyISAM, will be installed too. You can set up a new database and begin the app installation manually or using our single-click installation tool. The system will automatically detect which engine the application in question needs and will assign it to the specific MySQL database, so the installation will continue flawlessly and the app can enter its content into that database. In this way, you can manage applications with different requirements with regard to the MySQL engine without making any changes on your VPS.
InnoDB in Dedicated Hosting
All Linux dedicated servers hosting packages
ordered with our custom Hepsia Control Panel include a software package that’s pre-installed and besides everything else, you will get the InnoDB storage engine, so you won’t have to activate it manually if you’d like to run open-source PHP scripts that need it. All it takes to activate such a script is to create a new database and to begin the installation – once the script configuration wizard gets access to the database in question and begins entering data into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You will also be able to use scripts that require the other widely used MySQL engine, MyISAM, so you won’t have to modify any settings on the server. This will permit you to activate different scripts on a single server and to use the latter to its fullest potential.