What?s InnoDB? Why has it been picked up as the default MySQL storage engine?
InnoDB is a popular database engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has lots of pluses that make it the preferred engine for numerous open-source script-driven software applications, including Magento and Joomla™, which have switched to InnoDB for good. For instance, adding immense amounts of data will be much faster with InnoDB, due to the fact that it locks only one database row to carry out a specific operation, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is treated. In simpler words, importing new or updating existing data will either be fully completed, or will be canceled and the procedure will be rolled back in case any problem occurs in the meantime, which means that the content that remains in the database will not be damaged.
InnoDB in Shared Website Hosting
Every script-powered app that needs InnoDB will function flawlessly on our leading-edge cloud web hosting platform and the storage engine is available with all our shared website hosting
plans. Each time you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will make use of will be selected based on the app’s specifications without the need to configure any setting in your web hosting account. InnoDB will be picked automatically for any app that requires this particular engine and you will be able to take advantage of its full potential. We will keep daily content backups, so in case you accidentally delete a database that you need or you overwrite a specific part of it, we’ll be able to restore everything the way it was just several hours earlier.
InnoDB in Semi-dedicated Servers
You can install a script-powered application that requires InnoDB with all of our semi-dedicated server
plans, since all the accounts are set up on our innovative cloud platform where the storage engine is installed. A new MySQL database can be set up in two separate ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you make use of our one-click app installer. In either case, the needed engine will be selected automatically once the activation of the app begins, so you won’t need to configure anything manually, regardless of whether the app needs InnoDB or the more regularly used MyISAM. Also, we will always be able to restore any of your databases if you delete one by mistake, as we perform several database backups every day, each of which is preserved for 1 whole week.
InnoDB in VPS Servers
If you select a VPS server
with our Hepsia Control Panel, the InnoDB storage engine will be an indivisible part of the software pack that will be installed on your Virtual Private Server before we give it to you. You won’t have to configure anything manually and you’ll be able to enable and run any open-source script-powered web app that needs InnoDB once your Virtual Private Server is up and running, which takes no more than one hour after the order submission procedure itself. Several engines are available, so whenever you create a MySQL database using the Hepsia Control Panel, a specific engine will be picked when the app activation process commences and our system will automatically detect which engine is required by the app in question. If you have to use MyISAM, for instance, you will not need to do anything different than installing the application of your preference, whether manually or using our app installer tool.
InnoDB in Dedicated Servers
All dedicated web hosting plans
that are ordered with our in-house built Hepsia Control Panel include a software package that’s pre-installed and besides everything else, you will get the InnoDB database storage engine, so you won’t have to install it manually in case you’d like to activate scripts that require it. All it takes to use such a script is to set up a new database and to initiate the setup process – as soon as the script configuration wizard gains access to the database and starts inserting content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the particular script. You’ll also be able to install scripts that require the other widely used MySQL engine, MyISAM, so you won’t need to edit any settings on the dedicated server. This will permit you to use various scripts on one single physical machine and to use it to its maximum capacity.