What?s InnoDB? Why has it been used as the standard MySQL storage engine?
InnoDB is a popular database engine for MySQL. It is an alternative to the default MyISAM engine and it has lots of strengths which make it the engine of choice for plenty of PHP-based software applications, among them Joomla™ and Magento, which have switched over to InnoDB for good. For instance, adding immense amounts of data will be much faster with InnoDB, because it locks only a single database row to complete a given task, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the info is handled. Put simply, importing new or editing existing data will either be entirely completed, or will be canceled and the operation will be rolled back if some problem occurs during the process, therefore the content that remains in the database won’t be damaged.
InnoDB in Cloud Hosting
Any open-source script-driven software application that requires InnoDB will function impeccably on our avant-garde cloud website hosting platform and the database engine is available with all our cloud hosting
plans. Whenever you create a database manually or our app installer tool creates one automatically and an app installation 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 modify any setting in your hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to make the most of its full capacity. We will create daily content backups, so if you accidentally remove a database that’s important to you or you overwrite a specific part of it, we will be able to restore your database the way it was just a couple of hours ago.
InnoDB in Semi-dedicated Servers
InnoDB comes with each of our semi-dedicated hosting plans
by default, so once you obtain a new semi-dedicated account, you can go ahead and install any PHP-based software application that requires this particular MySQL storage engine. A few engines are installed on our cloud hosting platform, so when you create a new MySQL database and start installing an application manually, or decide to use the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be selected based on the requirements of the particular application. This will permit you to activate and run InnoDB-specific applications without coming across any obstacle and without having to update any settings in your account. To take no chances, we will always have a 7-day-old backup of all your MySQL databases, so if you erase or change any content by mistake, we can easily recover it.
InnoDB in VPS Servers
In case our in-house built Hepsia Control Panel is selected during the registration process for a new VPS plans
, InnoDB will be installed on the VPS server together with other necessary pieces of software, so you will not need to do anything if you decide to run open-source script-based web applications that require this MySQL storage engine. The default MySQL engine, MyISAM, will be installed as well. You can create a brand-new database and begin installing the app manually or using our 1-click installer. The system will recognize which engine the application in question requires and will set it for the specific database, so the installation process will continue flawlessly and the application can import its data into that database. In this way, you can manage apps with various requirements regarding the MySQL engine without having to make any modifications on your VPS server.
InnoDB in Dedicated Servers
All dedicated web hosting plans
that are ordered with our custom-developed Hepsia Control Panel include a software package that’s pre-activated and among everything else, you will get the InnoDB storage engine, so you will not need to add it manually if you want to run scripts that require it. All it takes to install such a script is to set up a new database and to start the setup – once the installer wizard acquires access to the database in question and begins entering data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You’ll also be able to use scripts that require the other very popular MySQL engine – MyISAM, so you won’t have to update any settings on the dedicated server. This will permit you to install various scripts on a single server and to use it to its maximum capacity.