InnoDB is a database engine for MySQL databases, which is used by widespread PHP-driven web apps such as Magento and Joomla v3. It’s ideal for scalable applications, since it performs very well when handling huge data volumes. Rather than locking the whole database table to enter new information into a database like many other engines do, InnoDB locks only one database row, so it can carry out much more operations for the same period of time. Additionally, InnoDB offers a much better database failure recovery and supports transactions and foreign keys – rules that determine how data inserts and updates should be handled. If a given operation has not been fully completed for whatever reason, the action will be rolled back. In this way, the content in the database will be kept undamaged and will not be partially mixed with newly inserted content.
InnoDB in Web Hosting
While InnoDB is either not available or a paid upgrade with many web hosting providers, it’s an essential part of the default set of features that we are offering with our web hosting packages. If you’d like to make use of a script-based app that requires InnoDB in particular, in order to be installed and to function correctly, you won’t experience any problems as the database engine is available on our custom cloud web hosting platform. No matter if you set up a new database and install an app manually or make use of our single-click app installer software instrument, InnoDB will be selected automatically by our system as the default engine if the specific app needs InnoDB rather than MyISAM. In addition to the exceptional crash recovery offered by InnoDB, we also maintain regular backups of all databases, so we can swiftly restore any database in your shared website hosting account.
InnoDB in Semi-dedicated Hosting
InnoDB is included with each of our Linux semi-dedicated hosting by default, so the moment you purchase a new semi-dedicated account, you can go on and activate any PHP script-based web app that needs the MySQL database storage engine. A couple of engines are installed on our cloud platform, so when you set up a new database and start installing an app manually, or opt to use the Hepsia Control Panel-integrated application installer tool, the engine for the database will be set on the basis of the requirements of the app in question. This will permit you to install and manage InnoDB-specific applications without coming across any complication and without needing to edit any settings in your account. To be on the safe side, we’ll always have a 7-day-old backup of all your databases, so if you remove or change any content by accident, we can swiftly rescue it.
InnoDB in VPS Hosting
All Linux VPS hosting that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to use any open-source script-powered app that requires this particular storage engine without the need to install anything manually. You can choose Hepsia on the VPS order page and your brand-new Virtual Private Server will be set up within 1 hour, so you can sign in and begin creating your sites straight away. When you set up a brand-new database and begin the app installation process, our system will pick the engine for that database automatically. In this way, you can activate various applications simultaneously without having to edit anything on the Virtual Private Server. You can set up a WordPress-powered online journal that uses the default MySQL engine – MyISAM, and a Magento-based web shop that makes use of InnoDB, for example.
InnoDB in Dedicated Web Hosting
InnoDB is available as standard with all dedicated hosting services that are ordered with the Hepsia hosting Control Panel. It is an integral part of the default software package that will be pre-installed on all Hepsia-managed servers, so as soon as your machine is ready, you’ll be able to sign in and to install a various open-source script-powered application that requires this particular database engine. If you set up a new MySQL database via the hosting Control Panel, there won’t be any activated engine till you start installing an app. Once the app activation wizard begins inserting information into the newly created database, the engine will be set automatically on the basis of the prerequisites of the given app, so you can run both MyISAM and InnoDB without the need to select either one of them explicitly at any moment. In this way, you can make use of an extensive range of applications for your Internet sites.