InnoDB is a popular database storage engine for the MySQL RDBMS. It is an alternative to the default engine – MyISAM, and it has lots of pluses which make it the preferred engine for numerous open-source script-powered applications, such as Magento and Joomla™, which have switched over to InnoDB for good. For example, importing immense data volumes will be faster with InnoDB, because it locks only a single database row to complete a particular task, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the data is treated. In simpler words, adding new or updating existing data will either be fully completed, or will be canceled and the operation will be rolled back if some issue occurs in the meantime, which means that the content that remains in the database won’t be damaged.
InnoDB in Shared Hosting
While InnoDB is either not offered or it is a paid upgrade with many other website hosting service providers, it is part of the default set of services that we’re offering with our shared hosting plans. If you want to make use of a script-powered software application that needs InnoDB particularly, in order to be installed and to operate correctly, you won’t need to deal with any problems as the storage engine is available on our custom-built cloud web hosting platform. Regardless of whether you create a brand new MySQL database and activate an application manually or make use of our 1-click app installer software instrument, InnoDB will be selected automatically by our platform as the default engine if the respective app needs it instead of MyISAM. In addition to the amazing database failure recovery that InnoDB is offering, we also carry out regular backups of all databases, so that we can easily recover any MySQL database in your shared account.
InnoDB in Semi-dedicated Servers
InnoDB is offered with all our Linux semi-dedicated servers by default, so as soon as you order a new semi-dedicated account, you can go on and activate any script-driven app that requires this database engine. A couple of engines are pre-installed on our cloud website hosting platform, so when you set up a new MySQL database and begin installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be selected on the basis of the requirements of the respective application. This will allow you to install and run InnoDB-specific applications without needing to deal with any obstacle and without having to configure any settings in your semi-dedicated account. To take no chances, we will always have a seven-day-old backup of all your MySQL databases, so if you erase or edit any content by accident, we can easily recover it.
InnoDB in VPS Servers
When you obtain a VPS server from our company, you will be able to make use of our custom-built Hepsia Control Panel to manage your web content. A Hepsia-managed Virtual Private Server will permit you to activate any open-source script-based software app that requires InnoDB, as this particular storage engine is an essential part of the software package that will be pre-installed on the VPS server during its configuration. When you set up a brand-new database via the Control Panel, you simply have to begin installing an application – manually or using our application installer. InnoDB will be set as the default engine in case the application in question needs it, so you will not have to do anything else in your account. In the same manner, if a given app needs MyISAM, it will be automatically set as the default engine for this concrete MySQL database.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the features that you can select on the order form when you buy a dedicated server from us. Since this is the most powerful type of website hosting, it is rather likely that you’ll manage popular websites that will draw plenty of people, and since InnoDB is one of the very best choices for such websites, we will enable it along with all the other software apps that come with a Hepsia-managed dedicated server. When you create a brand new MySQL database in your dedicated account, there won’t be any active database engine till you start installing a PHP script, whether manually via your Internet browser or using the automatic script installation tool that is integrated into the Control Panel. The required engine will be automatically recognized and will be assigned to the database in question, so you can use scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without experiencing any difficulty.