InnoDB is a popular database storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got plenty of upsides that make it the engine of choice for many PHP-powered software applications, including Magento and Joomla, which have switched over to InnoDB for good. For example, adding large data volumes will be faster with InnoDB, as it locks only a single row to execute a certain operation, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the information is tackled. To put it simply, importing new or editing existent data will either be thoroughly completed, or will be annulled and the procedure will be rolled back if a given problem shows up during the process, so the content that remains in the database won’t be lost.
InnoDB in Cloud Web Hosting
InnoDB is available with all our Linux cloud web hosting packages by default, not upon request or as a paid upgrade, so you will be able to activate and run any PHP-driven software app that needs the InnoDB storage engine without any obstacles as soon as you order your shared web hosting account. InnoDB will be selected automatically as the default engine for a given MySQL database during the app installation process, irrespective of whether you take advantage of our single-click installation tool or create the MySQL database and activate the app manually, as long as the app requires it instead of the more popular MyISAM engine. We’ll maintain regular backups of all your MySQL databases, so you can be sure that you won’t ever lose any content if you delete a database unintentionally or you overwrite some key information – you’ll simply need to alert us and we will restore everything back to normal.
InnoDB in Semi-dedicated Hosting
InnoDB is available with each of our Linux semi-dedicated hosting packages by default, so once you purchase a new account, you can go ahead and activate any PHP-driven web app that requires this particular database engine. Several engines are pre-installed on our cloud website hosting platform, so when you create a brand-new database and begin installing an application manually, or decide to use the Hepsia Control Panel-integrated application installer, the engine for the database will be selected on the basis of the prerequisites of the specific app. This will permit you to activate and manage InnoDB-specific applications without any impediments and without editing any settings in your account. To avoid any risk, we’ll always have a one-week-old backup of all your MySQL databases, so if you erase or alter any content by accident, we can easily recover it.
InnoDB in VPS Hosting
All Linux VPS hosting packages that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you’ll be able to run any PHP-driven application that needs the MySQL storage engine without needing to install anything manually. You can pick Hepsia on the VPS order page and your brand new server will be up and running within the hour, so you can log in and begin building your web sites straight away. Once you set up a new database and start the app installation process, our system will choose the engine for this MySQL database automatically. In this way, you can make use of different applications at the same time without configuring anything on the Virtual Private Server. You can set up a WordPress-powered personal journal that uses the default MySQL engine – MyISAM, and a Magento-driven web shop that uses the InnoDB engine, for instance.
InnoDB in Dedicated Web Hosting
All Linux dedicated servers hosting packages that are ordered with our in-house built Hepsia Control Panel include a software bundle that’s pre-installed and besides everything else, you’ll get the InnoDB database engine, so you won’t have to add it manually in case you’d like to run open-source PHP scripts that need it. All it takes to run such a script is to create a new database and to initiate the setup process – once the installer wizard receives access to the database in question and begins entering data into it, InnoDB will be set as the default MySQL engine for this database on the condition that it is the one needed by the script. You will also be able to install scripts that require the other widely used MySQL engine, MyISAM, so you will not need to edit any settings on the dedicated server. This will permit you to activate a variety of scripts on a single server and to use the latter to its full capacity.