InnoDB is a popular storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got plenty of pluses which make it the preferred engine for many PHP script-based applications, among them Joomla and Magento, which have moved to InnoDB permanently. For instance, adding huge volumes of data will be faster with InnoDB, because it locks only a single database row to complete a certain task, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the data is handled. Simply put, appending new or editing existent data will either be fully completed, or will be aborted and the procedure will be rolled back in case a given issue shows up during the process, which means that the content that remains in the database will not be lost.
InnoDB in Cloud Hosting
You can run any script-based software application that needs InnoDB in case you have a Linux cloud plan with us, as the MySQL storage engine is available on our advanced cloud website hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is required. You can activate apps which need the MyISAM engine without any obstacles as well and, once again, the engine will be pre-selected, so you won’t need to change anything manually at any moment. On top of that, we’ll also perform regular backups of all the databases that you have in the shared web hosting account, so if you delete or overwrite anything, we can easily restore it the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
If you set up a new MySQL database from the Control Panel included with all our semi-dedicated server accounts and you start installing a PHP-powered software app either manually or using our one-click app installer tool, the MySQL database storage engine will be picked automatically depending on the prerequisites of the given application. As InnoDB is present on the cloud hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for each app that needs it without any manual action needed on your end at any moment. To prevent any risk of losing info if you update an application or if you delete a database accidentally, we will perform a backup of all your MySQL databases every day, so if something happens, we can recover your content.
InnoDB in VPS Servers
If our custom Hepsia hosting Control Panel is chosen during the registration process for a new VPS web hosting plans , InnoDB will be activated on the server together with other needed pieces of software, so you will not have to do anything if you choose to make use of PHP script-driven web applications that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed too. You can set up a brand new MySQL database and start installing the application manually or through our single-click installation tool. The system will recognize which engine the application in question requires and will set it for the specific MySQL database, so the installation process will continue flawlessly and the application can dump its data in that database. Thus, you can run applications with various prerequisites about the MySQL engine without having to make any modifications on your VPS server.
InnoDB in Dedicated Servers
All dedicated servers that are ordered with our custom-built Hepsia Control Panel come with a software package that is pre-activated and among everything else, you’ll get the InnoDB database storage engine, so you won’t have to install it manually if you wish to run scripts that need it. All it takes to install such a script is to set up a new MySQL database and to begin the setup process – once the script setup wizard accesses the database in question and starts importing data into it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You’ll also be able to activate scripts that require MyISAM, the other widely used MySQL engine, so you will not have to edit any settings on the server. This will permit you to install different scripts on a single physical server and to use it to its full capabilities.