InnoDB is a very popular storage engine for the MySQL database management system. It is an alternative to the default engine – MyISAM, and it has numerous advantages that make it the preferred engine for numerous script-driven web applications, such as Joomla and Magento, which have switched over to InnoDB permanently. For example, importing immense volumes of data will be much faster with InnoDB, due to the fact that it locks only a single row to accomplish a given task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and database transactions – these refer to the way in which the information is handled. Put simply, importing new or modifying existing data will either be fully completed, or will be aborted and the procedure will be rolled back in case a certain issue appears during the process, hence the content that remains in the database will not be lost.

InnoDB in Website Hosting

InnoDB is offered with all our Linux website hosting by default, not as a paid upgrade or upon request, so you can activate and run any PHP script-based web app which needs the InnoDB database storage engine without encountering any problem once you order your shared hosting account. InnoDB will be selected automatically as the default engine for a particular MySQL database during the app activation process, irrespective of whether you use our single-click installation tool or create the database and install the application manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We’ll create regular MySQL database backups, so you can be certain that you will never lose any content if you delete a database by mistake or you overwrite some key information – you will just need to touch base with us and we’ll restore your content back to normal.

InnoDB in Semi-dedicated Hosting

InnoDB is included with each of our Linux semi-dedicated hosting packages by default, so as soon as you purchase a new semi-dedicated account, you can go on and activate any PHP-driven software app that needs this particular MySQL database storage engine. A number of engines are pre-installed on our cloud web hosting platform, so when you set up a new MySQL database and begin installing an application manually, or decide to take advantage of the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be selected based on the prerequisites of the respective application. This will allow you to install and run InnoDB-specific applications without the need to cope with any difficulty and without having to configure any settings in your account. To be on the safe side, we’ll always keep a 1-week-old backup of all your databases, so if you delete or edit any content accidentally, we can swiftly retrieve it.

InnoDB in VPS Web Hosting

If you obtain a virtual private server from our company, you will be able to take full advantage of our custom-built Hepsia hosting Control Panel to manage your content. A Hepsia-managed Virtual Private Server will permit you to use any open-source script-based software app which needs InnoDB, as this MySQL database storage engine is an integral part of the software bundle that will be pre-installed on the VPS server during its configuration. When you set up a new MySQL database using the Control Panel, you just have to start installing an application – manually or using our application installer tool. InnoDB will be set as the default engine in case the application in question requires it, so you will not have to do anything else in your account. Analogously, if a certain application requires MyISAM, it will be automatically set as the default engine for this concrete MySQL database.

InnoDB in Dedicated Servers Hosting

Our Hepsia hosting Control Panel is among the options which you can pick on the order form when you purchase a dedicated server from us. Since this is the most powerful type of hosting, it is rather likely that you’ll run popular Internet sites that will draw plenty of individuals, and since InnoDB is among the best options for such websites, we’ll enable it together 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 account, there won’t be any active storage engine until you start installing an open-source PHP script, whether manually via your web browser or using the automatic scripts installer tool that is available in the hosting Control Panel. The necessary engine will be automatically detected and will be assigned to that database, so you can activate scripts that need InnoDB, as well as ones that need MyISAM – the default MySQL engine, without having to cope with any obstacle.