InnoDB is a database engine for MySQL databases, which is used by widespread script-powered software applications such as Magento and Joomla™ 3. It’s excellent for scalable apps, since it performs incredibly well when handling large volumes of data. Instead of locking the whole database table to insert new information in a database like many other engines do, InnoDB locks only one database row, so it can process a lot more operations for the same period of time. Also, InnoDB offers a better crash recovery and supports transactions and foreign key constraints – a set of rules that indicate how data imports and modifications should be handled. In case a given task hasn’t been thoroughly completed for any reason, the action will be rolled back. In this way, the information in the database will be preserved undamaged and will not be partially merged with newly added content.

InnoDB in Cloud Website Hosting

InnoDB is offered with all our cloud website hosting plans by default, not upon request or as a paid upgrade, so you can install and run any PHP script-powered app that needs the MySQL database engine without having to deal with any difficulty as soon as you activate your shared web hosting account. InnoDB will be selected automatically as the default engine for a specific MySQL database during the app activation, no matter if you make use of our 1-click installer or create the database and install the app manually, provided that the app requires it instead of the more popular MyISAM engine. We’ll carry out regular backups of all your MySQL databases, so you can be sure that you will never lose any data if you delete a database accidentally or you overwrite some vital information – you’ll just need to inform us and we will restore everything back to normal.

InnoDB in Semi-dedicated Servers

You can install a PHP-powered web application that needs InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are set up on our cutting-edge cloud platform where the storage engine is installed. A new database can be set up in two separate ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you make use of our 1-click app installer tool. Either way, the needed engine will be picked automatically once the activation of the application starts, so you will not have to modify anything manually, irrespective of whether the application needs InnoDB or the more regularly used MyISAM. Furthermore, we will always be able to retrieve any of your MySQL databases in case you unintentionally remove one, as we generate several database backups every day, each of which is stored for 1 whole week.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to make use of any PHP-driven web app that needs this particular database engine without setting up anything manually. You can pick Hepsia on the VPS order form and your new VPS server will be ready within 1 hour, so you can sign in and begin setting up your sites right away. When you create a new database and begin the app installation process, our system will choose the engine for this database automatically. In this way, you can use different apps simultaneously without changing anything on the VPS server. You can create a WordPress personal blog that uses MyISAM – the default MySQL engine, and a Magento e-commerce site that makes use of the InnoDB engine, for instance.

InnoDB in Dedicated Servers

If you get a new dedicated server, you will be able to pick one of the three hosting Control Panels that we offer – cPanel and Hepsia. Each server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you will not have to activate this MySQL storage engine manually in order to be able to use PHP script-driven applications that need it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the system resources that you need in order to run very large websites, it’s quite likely that you’ll use InnoDB. You will be able to use other engines as well, so if a particular app needs MyISAM rather than InnoDB, you won’t have to deal with any complication while using it. The engine that will be used will be automatically detected when the app installation begins, so you will not need to change any setting manually at any time.