Read more about InnoDB and see why it’s been chosen as the default MySQL database engine.
InnoDB is a MySQL database engine, which has been gaining popularity in recent years, as it provides a much better overall performance and an improved crash recovery in comparison with the default engine that’s used by MySQL – MyISAM. InnoDB is preferred by a lot of programmers that write scalable software applications, due to the fact that it works much more effectively with immense volumes of data, while it keeps the server processing load low. Additionally, it locks only a single database row in case anything should be updated, while many other engines lock the entire table and therefore need more time to carry out several successive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – in case the entire data modification procedure cannot be completed for whatever reason, the operation is rolled back to prevent confusion or data loss. Magento and the newest Joomla™ editions are two examples of widespread PHP script-based applications that have moved to InnoDB.
InnoDB in Shared Website Hosting
You’ll be able to use any script-driven web application that needs InnoDB if you have a shared website hosting plan
with our company, as the MySQL database engine is present on our avant-garde cloud web hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can install applications that use the MyISAM engine without having any problem as well and, again, the engine will be selected automatically, so you won’t have to configure any setting manually at any moment. Furthermore, we will also make regular backups of all the databases that you have in the shared hosting account, so if you erase 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 Servers
All our Linux semi-dedicated servers
support InnoDB and you’ll be able to get the most out of all the features of this MySQL storage engine with any PHP script-driven application that needs it. InnoDB is one of the engines that are available on our cloud website hosting platform, so the one that will be used depends on the requirements of the given app. You won’t need to do anything manually in order to activate InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our one-click application installer. To avoid any risk, we’ll make daily MySQL database backups, so if anything goes wrong following some update or if you remove some data unintentionally, we will be able to restore your database the way it was on any of the past 7 days.
InnoDB in VPS Servers
In case our in-house built Hepsia Control Panel is picked during the registration process for your new VPS hosting plans
, InnoDB will be activated on the Virtual Private Server along with other needed pieces of software, so you will not need to do anything if you decide to make use of script-based apps that need this MySQL storage engine. The default MySQL engine, MyISAM, will be activated too. You can set up a brand new MySQL database and start the app installation manually or through our 1-click installer. The system will detect which engine the app in question needs and will set it for the specific MySQL database, so the installation process will continue impeccably and the application can import its content into that database. In this way, you can activate apps with different requirements about the MySQL engine without making any changes on your Virtual Private Server.
InnoDB in Dedicated Servers
InnoDB comes by default with all dedicated web hosting plans
ordered with the Hepsia hosting Control Panel. It is an essential part of the standard software package that we install on all Hepsia-equipped dedicated servers, so once your physical machine is assembled, you’ll be able to log in and to activate any kind of open-source script-driven software application that needs this MySQL storage engine. When you create a new database through the hosting Control Panel, there won’t be any activated engine till you start installing an application. Once the app setup wizard starts dumping content in the newly created database, the engine will be picked automatically based on the requirements of the application in question, so you can use both MyISAM and InnoDB without having to select either one of them explicitly at any point. Thus, you can use a large collection of applications for your websites.