InnoDB
Find out more on InnoDB and find out why it’s recently been chosen as the default MySQL database engine.
InnoDB is a MySQL storage engine, which has been gaining in popularity lately, because it provides a better overall performance and a faster crash recovery in comparison with the default engine used by the MySQL RDBMS – MyISAM. InnoDB is used by numerous devs that run scalable software apps, due to the fact that it works much more efficiently with immense data volumes, while it keeps the server load low. In addition, it locks only one database row in case any information should be edited, while lots of other engines lock the entire database table and therefore need much more time to perform multiple sequential tasks. Last, but not least, InnoDB observes a set of "all-or-nothing" rules – if the entire data modification process cannot be completed for any reason, the operation is rolled back to avoid scrambling or data loss. Magento and the latest Joomla™ releases are two instances of widely used PHP script-driven web apps which have moved to InnoDB.
-
InnoDB in Shared Website Hosting
Any open-source script-based application that needs InnoDB will run impeccably on our cutting-edge cloud hosting platform and the storage engine comes with all our
shared website hosting packages. Each time you create a MySQL database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database in question will use will be selected on the basis of the app’s requirements without having to update any setting in your shared hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you’ll be able to get the most out of its full potential. We will keep daily content backups, so in case you unintentionally delete a database that is important to you or you overwrite some part of it, we’ll be able to restore your data the way it was only a couple of hours earlier.
-
InnoDB in Semi-dedicated Servers
You can make use of a PHP-based app that requires InnoDB with any of our
semi-dedicated server packages, because all the accounts are created on our leading-edge cloud platform where the MySQL database engine is installed. A new database can be created in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you make use of our one-click application installer tool. In either case, the needed engine will be selected automatically the moment the installation of the application starts, so you will not need to configure anything manually, regardless of whether the app needs InnoDB or the more frequently used MyISAM. In addition, we will always be able to retrieve any of your MySQL databases if you accidentally delete one, as we carry out several backups every day, each of which is preserved for 1 whole week.
-
InnoDB in VPS Servers
All
VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you’ll be able to use any PHP-driven app that needs the MySQL database storage engine without the need to set up anything manually. You can select Hepsia on the VPS configuration page and your brand-new server will be up and running within 60 minutes, so you can sign in and begin creating your web sites right away. When you create a brand new database and start the app activation process, our system will set the engine for this MySQL database automatically. Thus, you can manage different apps at the same time without having to change anything on the Virtual Private Server. You can have a WordPress-driven personal journal that makes use of the default MySQL engine – MyISAM, and a Magento-driven e-commerce site that uses the InnoDB engine, for instance.
-
InnoDB in Dedicated Servers
All
dedicated servers that are ordered with our custom Hepsia hosting Control Panel include a software bundle that’s pre-activated and among everything else, you will get the InnoDB storage engine, so you won’t need to install it manually if you’d like to use scripts that need it. All it takes to use such a script is to set up a new database and to initiate the installation process – once the script installation wizard accesses the database in question and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the script. You’ll also be able to run scripts that need MyISAM, the other very popular MySQL engine, so you will not need to modify any settings on the server. This will permit you to use a variety of scripts on a single machine and to use the latter to its full capabilities.