What?s InnoDB? Why has it been used as the default MySQL storage engine?
InnoDB is a very popular database storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has got a number of upsides that make it the engine of choice for lots of PHP-based software applications, including Joomla™ and Magento, which have shifted over to InnoDB for good. For instance, importing immense data volumes will be much faster with InnoDB, as it locks only a single database row to execute a task, not the entire table, which makes the engine perfect for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is handled. In simpler words, importing new or editing existent data will either be fully completed, or will be aborted and the operation will be rolled back in case some problem appears during the process, so the content that remains in the database won’t be damaged.
InnoDB in Web Hosting
Any PHP-powered software application that needs InnoDB will function impeccably on our avant-garde cloud web hosting platform and the MySQL storage engine is available with all our web hosting
packages. Every time you create a MySQL 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 on the basis of the app’s prerequisites without having to configure any setting in your shared account. InnoDB will be chosen automatically for any app that requires this specific engine and you will be able to take advantage of its full potential. We will create daily content backups, so if you unintentionally remove a database that you need or you overwrite a certain part of it, we will be able to restore your database the way it was only a few hours ago.
InnoDB in Semi-dedicated Servers
If you set up a brand new MySQL database from the hosting Control Panel included with each of our semi-dedicated server
packages and you start installing a PHP-powered software application either manually or using our 1-click application installer, the database storage engine will be set automatically based on the prerequisites of the specific application. As InnoDB is available on the cloud website hosting platform where your new semi-dedicated server account will be set up, it will be set as the default engine for each application that requires it without the need for any manual intervention on your end at any moment. To avoid any chance of losing data if you update an app or if you remove a database unintentionally, we’ll generate a backup of all your databases each and every day, so if something goes wrong, we can restore your content.
InnoDB in VPS Servers
When you order a VPS server
from us, you will be able to make use of our in-house built Hepsia hosting Control Panel to manage your web content. A Hepsia-equipped VPS will permit you to run any PHP script-powered application which needs InnoDB, as this storage engine is part of the standard software package that will be installed on your Virtual Private Server during its creation. When you set up a brand new database using the Control Panel, you’ll just need to begin installing an app – manually or using our app installer. InnoDB will be set as the default engine on the condition that the app in question requires it, so you won’t need to do anything else in your account. Similarly, if a given application requires MyISAM, it will be automatically set as the default engine for this particular database.
InnoDB in Dedicated Servers
InnoDB comes by default with all dedicated servers
ordered with the Hepsia Control Panel. It is an essential part of the standard software bundle that will be installed on all Hepsia-managed dedicated servers, so once your machine is ready, you’ll be able to sign in and to activate any kind of PHP script-based web app that requires this particular MySQL storage engine. If you set up a new MySQL database via the Control Panel, there won’t be any active engine until you begin installing an application. Once the app setup wizard starts entering data into the database, the engine will be set automatically on the basis of the specific app’s prerequisites, so you can run both InnoDB and MyISAM without the need to select either one of them specifically at any moment. In this way, you can make use of a huge collection of apps for your websites.