See what a database engine is, what are the merits of the InnoDB engine and why it's gaining a lot of worldwide popularity.
InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it offers a significantly better overall performance and a faster database crash recovery in comparison to the default engine that’s used by the MySQL database management system – MyISAM. InnoDB is preferred by lots of programmers that build scalable apps, since it works much more efficiently with enormous data volumes, while it keeps the server processing load at a minimum. Moreover, it locks only one database row if any information should be edited, whereas many other engines lock the entire table and hence need much more time to fulfill multiple successive tasks. Last, but not least, InnoDB adheres to the "all-or-nothing" rule – if the entire data modification cannot be completed successfully for whatever reason, the operation is rolled back to avoid scrambling or data loss. Magento and the newest releases of Joomla™ are two examples of popular PHP-driven web applications that have shifted over to InnoDB.
InnoDB in Shared Hosting
Every open-source script-powered application that needs InnoDB will function impeccably on our avant-garde cloud website hosting platform and the MySQL database engine is available with all our shared hosting
packages. Whenever you create a database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s specifications without having to edit any setting in your web hosting account. InnoDB will be selected automatically for any application that requires this particular engine and you will be able to make the most of its full potential. We will maintain daily backups of your content, so if you accidentally erase a database that is important to you or you overwrite certain parts of it, we will be able to restore your data the way it was just several hours ago.
InnoDB in Semi-dedicated Servers
You can use a PHP-powered web application that needs InnoDB with any of our semi-dedicated server
plans, because all the accounts are set up on our innovative cloud platform where the database storage engine is installed. A new database can be created in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you take advantage of our single-click app installer tool. Either way, the needed engine will be selected automatically once the app’s installation begins, so you will not have to configure anything manually, regardless of whether the app needs InnoDB or the more widely used MyISAM. In addition, we will always be able to recover any of your MySQL databases if you unintentionally remove one, as we carry out a few MySQL database backups every day, each of which is preserved for seven days.
InnoDB in VPS Servers
In case our custom-built Hepsia Control Panel is picked during the registration process for your new VPS servers
, InnoDB will be installed on the VPS server along with other required software, so you will not need to do anything if you choose to run script-driven applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed as well. You can create a brand-new MySQL database and begin the app installation manually or using our single-click installer. The system will detect the engine that the application in question needs and will assign it to the specific MySQL database, so the installation will continue impeccably and the app can enter its data into that database. Therefore, you can make use of apps with different prerequisites concerning the MySQL engine without making any modifications on your Virtual Private Server.
InnoDB in Dedicated Servers
All dedicated servers
ordered with our custom-developed Hepsia Control Panel come with a software bundle that is pre-installed and besides everything else, you’ll get the InnoDB database engine, so you won’t have to activate it manually if you want to activate open-source scripts that need it. All it takes to run such a script is to set up a new database and to start the setup – once the script installation wizard obtains access to the database in question and begins dumping content in it, InnoDB will be set as the default engine for this database as long as it is the one required by the particular script. You’ll also be able to run scripts that require MyISAM, the other widely used MySQL engine, so you will not have to change any settings on the server. This will enable you to install various scripts on a single machine and to use the latter to its maximum capabilities.