What?s InnoDB? Why has it been selected as the standard MySQL storage engine?
InnoDB is a popular database storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got plenty of advantages which make it the engine of choice for lots of PHP script-driven web apps, including Joomla™ and Magento, which have moved to InnoDB permanently. For instance, importing enormous data volumes will be much faster with InnoDB, since it locks only a single database row to carry out a particular operation, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the info is handled. Put simply, importing new or modifying existent data will either be thoroughly completed, or will be annulled and the operation will be rolled back if a given issue appears in the meantime, therefore the content that remains in the database will not be damaged.
InnoDB in Hosting
You’ll be able to make use of any open-source script-powered web application that requires InnoDB in case you have a hosting
with our company, as the MySQL database engine is available on our leading-edge cloud hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed flawlessly in case this engine is needed. You can install applications which use the MyISAM engine without having any difficulty as well and, again, the engine will be selected automatically, so you will not need to change anything manually at any point. Furthermore, we’ll also generate regular backups of all the databases that you’ve got in your shared hosting account, so if you erase or overwrite something, we can easily get it back to the way it was on any of the past seven days.
InnoDB in Semi-dedicated Servers
InnoDB is included with all our semi-dedicated servers
by default, so once you obtain a new account, you can go ahead and activate any PHP-based app that needs the MySQL database engine. A couple of engines are pre-installed on our cloud platform, so when you set up a new database and start installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be set based on the requirements of the respective app. This will permit you to activate and manage InnoDB-specific applications without needing to cope with any difficulty and without changing any settings in your semi-dedicated account. To be on the safe side, we will always have a seven-day-old backup of all your databases, so if you erase or alter any content unintentionally, we can quickly retrieve it.
InnoDB in VPS Servers
In case our custom-built Hepsia Control Panel is picked during the signup process for your new VPS servers
, InnoDB will be installed on the VPS server along with other essential software, so you won’t have to do anything if you decide to make use of open-source script-driven apps that require this MySQL database storage engine. The default MySQL engine, MyISAM, will be installed as well. You can set up a new database and start the app installation manually or using our single-click installer tool. The system will automatically recognize the engine that the application in question needs and will assign it to the specific MySQL database, so the installation process will proceed impeccably and the application can dump its content in that database. Thus, you can manage applications with different requirements regarding the MySQL engine without having to make any modifications on your VPS.
InnoDB in Dedicated Servers
All dedicated servers
ordered with our custom Hepsia Control Panel come with a software bundle that is pre-installed and besides everything else, you will get the InnoDB database storage engine, so you will not need to add it manually in case you want to use open-source PHP scripts that need it. All it takes to activate such a script is to set up a new MySQL database and to begin the setup process – once the installer wizard gets access to the database in question and begins importing data into it, InnoDB will be set as the default MySQL engine for this database provided that it is the one required by the script. You will also be able to run scripts that need the other popular MySQL engine, MyISAM, so you will not need to edit any settings on the dedicated server. This will permit you to run various scripts on one single physical machine and to use it to its full capabilities.