What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a database storage engine for MySQL relational databases, which is used by widespread open-source script-driven apps such as Joomla™ 3.x and Magento. It’s perfect for scalable applications, because it works incredibly well when managing immense data volumes. Rather than locking the entire database table to import new information into a database like many other engines do, InnoDB locks only one database row, so it can perform much more tasks for the same period of time. Additionally, InnoDB offers an improved crash recovery and supports transactions and foreign keys – a set of rules that indicate how data imports and modifications should be handled. In case a given task hasn’t been fully completed for some reason, the action will be rolled back. In this way, the information in the database will stay intact and will not be partially merged with newly entered content.
InnoDB in Shared Web Hosting
Every script-powered web app that needs InnoDB will function impeccably on our innovative cloud platform and the database engine is available with all our shared web hosting
packages. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database in question will make use of will be selected based on the app’s prerequisites without the need to configure any setting in your shared web hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you will be able to take advantage of its full capacity. We will maintain regular content backups, so if you unintentionally remove a MySQL database that’s important to you or you overwrite specific parts of it, we’ll be able to restore your database the way it was only a few hours earlier.
InnoDB in Semi-dedicated Hosting
You can activate a PHP-driven software application that requires InnoDB with any of our semi-dedicated server
packages, due to the fact that all the accounts are created on our advanced cloud hosting platform where the MySQL database engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you take advantage of our 1-click application installer tool. Either way, the needed engine will be chosen automatically once the activation of the application starts, so you will not need to update anything manually, regardless of whether the application requires InnoDB or the more widely used MyISAM. Furthermore, we will always be able to recover any of your databases if you remove one by accident, as we carry out a few database backups every day, each of which is stored for one whole week.
InnoDB in VPS Hosting
If our custom-developed Hepsia Control Panel is picked during the registration process for a new Linux virtual private servers
, InnoDB will be activated on the VPS server along with other needed software, so you won’t need to do anything if you choose to use script-driven software applications that need this MySQL storage engine. The default MySQL engine, MyISAM, will be activated as well. You can create a new database and begin the app installation manually or using our one-click installation tool. The system will detect the engine that the particular app requires and will assign it to the specific database, so the installation will continue flawlessly and the app can dump its content in that database. Therefore, you can manage applications with various prerequisites about the MySQL engine without the need to make any modifications on your server.
InnoDB in Dedicated Web Hosting
All Linux dedicated hosting services
ordered with our custom-built Hepsia Control Panel include a software package that is pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you won’t need to install it manually in case you want to activate open-source PHP scripts that need it. All it takes to use such a script is to create a new database and to initiate the setup – once the script configuration wizard gets access to the database and starts importing data into it, InnoDB will be set as the default engine for this database provided that it is the one required by the particular script. You will also be able to activate scripts that require MyISAM, the other popular MySQL engine, so you will not have to update any settings on the dedicated server. This will enable you to run different scripts on one single physical machine and to use it to its full capabilities.