InnoDB is a storage engine for MySQL databases, which is used by widely used PHP-driven applications like Joomla™ 3 and Magento. It is excellent for scalable applications, because it performs very well when processing large data volumes. Rather than locking the whole database table to enter new information into a database as many other engines do, InnoDB locks only one row, so it can carry out much more operations for the same length of time. Moreover, InnoDB offers a much better database crash recovery and supports transactions and foreign keys – rules that indicate how data inserts and updates should be handled. In case a certain task hasn’t been entirely completed for any reason, the action will be rolled back. In this way, the database content will be retained safe and sound and won’t be partially mixed with newly entered content.
InnoDB in Cloud Hosting
You will be able to make use of any open-source script-driven software application that needs InnoDB in case you’ve got a Linux cloud hosting plan with us, as the database 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 process will proceed impeccably in case this engine is needed. You can activate apps that use the MyISAM engine without encountering any problem as well and, again, the engine will be pre-selected, so you won’t have to update any setting manually at any moment. Furthermore, we will also perform daily backups of all the MySQL databases that you have in your shared hosting account, so if you delete or overwrite anything, we can swiftly restore it the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database from the Control Panel included with each of our semi-dedicated server packages and you start installing a script-driven web app either manually or using our one-click app installer tool, the database storage engine will be picked automatically based on the particular app’s prerequisites. Since InnoDB is present on the cloud website hosting platform where your new semi-dedicated server account will be created, it will be set as the default engine for any app that needs it without any manual intervention needed on your end at any moment. To avoid any chance of losing information if you update an application or if you erase a database unintentionally, we will perform a backup of all your MySQL databases every day, so if anything goes wrong, we can retrieve your content.
InnoDB in VPS Servers
All Linux VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-installed, so you’ll be able to make use of any open-source script-based app that needs the database engine without setting up anything manually. You can choose Hepsia on the VPS order form and your brand new server will be set up within the hour, so you can sign in and start setting up your web sites right away. When you set up a brand new database and begin the app activation process, our system will choose the engine for that MySQL database automatically. In this way, you can install various apps at the same time without editing anything on the server. You can set up a WordPress-driven personal blog that makes use of the default MySQL engine – MyISAM, and a Magento-based e-commerce portal that uses InnoDB, for example.
InnoDB in Dedicated Servers
All Linux dedicated servers ordered with our custom-built Hepsia hosting Control Panel include a software package that’s pre-activated and among everything else, you’ll get the InnoDB storage engine, so you will not have to activate it manually if you’d like to use open-source scripts that require it. All it takes to activate such a script is to set up a new database and to begin the installation – as soon as the installer wizard gets access to the database in question and starts inserting data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one needed by the particular script. You will also be able to install scripts that require MyISAM, the other widely used MySQL engine, so you won’t have to edit any settings on the server. This will enable you to run different scripts on a single machine and to use the latter to its fullest capacity.