InnoDB
Learn what a database engine is, what exactly are the merits of the InnoDB engine and why it's gaining a huge amount of worldwide popularity.
InnoDB is a database storage engine for MySQL databases, which is used by well known open-source script-based software apps such as Joomla™ 3.x and Magento. It is excellent for scalable applications, as it works unbelievably well when processing huge amounts of data. Instead of locking the whole database table to import new information into a database like many other engines do, InnoDB locks only one row, so it can handle much more operations for the same period of time. In addition, InnoDB offers a faster crash recovery and supports transactions and foreign key constraints – rules that specify how data inserts and updates should be treated. If a particular operation has not been entirely completed for some reason, the action will be rolled back. Thus, the content in the database will remain safe and sound and will not be partially mixed with newly added content.
-
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with other hosting companies, it is part of the standard set of features that we offer with our
shared hosting packages. In case you’d like to use a PHP-driven app that needs InnoDB in particular, in order to be activated and to function properly, you won’t need to deal with any impediments because the MySQL database engine is available on our custom cloud Internet hosting platform. No matter if you create a brand new database and install an app manually or make use of our single-click app installer tool, InnoDB will be selected automatically by our system as the default engine if the respective app needs it rather than MyISAM. Besides the outstanding database failure recovery that InnoDB is offering, we also perform regular backups of all databases, so we can swiftly recover any MySQL database in your shared website hosting account.
-
InnoDB in Semi-dedicated Servers
All our
semi-dedicated hosting service come with InnoDB and you’ll be able to use all the features of this database storage engine with any PHP-driven web app that requires it. InnoDB is among the engines that we have on our cloud platform, so the one that will be used depends on the particular app’s requirements. You won’t have to do anything manually to activate InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our 1-click app installer. To be on the safe side, we’ll carry out regular MySQL database backups, so if anything goes wrong after some update or if you erase some data accidentally, we’ll be able to restore your database the way it was on any of the previous seven days.
-
InnoDB in VPS Servers
If you select a
VPS server with our Hepsia Control Panel, the InnoDB database storage engine will be an indivisible part of the standard software package that will be installed on your Virtual Private Server before we hand it over to you. You won’t need to activate anything manually and you’ll be able to enable and run any script-driven application that needs InnoDB when your VPS server is ready, which takes no more than one hour after the order submission itself. A couple of engines are available, so whenever you create a database through the Hepsia Control Panel, a specific engine will be activated once the app installation process starts and our system will recognize which engine is required by the application in question. If you need to use MyISAM, for instance, you will not have to do anything different than installing the chosen app, whether manually or using our application installer.
-
InnoDB in Dedicated Servers
InnoDB is included by default with all
dedicated servers that are ordered with the Hepsia hosting Control Panel. It is included in the default software bundle that will be pre-installed on all Hepsia-equipped servers, so as soon as your physical machine is set up, you’ll be able to sign in and to activate any kind of PHP script-powered software application that needs this particular MySQL database engine. When you set up a new MySQL database through the Control Panel, there won’t be any activated engine till you start installing an application. Once the app setup wizard begins inserting data into the database, the engine will be chosen automatically based on the requirements of the application in question, so you can use both InnoDB and MyISAM without selecting either one of them specifically at any moment. Therefore, you can make use of an extensive variety of applications for your websites.