Become aware of what a database engine is, what exactly 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 RDBMS. It is an alternative to the default engine – MyISAM, and it has many upsides which make it the engine of choice for a lot of PHP-powered software apps, including Magento and Joomla™, which have switched over to InnoDB permanently. For instance, importing huge data volumes will be faster with InnoDB, as it locks only a single row to carry out a certain operation, not the entire database 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 information is handled. To put it simply, appending new or updating existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back if any problem shows up during the process, therefore the content that remains in the database won’t be damaged.
InnoDB in Cloud Website Hosting
InnoDB is offered with all our cloud website hosting plans
by default, not as a paid upgrade or upon request, so you will be able to install and manage any PHP-based application which needs the database storage engine without having to deal with any problem once you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app installation, no matter if you use our single-click installer or create the database and activate the app manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We’ll create regular MySQL database backups, so you can rest assured that you will never lose any content in case you erase a database by mistake or you overwrite some key info – you’ll simply have to touch base with us and we will restore the database the way it was.
InnoDB in Semi-dedicated Servers
InnoDB is available with each of our semi-dedicated plans
by default, so as soon as you get a new semi-dedicated account, you can move on and install any open-source script-powered application that needs this particular MySQL database storage engine. A couple of engines are pre-installed on our cloud web hosting platform, so when you create a new MySQL database and begin installing an app manually, or opt to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be picked depending on the respective app’s requirements. This will permit you to activate and manage InnoDB-specific apps without needing to cope with any impediment and without editing any settings in your account. To take no chances, we will always keep a seven-day-old backup of all your MySQL databases, so if you delete or edit any content unintentionally, we can quickly recover it.
InnoDB in Dedicated Servers
All dedicated web hosting plans
ordered with our in-house built Hepsia Control Panel come with a software bundle that’s pre-installed and besides everything else, you will get the InnoDB storage engine, so you will not need to add it manually if you want to activate open-source PHP scripts that require it. All it takes to activate such a script is to set up a new database and to initiate the installation process – as soon as the script setup wizard gets access to the database in question and begins dumping content in it, InnoDB will be set as the default engine for this database on the condition that it is the one required by the particular script. You’ll also be able to install scripts that require MyISAM – the other widely used MySQL engine, so you will not have to change any settings on the dedicated server. This will allow you to install a variety of scripts on a single physical server and to use it to its fullest capacity.