Find out more on InnoDB and see why it’s recently been picked out as the default MySQL database engine.
InnoDB is a database engine for MySQL relational databases, which is used by widespread PHP-powered software applications like Magento and Joomla™ 3. It’s perfect for scalable applications, as it works astonishingly well when processing huge 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 database row, so it can perform much more operations for the same length of time. Moreover, InnoDB offers a better crash recovery and supports database transactions and foreign keys – a set of rules that determine how data inserts and updates should be treated. In case a given operation has not been entirely completed for whatever reason, the action will be rolled back. Thus, the content in the database will stay safe and sound and will not be partially mixed with newly added content.
InnoDB in Shared Hosting
You’ll be able to activate any open-source script-powered application that needs InnoDB in case you’ve got a shared hosting
with us, as the MySQL database storage engine is present on our innovative cloud platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is required. You can activate applications which need the MyISAM engine without encountering any obstacle as well and, once again, the engine will be selected automatically, so you won’t need to update any setting manually at any time. In addition, we’ll also generate daily backups of all the MySQL databases that you’ve got in your shared web hosting account, so if you delete or overwrite anything, we can quickly get it back to the way it was on any of the past seven days.
InnoDB in Semi-dedicated Hosting
If you create a brand new MySQL database through the hosting Control Panel offered with each of our semi-dedicated server
plans and you start installing a script-based app either manually or using our 1-click app installer tool, the storage engine for the database will be picked automatically on the basis of the requirements of the app in question. As InnoDB is available on the cloud web hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for each app that needs it without the need for any manual intervention on your end at any point. To prevent any risk of losing information if you update an app or if you delete a database by mistake, we’ll make a backup of all your databases each day, so if anything happens, we can retrieve your data.
InnoDB in VPS Web Hosting
If you buy a virtual private server
from our company, you’ll be able to use our in-house developed Hepsia hosting Control Panel to manage your content. A Hepsia-equipped VPS will permit you to run any PHP script-based application which requires InnoDB, as this MySQL storage engine is an integral part of the software bundle that will be pre-installed on the server during its configuration. When you create a brand-new database via the hosting Control Panel, you’ll simply need to start installing an application – manually or using our application installer tool. InnoDB will be set as the default engine in case the app in question needs it, so you will not need to do anything else in your VPS account. Similarly, if an application requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Servers Hosting
When you order a new dedicated server
, you’ll be able to choose any of the 3 Control Panels that we are offering – Hepsia, cPanel and DirectAdmin. Any server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to activate this database storage engine manually in order to be able to use PHP-based software applications that require it. InnoDB is used by scalable apps and since a dedicated server will give you all the server resources that you need to run large-size sites, it’s rather likely that you will resort to InnoDB. You’ll be able to use other engines as well, so in case a certain app needs MyISAM instead of InnoDB, you will not have any obstacle while managing it. The engine that will be used will be recognized automatically as soon as the app installation process begins, so you will not need to configure any settings manually whatsoever.