InnoDB is a very popular storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has got numerous upsides that make it the engine of choice for a lot of open-source script-driven software applications, including Joomla and Magento, which have switched to InnoDB for good. For example, adding immense amounts of data will be much faster with InnoDB, because it locks only a single database row to execute a particular task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the information is treated. Simply put, appending new or modifying existent data will either be fully completed, or will be canceled and the procedure will be rolled back in case a certain problem occurs in the meantime, which means that the content that remains in the database won’t be damaged.

InnoDB in Cloud Website Hosting

InnoDB is offered with all our Linux cloud website hosting service by default, not as a paid upgrade or upon request, so you can install and run any PHP-driven web app which needs the MySQL database engine without any difficulty as soon as you open your shared website hosting account. InnoDB will be selected automatically as the default engine for a particular database during the app installation process, irrespective of whether you use our single-click installer or create the MySQL database and install the application manually, provided that the app requires InnoDB instead of the more popular MyISAM engine. We will make regular database backups, so you can be certain that you will never lose any data in case you erase a database by mistake or you overwrite some essential information – you simply have to touch base with us and we’ll restore everything back to normal.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our Linux semi-dedicated servers by default, so once you get a new account, you can move on and activate any PHP script-based web app that needs the database engine. Several engines are pre-installed on our cloud hosting platform, so when you create a brand new MySQL database and start installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be selected in accordance with the requirements of the given app. This will permit you to install and manage InnoDB-specific apps without needing to cope with any problem and without having to modify any settings in your semi-dedicated account. To be on the safe side, we’ll always have a one-week-old backup of all your databases, so if you erase or change any content by accident, we can swiftly restore it.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia Control Panel, the InnoDB storage engine will be an indivisible part of the software package that will be installed on your VPS server before we give it to you. You won’t need to configure anything manually and you will be able to install and manage any script-powered app that needs InnoDB once your VPS is up and running, which takes no more than 60 minutes after the order process itself. A couple of engines are offered, so whenever you create a database through the Hepsia Control Panel, a specific engine will be activated once the app activation process begins and our system will automatically recognize the engine that is required by the app in question. In case you have to use MyISAM, for instance, you won’t need to do anything different from installing the chosen app, whether manually or using our application installer.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is among the options which you can select on the order form when you buy a dedicated server from us. As this is the most powerful type of website hosting, it’s rather likely that you’ll run very popular Internet sites that will attract plenty of individuals, and since InnoDB is one of the very best options for such websites, we’ll install it along with all the other software apps that are available with a Hepsia-managed dedicated server. When you create a brand new MySQL database in your dedicated server account, there won’t be any activated database storage engine till you start installing an open-source PHP script, whether manually through your Internet browser or using the automatic scripts installation tool that is included in the Control Panel. The necessary engine will be recognized automatically and will be set for that database, so you can run scripts that require InnoDB, as well as ones that need MyISAM, the default MySQL engine, without having to deal with any problem.