What?s InnoDB? Why has it been used as the standard MySQL storage engine?
InnoDB is a database storage engine for MySQL databases, which is used by well known PHP-based applications such as Joomla™ 3 and Magento. It’s ideal for scalable apps, because it excels in handling immense amounts of data. Instead of locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can complete a lot more tasks for the same period of time. Furthermore, InnoDB offers a much better database failure recovery and supports transactions and foreign keys – a set of rules that define how data imports and updates should be treated. In case a given task hasn’t been thoroughly completed for some reason, the action will be rolled back. Thus, the database content will remain undamaged and won’t be partially mixed with newly added content.
InnoDB in Web Hosting
Any PHP script-driven software app that needs InnoDB will run impeccably on our innovative cloud platform and the storage engine is offered with all our web hosting
plans. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected in accordance with the app’s specifications without the need to change any setting in your hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you will be able to take advantage of its full capacity. We will create regular backups of your content, so in case you unintentionally delete a MySQL database that is important to you or you overwrite certain parts of it, we will be able to restore your content the way it was only a couple of hours ago.
InnoDB in Semi-dedicated Hosting
You can install a PHP script-driven software application that needs InnoDB with all of our semi-dedicated server
plans, due to the fact that all the accounts are set up on our cutting-edge cloud web hosting platform where the MySQL storage engine is installed. A new MySQL database can be set up in two different ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you make use of our single-click app installer tool. Either way, the needed engine will be chosen automatically once the activation of the app begins, so you won’t have to update anything manually, irrespective of whether the app needs InnoDB or the more commonly used MyISAM. Also, we’ll always be able to recover any of your MySQL databases in case you unintentionally delete one, as we perform a few MySQL database backups every day, each of which is stored for 7 days.
InnoDB in Dedicated Hosting
If you obtain a new dedicated server
, you will be able to choose any of the three hosting Control Panels that we offer – Hepsia, cPanel and DirectAdmin. Any server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t have to install this MySQL database engine manually to be able to run PHP script-based software apps that require it. InnoDB is used by scalable applications and since a dedicated server will offer you all the system resources that you need in order to run large-scale Internet sites, it is pretty possible that you will use InnoDB. You’ll be able to make use of other engines as well, so if a specific app needs MyISAM rather than InnoDB, you won’t have any impediment while running it. The engine that will be used will be recognized automatically as soon as the app installation procedure begins, so you will not need to alter any setting manually whatsoever.