What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it offers a much better overall performance and a faster database crash recovery in comparison to the default engine that’s used by the MySQL relational database management system – MyISAM. InnoDB is preferred by numerous web developers that build highly scalable software applications, since it works much better with huge volumes of data, while it keeps the server processing load at a minimum. Also, it it locks only one row in the database in case any info should be edited, while lots of other engines lock the entire table and therefore need much more time to handle several successive tasks. Last, but not least, InnoDB complies with the "all-or-nothing" rule – if the entire data modification 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 famous PHP script-based apps that have switched over to InnoDB.
InnoDB in Shared Hosting
Any open-source script-based software application that needs InnoDB will function flawlessly on our avant-garde cloud website hosting platform and the database engine comes with all our shared hosting
packages. Each time you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected in accordance with the app’s specifications without the need to update any setting in your shared hosting account. InnoDB will be picked automatically for any app that requires this specific engine and you will be able to make the most of its full potential. We will make daily backups of your content, so in case you accidentally erase a database that’s important to you or you overwrite a specific part of it, we will be able to restore everything the way it was just several hours ago.
InnoDB in Semi-dedicated Servers
All our semi-dedicated servers
come with InnoDB and you can use all the features offered by this database storage engine with any open-source script-driven software application that requires it. It’s among the engines that are available on our cloud platform, so the one that will be used depends on the prerequisites of the given app. You won’t have to do anything manually in order to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our single-click application installer. To be on the safe side, we will carry out regular backups of all your MySQL databases, so if anything goes wrong after an upgrade or if you delete some content unintentionally, we will be able to get the database back to the way it was on any of the past seven days.
InnoDB in VPS Servers
If you order a VPS server
with our Hepsia Control Panel, the InnoDB storage engine will be included in the default software package that will be pre-installed on your Virtual Private Server before we hand it over to you. You won’t need to set up anything manually and you’ll be able to install and use any open-source script-driven application that requires InnoDB once your Virtual Private Server is up and running, which takes no more than one hour after the order process itself. A number of engines are available, so anytime you set up a database through the Hepsia hosting Control Panel, a specific engine will be activated once the app activation starts and our system will automatically recognize the engine that is required by the app in question. In case you need to use MyISAM, for example, you will not need to do anything different than installing the chosen app, whether manually or using our application installer tool.
InnoDB in Dedicated Servers
InnoDB comes as standard with all dedicated service
that are ordered with the Hepsia Control Panel. It’s included in the standard software bundle that we install on all Hepsia-equipped dedicated servers, so as soon as your physical machine is set up, you will be able to log in and to install any type of PHP script-driven software application that requires this particular MySQL database storage engine. If you set up a new MySQL database via the Control Panel, there won’t be any active engine until you begin installing an application. Once the app activation wizard starts dumping information in the database, the engine will be picked automatically on the basis of the requirements of the specific app, so you can use both MyISAM and InnoDB without selecting either one specifically at any time. Therefore, you can use an immense range of apps for your websites.