InnoDB is a database storage engine for MySQL relational databases, which is used by widespread PHP script-powered applications like Magento and Joomla v3. It is excellent for scalable apps, since it works amazingly well when managing huge volumes of data. Rather than locking the whole table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can handle much more tasks for the same length of time. Furthermore, InnoDB offers a much faster database failure recovery and supports transactions and foreign keys – rules that define how data inserts and updates should be handled. In case a certain task hasn’t been fully completed for whatever reason, the action will be rolled back. In this way, the database content will be preserved safe and sound and will not be partially mixed with newly imported content.
InnoDB in Website Hosting
You can use any script-driven software app that requires InnoDB if you have a Linux website hosting with us, as the MySQL database storage engine is present on our advanced cloud platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is needed. You can install applications that use the MyISAM engine without the need to deal with any complication as well and, again, the engine will be pre-selected, so you won’t have to modify anything manually at any time. In addition, we will also make regular backups of all the MySQL databases that you’ve got in the account, so if you erase or overwrite anything, we can quickly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Hosting
You can use a script-powered web app that needs InnoDB with any of our semi-dedicated server packages, since all the accounts are set up on our leading-edge cloud 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 – if you make use of our single-click app installer. Either way, the required engine will be selected automatically as soon as the application’s installation starts, so you won’t need to change anything manually, regardless of whether the app requires InnoDB or the more commonly used MyISAM. In addition, we’ll always be able to retrieve any of your databases if you erase one by mistake, as we make a few backups every day, each of which is kept for one whole week.
InnoDB in VPS Hosting
All VPS hosting that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you’ll be able to take advantage of any PHP script-powered software app that requires the MySQL database engine without activating anything manually. You can pick Hepsia on the VPS order form and your new server will be ready within sixty minutes, so you can sign in and start creating your websites right away. When you create a new database and start the app installation process, our system will set the engine for this database automatically. Thus, you can install various applications at the same time without having to change anything on the VPS server. You can create a WordPress personal journal that uses the default MySQL engine – MyISAM, and a Magento-powered online shop that makes use of InnoDB, for instance.
InnoDB in Dedicated Web Hosting
InnoDB comes by default with all dedicated web hosting that are ordered with the Hepsia Control Panel. It’s 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 up and running, you’ll be able to log in and to install a various PHP-powered software app that needs this database storage engine. When you create a new MySQL database through the Control Panel, there won’t be any active engine till you begin installing an app. As soon as the app installation wizard begins inserting data into the newly created database, the engine will be selected automatically in accordance with the specific app’s prerequisites, so you can use both InnoDB and MyISAM without the need to select either one explicitly at any point. Therefore, you can make use of a huge collection of applications for your sites.