Become aware of what a database engine is, what exactly are the merits of the InnoDB engine and why it's gaining that much global popularity.
InnoDB is a database engine for MySQL databases, which is used by well known open-source script-powered software apps such as Magento and Joomla™ v3. It’s perfect for scalable applications, because it performs incredibly well when handling immense volumes of data. Instead of locking the whole database table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can carry out a lot more tasks for the same period of time. Besides, InnoDB offers an improved database failure recovery and supports database transactions and foreign keys – rules that determine how data imports and updates should be handled. If a certain task has not been entirely completed for whatever reason, the action will be rolled back. Thus, the information in the database will be kept undamaged and won’t be partially merged with newly added content.
InnoDB in Cloud Hosting
Any script-based software application that requires InnoDB will function impeccably on our leading-edge cloud web hosting platform and the storage engine comes with all our cloud hosting
plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will use will be selected on the basis of the app’s prerequisites without having to change any setting in your shared web hosting account. InnoDB will be selected automatically for any application that requires this specific engine and you will be able to get the most out of its full capacity. We’ll carry out daily content backups, so if you accidentally remove a database that you need or you overwrite some part of it, we will be able to restore your content the way it was only several hours ago.
InnoDB in Semi-dedicated Servers
If you set up a brand-new MySQL database from the Control Panel coming with each of our semi-dedicated server
packages and you start installing a PHP-driven web application either manually or using our 1-click app installer, the storage engine for the MySQL database will be picked automatically on the basis of the given app’s requirements. As InnoDB is present on the cloud platform where your new semi-dedicated server account will be created, it will be set as the default engine for any application that needs it without any manual action required on your end at any point. To prevent any risk of losing information if you update an app or if you remove a database by mistake, we will perform backups of all your databases every day, so if something happens, we can retrieve your data.
InnoDB in VPS Servers
In case our in-house built Hepsia hosting Control Panel is chosen during the registration process for a new VPS servers
, InnoDB will be installed on the Virtual Private Server together with other necessary software, so you won’t have to do anything if you decide to activate script-based applications that need this MySQL database storage engine. MyISAM, the default MySQL engine, will be activated too. You can create a brand new database and begin the app installation manually or using our 1-click installer tool. The system will detect the engine that the particular app requires and will assign it to the specific MySQL database, so the installation will proceed impeccably and the app can dump its content in that database. Thus, you can run applications with different prerequisites in regard to the MySQL engine without the need to make any modifications on your VPS server.
InnoDB in Dedicated Servers
InnoDB is included by default with all dedicated service
that are ordered with the Hepsia hosting Control Panel. It’s an integral part of the software package that we install on all Hepsia-managed servers, so once your physical machine is assembled, you’ll be able to sign in and to activate any kind of script-powered web application that requires this MySQL database storage engine. When you create a new database via the Control Panel, there won’t be any activated engine till you start installing an application. Once the app configuration wizard begins dumping data in the database, the engine will be set automatically depending on the prerequisites of the application in question, so you can use both InnoDB and MyISAM without selecting either one specifically at any time. Therefore, you can make use of a vast collection of apps for your Internet sites.