InnoDB is a database engine for MySQL databases, which is used by widely used PHP script-based web apps like Joomla™ 3 and Magento. It is excellent for scalable apps, as it excels in processing huge volumes of data. Instead of locking the entire table to enter new information into a database as many other engines do, InnoDB locks only one database row, so it can process much more operations for the same period of time. What’s more, InnoDB offers a much better crash recovery and supports transactions and foreign key constraints – a set of rules that specify how data imports and modifications should be handled. If a certain task has not been fully completed for any reason, the action will be rolled back. Thus, the database content will stay intact and won’t be partially merged with new content.
InnoDB in Cloud Website Hosting
Every open-source script-based web application that requires InnoDB will run flawlessly on our avant-garde cloud platform and the MySQL storage engine is offered with all our cloud website hosting
plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation is initiated, the engine that the database will use will be selected in accordance with the app’s prerequisites without the need to change any setting in your hosting account. InnoDB will be picked automatically for any app that requires this specific engine and you will be able to get the most out of its full capacity. We’ll create daily content backups, so if you accidentally delete a MySQL database that’s important to you or you overwrite a certain part of it, we’ll be able to restore your database the way it was only a couple of hours earlier.
InnoDB in Semi-dedicated Servers
You can install an open-source script-powered application that requires InnoDB with all of our semi-dedicated server
packages, because all the accounts are created on our avant-garde cloud hosting platform where the database engine is installed. A new database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our 1-click app installer tool. Either way, the needed engine will be chosen automatically once the app’s installation begins, so you will not need to configure anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. Also, we will always be able to restore any of your MySQL databases if you unintentionally delete one, as we generate several database backups every day, each of which is preserved for 7 days.
InnoDB in VPS Servers
All VPS plans
that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to run any open-source script-powered software app that requires this particular MySQL storage engine without the need to install anything manually. You can choose Hepsia on the VPS configuration page and your brand new Virtual Private Server will be ready within one hour, so you can log in and start building your Internet sites straight away. When you set up a new database and begin the app activation process, our system will choose the engine for that MySQL database automatically. In this way, you can activate various applications at the same time without having to configure anything on the VPS server. You can have a WordPress-powered personal weblog that makes use of MyISAM – the default MySQL engine, and a Magento web shop that uses InnoDB, for instance.
InnoDB in Dedicated Servers
InnoDB is included as standard with all Linux dedicated web hosting plans
that are ordered with the Hepsia Control Panel. It is an essential part of the default software bundle that will be pre-installed on all Hepsia-managed servers, so once your physical machine is assembled, you will be able to log in and to activate any PHP-powered application that requires this particular storage engine. When you set up a new MySQL database through the hosting Control Panel, there won’t be any activated engine until you begin installing an app. As soon as the app setup wizard starts importing content into the newly created database, the engine will be set automatically on the basis of the requirements of the particular app, so you can use both InnoDB and MyISAM without selecting either one of them specifically at any time. Thus, you can make use of an extensive selection of apps for your sites.