What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a popular storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has many strong sides that have made it the preferred engine for many open-source script-based web apps, including Joomla™ and Magento, which have shifted over to InnoDB permanently. For example, adding large volumes of data will be faster with InnoDB, since it locks only a single database row to complete a task, not the entire table, which makes the engine excellent for scalable applications. It also supports foreign keys and database transactions – these refer to the manner in which the information is handled. To put it simply, appending new or updating existent data will either be entirely completed, or will be aborted and the operation will be rolled back if a certain issue shows up during the process, which is why the content that remains in the database won’t be lost.
InnoDB in Cloud Hosting
You will be able to make use of any PHP-driven software application that requires InnoDB if you’ve got a cloud hosting
with our company, as the MySQL database storage engine is present on our leading-edge cloud platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is required. You can install applications which use the MyISAM engine without any problem as well and, again, the engine will be pre-selected, so you will not have to modify any setting manually at any time. On top of that, we’ll also make daily backups of all the MySQL databases that you have in your shared web hosting account, so in case you erase or overwrite something, we can swiftly get it back to the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
You can install a PHP script-powered web app that requires InnoDB with all of our semi-dedicated server
packages, since all the accounts are created on our cutting-edge cloud web hosting platform where the database engine is installed. A new database can be set up in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you use our single-click application installer. Either way, the needed engine will be selected automatically once the application’s installation begins, so you won’t have to update anything manually, no matter if the application needs InnoDB or the more commonly used MyISAM. Also, we will always be able to retrieve any of your databases if you erase one by accident, as we create several database backups every day, each of which is preserved for 1 whole week.
InnoDB in Dedicated Servers
All dedicated servers
that are ordered with our custom Hepsia hosting Control Panel come with a software package that’s pre-activated and besides everything else, you will get the InnoDB storage engine, so you won’t have to activate it manually if you wish to run open-source scripts that need it. All it takes to install such a script is to set up a new MySQL database and to start the installation process – as soon as the installation wizard acquires access to the database and begins entering data into it, InnoDB will be set as the default engine for this database as long as it is the one needed by the script. You will also be able to use scripts that need the other very popular MySQL engine, MyISAM, so you won’t have to update any settings on the server. This will enable you to run a variety of scripts on one single machine and to use it to its full capacity.