InnoDB is a database engine for MySQL databases, which is used by popular PHP script-driven web applications like Magento and Joomla™ 3. It is perfect for scalable apps, since it works very well when handling immense amounts of data. Instead of locking the entire table to insert new information in a database as many other engines do, InnoDB locks only one database row, so it can perform a lot more tasks for the same length of time. Furthermore, InnoDB offers a better database crash recovery and supports database transactions and foreign key constraints – a set of rules that specify how data imports and updates should be treated. If a given operation has not been thoroughly completed for any reason, the action will be rolled back. Thus, the content in the database will stay intact and won’t be partially merged with newly entered content.
InnoDB in Website Hosting
InnoDB is offered with all our Linux website hosting plans by default, not as a paid upgrade or upon request, so you can install and run any open-source script-powered app that requires the storage engine without the need to deal with any problem as soon as you activate your shared account. InnoDB will be selected automatically as the default engine for a particular database during the app installation, regardless of whether you use our single-click installation tool or create the MySQL database and set up the application manually, on the condition that the app requires InnoDB instead of the more popular MyISAM engine. We will carry out regular backups of all your MySQL databases, so you can be certain that you will never lose any data if you delete a database accidentally or you overwrite some important information – you’ll just have to inform us and we’ll restore your database the way it was.
InnoDB in Semi-dedicated Servers
You can run a script-powered application that needs InnoDB with all of our semi-dedicated server packages, since all the accounts are set up on our cutting-edge cloud web hosting platform where the storage engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our single-click app installer tool. In either case, the needed engine will be selected automatically as soon as the activation of the app begins, so you won’t have to change anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. Also, we’ll always be able to recover any of your databases if you delete one by accident, as we make a few database backups every day, each of which is preserved for 1 week.
InnoDB in VPS Servers
If you obtain a VPS server from our company, you will be able to take advantage of our custom Hepsia Control Panel to manage your content. A Hepsia-equipped VPS will allow you to install any script-driven web app which requires InnoDB, as this database storage engine is included in the default software package that will be installed on the server during its setup. When you create a new database using the Control Panel, you will simply need to start installing an app – manually or using our app installer. InnoDB will be set as the default engine as long as the application in question needs it, so you will not have to do anything else in your account. Similarly, if a certain application requires MyISAM, it will be automatically set as the default engine for this concrete database.
InnoDB in Dedicated Servers
InnoDB is available as standard with all Linux dedicated servers that are ordered with the Hepsia Control Panel. It’s part of the default software package that will be installed on all Hepsia-managed servers, so as soon as your physical machine is up and running, you’ll be able to sign in and to activate any type of open-source script-driven software application that requires this particular MySQL database engine. When you create a new database via the hosting Control Panel, there won’t be any activated engine until you begin installing an application. Once the app setup wizard begins dumping content in the database, the engine will be set automatically on the basis of the prerequisites of the particular application, so you can run both MyISAM and InnoDB without selecting either one of them specifically at any point. In this way, you can make use of a broad selection of apps for your websites.