InnoDB is a popular storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has numerous strong sides that make it the preferred engine for many open-source script-based apps, including Joomla™ and Magento, which have moved to InnoDB permanently. For example, importing huge data volumes will be much faster with InnoDB, since it locks only a single row to execute a given operation, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the info is handled. Put simply, adding new or editing existent data will either be fully completed, or will be aborted and the procedure will be rolled back if a given problem shows up in the meantime, hence the content that remains in the database will not be lost.

InnoDB in Web Hosting

You can make use of any script-driven web app that requires InnoDB if you have a Linux web hosting service with our company, as the database engine is present on our advanced cloud platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably in case this engine is required. You can install applications that require the MyISAM engine without the need to deal with any complication as well and, once again, the engine will be selected automatically, so you will not have to update anything manually at any time. On top of that, we will also carry out daily backups of all the databases that you have in your shared web hosting account, so in case you erase or overwrite anything, we can easily get it back to the way it was on any of the previous 7 days.

InnoDB in Semi-dedicated Servers

InnoDB comes with each of our semi-dedicated service by default, so as soon as you buy a new semi-dedicated account, you can go on and install any open-source script-driven software app that requires this database engine. A number of engines are installed on our cloud platform, so when you set up a new MySQL database and begin installing an application manually, or decide to make use of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be chosen based on the prerequisites of the given application. This will permit you to install and manage InnoDB-specific applications without needing to cope with any obstacle and without the need to modify any settings in your semi-dedicated account. To take no chances, we will always have a seven-day-old backup of all your databases, so if you erase or alter any content by accident, we can swiftly recover it.

InnoDB in VPS Servers

All Linux VPS hosting service that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to make use of any PHP script-driven web app that requires the storage engine without having to configure anything manually. You can pick Hepsia on the VPS configuration page and your brand new Virtual Private Server will be ready within 60 minutes, so you can sign in and start creating your websites straight away. When you set up a brand new MySQL database and start the app activation process, our system will pick the engine for that MySQL database automatically. Thus, you can use various apps simultaneously without modifying anything on the server. You can create a WordPress-driven online journal that uses MyISAM – the default MySQL engine, and a Magento-powered e-commerce site that uses the InnoDB engine, for instance.

InnoDB in Dedicated Servers

InnoDB comes as standard with all Linux dedicated service ordered with the Hepsia hosting Control Panel. It is part of the standard software bundle that will be pre-installed on all Hepsia-managed dedicated servers, so as soon as your physical machine is set up, you will be able to log in and to activate any PHP-driven web app that needs this storage engine. If you create a new database through the Control Panel, there won’t be any active engine until you start installing an application. Once the app setup wizard starts dumping information in the database, the engine will be chosen automatically in accordance with the requirements of the specific application, so you can run both MyISAM and InnoDB without having to select either of them specifically at any moment. Thus, you can make use of a large variety of apps for your websites.