InnoDB
What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a database storage engine for MySQL relational databases, which is used by famous PHP-powered software apps such as Magento and Joomla™ v3. It’s perfect for scalable apps, since it performs astonishingly well when processing enormous amounts of data. Rather than locking the entire database table to insert new information in a database like many other engines do, InnoDB locks only one row, so it can process a lot more tasks for the same period of time. Additionally, InnoDB offers a much better database failure recovery and supports transactions and foreign keys – rules that specify how data inserts and updates should be treated. If a particular operation hasn’t been fully completed for whatever reason, the action will be rolled back. Thus, the information in the database will remain safe and sound and won’t be partially merged with newly imported content.
-
InnoDB in Cloud Website Hosting
InnoDB is available with all our
cloud website hosting plans by default, not upon request or as a paid upgrade, so you will be able to install and run any PHP script-powered web app which needs the database engine without any problems as soon as you order your account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation, regardless of whether you make use of our single-click installer or create the database and install the app manually, as long as the app requires InnoDB instead of the more famous MyISAM engine. We will store regular backups of all your MySQL databases, so you can be certain that you’ll never lose any data in case you delete a database accidentally or you overwrite some important info – you’ll simply have to get in touch with us and we will restore everything the way it was.
-
InnoDB in VPS Servers
All
VPS hosting plans that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to use any PHP-powered app that needs this particular MySQL storage engine without needing to set up anything manually. You can pick Hepsia on the VPS configuration page and your brand new server will be ready within one hour, so you can sign in and begin creating your Internet sites straight away. When you create a new MySQL database and begin the app installation process, our system will select the engine for this MySQL database automatically. In this way, you can manage different apps simultaneously without modifying anything on the Virtual Private Server. You can create a WordPress-driven online blog that uses the default MySQL engine – MyISAM, and a Magento online shopping portal that makes use of InnoDB, for instance.