InnoDB is a very popular database engine for the MySQL relational database management system. It’s an alternative to the default engine – MyISAM, and it has got numerous upsides which make it the engine of choice for lots of PHP-based software applications, among them Magento and Joomla, which have switched to InnoDB permanently. For instance, importing large volumes of data will be much faster with InnoDB, because it locks only one database row to execute a given task, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the data is handled. To put it simply, adding new or modifying existing data will either be thoroughly completed, or will be annulled and the operation will be rolled back in case any problem shows up in the meantime, therefore the content that remains in the database will not be lost.
InnoDB in Shared Hosting
Any PHP-based web app that requires InnoDB will run flawlessly on our advanced cloud hosting platform and the MySQL database storage engine comes with all our shared hosting packages. Each time you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will make use of will be selected in accordance with the app’s prerequisites without the need to update any setting in your account. InnoDB will be picked automatically for any app that requires this specific engine and you will be able to make the most of its full potential. We will perform regular backups of your content, so if you unintentionally erase a database that’s important to you or you overwrite specific parts of it, we will be able to restore the database the way it was only several hours ago.
InnoDB in Semi-dedicated Hosting
All our semi-dedicated packages support InnoDB and you can get the most out of all the options offered by this MySQL storage engine with any PHP-powered application that requires it. InnoDB is one of the engines that are available on our cloud hosting platform, so the one that will be picked depends on the requirements of the application in question. You will not need to do anything manually in order to enable InnoDB, as it will be set as the default engine whenever you install an app – whether manually or using our single-click application installer. To avoid any risk, we will store daily backups of all your databases, so if something goes wrong following an upgrade or if you erase some content by mistake, we will be able to get the database back to the way it was on any of the previous 7 days.
InnoDB in VPS
If our in-house developed Hepsia Control Panel is selected during the signup process for your new Linux VPS packages , InnoDB will be activated on the Virtual Private Server along with other necessary pieces of software, so you will not need to do anything if you decide to manage PHP-driven applications that need this MySQL storage engine. The default MySQL engine, MyISAM, will be activated as well. You can set up a new database and start the app installation process manually or using our 1-click installation tool. The system will detect the engine that the application in question requires and will set it for the specific database, so the installation process will continue flawlessly and the application can dump its content in that database. Therefore, you can manage applications with various requirements in regard to the MySQL engine without the need to make any modifications on your server.
InnoDB in Dedicated Hosting
All dedicated servers hosting packages ordered with our custom-built Hepsia hosting Control Panel include a software bundle that is pre-activated and besides everything else, you will get the InnoDB database engine, so you won’t need to install it manually if you’d like to activate scripts that require it. All it takes to install such a script is to set up a new MySQL database and to begin the setup – as soon as the script configuration wizard receives access to the database and begins entering content into it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You will also be able to activate scripts that need MyISAM – the other very popular MySQL engine, so you will not have to update any settings on the dedicated server. This will permit you to run various scripts on one single machine and to use it to its fullest potential.