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 many pluses which have made it the engine of choice for lots of PHP script-driven web applications, including Joomla™ and Magento, which have shifted over to InnoDB for good. For example, importing large volumes of data will be much faster with InnoDB, because it locks only one row to execute a given 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 handled. Put simply, importing new or updating existing data will either be entirely completed, or will be aborted and the procedure will be rolled back in case any problem shows up in the meantime, so the content that remains in the database won’t be damaged.

InnoDB in Cloud Hosting

InnoDB is available with all our cloud hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and manage any script-based software app that requires the InnoDB database engine without having to deal with any difficulty as soon as you open your shared web hosting account. InnoDB will be selected automatically as the default engine for a certain MySQL database during the app activation process, no matter if you use our one-click installer or create the database and install the app manually, on the condition that the application requires it instead of the more famous MyISAM engine. We’ll carry out regular backups of all your databases, so you can be sure that you won’t ever lose any content in case you erase a database by mistake or you overwrite some essential information – you will just have to alert us and we will restore everything the way it was.

InnoDB in Semi-dedicated Servers

InnoDB is available with each of our semi-dedicated servers by default, so the moment you obtain a new semi-dedicated account, you can go ahead and install any PHP-powered application that needs this particular MySQL database storage engine. A few engines are installed on our cloud website hosting platform, so when you create a brand-new database and start installing an app manually, or opt to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be selected in accordance with the respective app’s prerequisites. This will permit you to install and manage InnoDB-specific applications without the need to cope with any complication and without configuring any settings in your semi-dedicated account. To avoid any risk, we’ll always have a 7-day-old backup of all your MySQL databases, so if you remove or edit any content unintentionally, we can easily recover it.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you’ll be able to take advantage of any PHP-driven application that needs this particular database storage engine without having to configure anything manually. You can choose Hepsia on the VPS configuration page and your brand new Virtual Private Server will be set up within 1 hour, so you can log in and start creating your websites straight away. Once you set up a brand-new MySQL database and begin the app activation process, our system will set the engine for this database automatically. Thus, you can make use of various apps at the same time without the need to change anything on the VPS server. You can set up a WordPress-based weblog that makes use of the default MySQL engine – MyISAM, and a Magento-powered e-commerce portal that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

If you obtain a new dedicated server, you will be able to choose any of the three hosting Control Panels that we are offering – DirectAdmin, cPanel and Hepsia. Each dedicated server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t need to enable this MySQL storage engine manually in order to be able to run script-based software apps that require it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the resources that you require in order to run large-scale websites, it is very likely that you will use InnoDB. You’ll be able to make use of other engines as well, so if a specific application needs MyISAM instead of InnoDB, you will not need to deal with any complication while managing it. The engine that will be used will be automatically recognized the moment the app installation procedure starts, so you won’t need to change any setting manually at any moment.