Read more about InnoDB and find out why it’s recently been chosen as the default MySQL database engine.
InnoDB is a database engine for MySQL relational databases, which is used by widely used PHP script-based applications such as Magento and Joomla™ v3. It’s excellent for scalable apps, because it performs really well when handling enormous 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 process much more tasks for the same length of time. Besides, InnoDB offers a much better database crash recovery and supports transactions and foreign keys – a set of rules that prescribe how data imports and modifications should be handled. In case a given task hasn’t been thoroughly completed for some reason, the action will be rolled back. In this way, the content in the database will remain intact and won’t be partially merged with newly entered content.
InnoDB in Cloud Website Hosting
InnoDB is offered with all our Linux cloud website hosting packages
by default, not as a paid upgrade or upon request, so you will be able to install and run any open-source script-based app which requires the MySQL database engine without having to deal with any difficulty as soon as you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app installation process, no matter if you use our 1-click installation tool or create the database and set up the app manually, as long as the app requires it instead of the more famous MyISAM engine. We’ll maintain daily backups of all your databases, so you can rest assured that you’ll never lose any data in case you delete a database by mistake or you overwrite some vital information – you will just have to alert us and we will restore everything the way it was.
InnoDB in Semi-dedicated Hosting
If you create a new MySQL database through the hosting Control Panel offered with all our semi-dedicated server
plans and you begin installing a script-driven software app either manually or using our 1-click app installer tool, the storage engine for the MySQL database will be set automatically on the basis of the prerequisites of the given app. As InnoDB is available on the cloud website hosting platform where your new account will be created, it will be set as the default engine for each application that needs it without the need for any manual intervention on your end at any moment. To prevent any risk of losing info if you update an app or if you remove a database by accident, we will perform a backup of all your MySQL databases every day, so if anything goes wrong, we can retrieve your content.
InnoDB in VPS Web Hosting
If you get a virtual private server
from us, you will be able to take full advantage of our custom-built Hepsia Control Panel to manage your content. A Hepsia-managed VPS will allow you to manage any script-driven software application which requires InnoDB, as the database engine is included in the standard software bundle that will be installed on the VPS server during its setup. When you set up a brand new MySQL database using the hosting Control Panel, you simply have to begin installing an app – manually or using our application installer tool. InnoDB will be set as the default engine if the application in question requires it, so you will not need to do anything else in your VPS account. Likewise, if an app requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.