InnoDB
Become aware of what a database engine is, what are the merits of the InnoDB engine and why it is gaining a lot of popularity.
InnoDB is a very popular database storage engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has got a number of strong sides that have made it the engine of choice for plenty of PHP-based applications, including Magento and Joomla™, which have shifted over to InnoDB for good. For instance, adding immense data volumes will be much faster with InnoDB, as it locks only a single row to execute a task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the info is treated. In simpler words, importing new or editing existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if any issue appears during the process, which means that the content that remains in the database won’t be damaged.
-
InnoDB in Cloud Hosting
Any PHP script-driven software app that needs InnoDB will run flawlessly on our avant-garde cloud website hosting platform and the MySQL storage engine is offered with all our
cloud hosting plans. Every time you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s requirements without the need to edit any setting in your web hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you’ll be able to take advantage of its full potential. We will carry out daily content backups, so if you unintentionally erase a database that is important to you or you overwrite certain parts of it, we’ll be able to restore everything the way it was just a couple of hours earlier.
-
InnoDB in Semi-dedicated Servers
All our
semi-dedicated hosting plans support InnoDB and you will be able to make the most of all the features offered by this storage engine with any open-source script-powered application that requires it. It’s among the engines that are available on our cloud hosting platform, so the one that will be picked depends on the requirements of the specific app. You won’t have to do anything manually to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our 1-click app installer. To avoid any risk, we’ll perform daily MySQL database backups, so if something goes wrong following an update or if you remove some data unintentionally, we will be able to restore your database the way it was on any of the previous seven days.
-
InnoDB in VPS Servers
If our in-house built Hepsia hosting Control Panel is chosen during the registration process for your new
VPS plans , InnoDB will be activated on the VPS server together with other needed software, so you won’t have to do anything if you choose to use PHP script-driven web applications that need this MySQL database engine. The default MySQL engine – MyISAM, will be installed as well. You can set up a new database and start the app installation process manually or through our 1-click installer. The system will automatically recognize which engine the application in question needs and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can insert its content into that database. In this way, you can run apps with different requirements regarding the MySQL engine without having to make any modifications on your VPS.
-
InnoDB in Dedicated Servers
All
Linux dedicated web hosting plans ordered with our custom-built Hepsia hosting Control Panel include a software package that’s pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you will not have to activate it manually in case you’d like to activate open-source scripts that require it. All it takes to install such a script is to set up a new MySQL database and to begin the installation – once the script installation wizard accesses the database in question and begins inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You will also be able to run scripts that need the other very popular MySQL engine – MyISAM, so you will not have to update any settings on the server. This will permit you to install various scripts on a single physical machine and to use the latter to its maximum capacity.