InnoDB
What?s InnoDB? Why has it been used as the standard MySQL storage engine?
InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, because it offers a better overall performance and an improved database crash recovery in comparison to the default engine that is used by the MySQL RDBMS – MyISAM. InnoDB is used by plenty of programmers that run scalable apps, as it works more efficiently with large volumes of data, while it keeps the server processing load at a minimum. Additionally, it uses row-level locking in case anything should be modified, whereas lots of other engines lock the entire database table and thus require more time to carry out multiple consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the entire data modification procedure cannot be completed for some reason, the action is rolled back to avoid scrambling or the loss of data. Magento and the newest Joomla™ editions are two instances of popular script-driven software apps which have switched over to InnoDB.
-
InnoDB in Hosting
Every PHP-powered application that requires InnoDB will run flawlessly on our avant-garde cloud hosting platform and the database engine comes with all our
hosting packages. Every time you create a database manually or our app installer creates one automatically and an app installation process is initiated, the engine that the database in question will make use of will be selected on the basis of the app’s requirements without having to edit any setting in your web hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you will be able to make the most of its full capacity. We will generate daily backups of your content, so in case you accidentally erase a MySQL database that you need or you overwrite some part of it, we will be able to restore your data the way it was just a couple of hours earlier.
-
InnoDB in Semi-dedicated Servers
If you set up a new MySQL database from the Control Panel provided with each of our
semi-dedicated server plans and you begin installing a PHP script-driven software app either manually or using our single-click application installer, the database storage engine will be picked automatically based on the prerequisites of the particular application. As InnoDB is present on the cloud website hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each app that needs it without any manual action required on your end at any point. To prevent any chance of losing data if you update an application or if you remove a database by mistake, we’ll carry out backups of all your MySQL databases each day, so if something happens, we can restore your content.
-
InnoDB in VPS Servers
All
VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to take advantage of any PHP-powered software app that requires this particular MySQL database engine without the need to set up anything manually. You can pick Hepsia on the VPS configuration page and your new VPS server will be set up within sixty minutes, so you can log in and start building your sites straight away. Once you create a brand new database and begin the app installation process, our system will choose the engine for that database automatically. Thus, you can use various apps simultaneously without having to configure anything on the Virtual Private Server. You can set up a WordPress-driven online blog that makes use of the default MySQL engine – MyISAM, and a Magento web store that uses the InnoDB engine, for instance.
-
InnoDB in Dedicated Servers
All
dedicated servers that are ordered with our custom-built Hepsia hosting Control Panel come with a software package that is pre-installed and besides everything else, you will get the InnoDB database engine, so you won’t need to install it manually if you would like to activate open-source scripts that need it. All it takes to activate such a script is to create a new MySQL database and to begin the installation process – once the installer wizard receives access to the database in question and begins entering data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You’ll also be able to use scripts that need the other popular MySQL engine, MyISAM, so you won’t need to modify any settings on the server. This will enable you to install various scripts on a single physical server and to use it to its fullest capacity.