What?s InnoDB? Why has it been picked up as the standard MySQL storage engine?
InnoDB is a MySQL storage engine, which has been gaining popularity in recent years, as it provides a much better overall performance and a faster database failure recovery compared with the default engine used by the MySQL database management system – MyISAM. InnoDB is endorsed by a lot of developers that build highly scalable web applications, due to the fact that it works much more effectively with large volumes of data, while it keeps the server load at a minimum. In addition, it locks only one database row in case any information should be modified, while lots of other engines lock the entire database table and thus need much more time to accomplish multiple successive tasks. Last, but not least, InnoDB adheres to a set of "all-or-nothing" rules – in case the entire data modification procedure cannot be completed successfully for whatever reason, the action is rolled back to avoid scrambling or losing data. Magento and the newest releases of Joomla™ are two examples of widely used open-source script-driven web apps which have shifted over to InnoDB.
InnoDB in Shared Web Hosting
Every PHP-based web application that requires InnoDB will run impeccably on our innovative cloud platform and the MySQL database storage engine is offered with all our shared web hosting
packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database will use will be selected based on the app’s prerequisites without the need to edit any setting in your account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to make the most of its full capacity. We’ll maintain regular content backups, so in case you accidentally remove a MySQL database that’s important to you or you overwrite a certain part of it, we’ll be able to restore your content the way it was just a couple of hours ago.
InnoDB in Semi-dedicated Servers
InnoDB is available with each of our semi-dedicated plans
by default, so the moment you create a new account, you can move on and activate any PHP script-based web app that requires the database engine. A number of engines are pre-installed on our cloud hosting platform, so when you set up a new MySQL database and start installing an app manually, or decide to make use of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be selected depending on the specific app’s requirements. This will permit you to install and manage InnoDB-specific applications without running into any complication and without updating any settings in your semi-dedicated account. To be on the safe side, we’ll always have a 7-day-old backup of all your MySQL databases, so if you delete or edit any content unintentionally, we can quickly recover it.
InnoDB in VPS Servers
If our custom-built Hepsia hosting Control Panel is chosen during the registration process for a new VPS hosting plans
, InnoDB will be activated on the Virtual Private Server together with other required pieces of software, so you will not need to do anything if you decide to activate open-source script-based apps that need this MySQL database engine. The default MySQL engine, MyISAM, will be activated as well. You can create a new MySQL database and begin installing the application manually or through our one-click installer tool. The system will recognize the engine that the particular application requires and will set it for the specific database, so the installation will continue flawlessly and the app can insert its content into that database. Therefore, you can install applications with various requirements about the MySQL engine without having to make any modifications on your server.
InnoDB in Dedicated Servers
When you get a new dedicated server
, you’ll be able to pick one of the 3 hosting Control Panels that we are offering – DirectAdmin, Hepsia and cPanel. Any server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t have to add this MySQL database storage engine manually in order to be able to manage open-source script-powered software apps that require it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the system resources that you require in order to run large-scale websites, it’s rather likely that you will use InnoDB. You’ll be able to use other engines too, so in case a certain application needs MyISAM rather than InnoDB, you won’t come across any complication while managing it. The engine that will be used will be automatically detected when the app installation process starts, so you will not need to tweak any settings manually at any point.