Read more about InnoDB and find out why it’s already been chosen as the default MySQL database engine.
InnoDB is a MySQL storage engine, which has been gaining in popularity lately, as it provides a significantly better overall performance and an improved database crash recovery in comparison to the default engine used by the MySQL relational database management system – MyISAM. InnoDB is used by plenty of programmers that build highly scalable web apps, as it works much better with enormous data volumes, while it keeps the server processing load at a minimum. Furthermore, it locks only one database row in case any info should be modified, whereas lots of other engines lock the entire database table and therefore need much more time to handle several consecutive tasks. Last, but not least, InnoDB follows a set of "all-or-nothing" rules – in case the modification of the entire data cannot be completed successfully for whatever reason, the operation is rolled back to prevent confusion or the loss of data. Magento and the newest Joomla™ editions are two instances of popular script-based apps which have switched to InnoDB.
InnoDB in Shared Web Hosting
While InnoDB is either not offered or it is a paid upgrade with many web hosting companies, it’s part of the standard set of features that we offer with our shared web hosting
plans. In case you’d like to make use of a script-driven software application that requires InnoDB specifically, in order to be activated and to work properly, you won’t need to deal with any impediments since the InnoDB database engine is available on our in-house built cloud website hosting platform. No matter if you set up a brand-new database and install an application manually or use our single-click application installer software instrument, InnoDB will be selected automatically by our system as the default engine if the application needs it rather than MyISAM. Besides the excellent database failure recovery offered by InnoDB, we also generate regular backups of all databases, so we can easily restore any MySQL database in your shared hosting account.
InnoDB in Semi-dedicated Hosting
InnoDB is included with all our Linux semi-dedicated hosting
by default, so once you order a new account, you can go ahead and install any PHP script-driven software app that needs this particular MySQL database storage engine. A few engines are installed on our cloud platform, so when you create a brand new MySQL database and start installing an application manually, or decide to make use of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be set in accordance with the requirements of the respective app. This will allow you to install and run InnoDB-specific applications without needing to cope with any impediment and without having to update any settings in your account. To avoid any risk, we’ll always have a 1-week-old backup of all your databases, so if you erase or alter any content by accident, we can quickly restore it.
InnoDB in VPS Hosting
All Linux VPS hosting
that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to use any open-source script-powered software app that needs the MySQL database storage engine without having to activate anything manually. You can choose Hepsia on the VPS order page and your brand new server will be set up within the hour, so you can log in and start building your web sites straight away. When you set up a new MySQL database and start the app activation process, our system will pick the engine for that MySQL database automatically. Thus, you can use various applications at the same time without having to change anything on the server. You can create a WordPress-powered personal weblog that uses MyISAM – the default MySQL engine, and a Magento-powered web shop that makes use of the InnoDB engine, for instance.
InnoDB in Dedicated Web Hosting
If you acquire a new dedicated server
, you will be able to choose any of the 3 Control Panels that we’re offering – DirectAdmin, cPanel and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not have to enable this MySQL storage engine manually in order to be able to run open-source script-driven web applications that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the system resources that you require to run large-size websites, it is very likely that you will resort to InnoDB. You’ll be able to use other engines as well, so in case a given app needs MyISAM instead of InnoDB, you will not encounter any difficulty while managing it. The engine that will be used will be detected automatically when the app installation begins, so you will not have to alter any settings manually at any time.