Find out more about InnoDB and see why it’s been picked out as the default MySQL database engine.
InnoDB is a very popular database storage engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has got a number of pluses that make it the engine of choice for plenty of open-source script-based applications, including Magento and Joomla™, which have moved to InnoDB permanently. For example, adding huge amounts of data will be faster with InnoDB, due to the fact that it locks only a single row to perform a certain operation, not the entire table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the info is handled. To put it simply, appending new or editing existent data will either be entirely completed, or will be canceled and the operation will be rolled back in case any issue occurs in the meantime, which means that the content that remains in the database will not be damaged.
InnoDB in Shared Hosting
You will be able to install any script-driven app that requires InnoDB in case you’ve got a Linux shared hosting package
with our company, as the database storage engine is available on our cutting-edge cloud website hosting platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly if this engine is needed. You can install apps that need the MyISAM engine without any obstacles as well and, once again, the engine will be selected automatically, so you won’t need to change anything manually at any point. On top of that, we will also create regular backups of all the databases that you have in your shared web hosting account, so if you delete or overwrite something, we can swiftly restore it the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Hosting
You can run a PHP script-driven web application that needs InnoDB with all of our semi-dedicated server
packages, because all the accounts are set up on our avant-garde cloud platform where the MySQL storage engine is installed. A new MySQL database can be set up in two ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – in case you use our one-click application installer tool. Either way, the needed engine will be chosen automatically as soon as the app’s installation starts, so you will not have to edit anything manually, regardless of whether the app needs InnoDB or the more frequently used MyISAM. Also, we will always be able to recover any of your databases in case you erase one by mistake, as we perform a couple of MySQL database backups every day, each of which is kept for 1 week.
InnoDB in Dedicated Servers Hosting
When you order a new dedicated server
, you’ll be able to select one of the 3 hosting Control Panels that we’re offering – Hepsia, cPanel and DirectAdmin. Each dedicated server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to enable this database engine manually in order to be able to run PHP script-driven software applications that need it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the system resources that you require in order to run large-size Internet sites, it’s rather likely that you will resort to InnoDB. You’ll be able to make use of other engines too, so in case a given application needs MyISAM rather than InnoDB, you won’t come across any impediment while running it. The engine that will be used will be automatically detected once the app installation procedure begins, so you won’t have to alter any setting manually at any moment.