InnoDB
Discover what a database engine is, what are the pros of the InnoDB engine and why it is gaining a huge amount of worldwide popularity.
InnoDB is a very popular storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has got a number of advantages that have made it the preferred engine for many open-source script-driven web applications, such as Magento and Joomla™, which have moved to InnoDB for good. For example, importing large amounts of data will be much faster with InnoDB, since it locks only one database row to carry out a certain operation, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the information is tackled. Put simply, appending new or editing existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case some problem appears during the process, so the content that remains in the database won’t be damaged.
-
InnoDB in Cloud Hosting
You will be able to make use of any PHP-driven app that requires InnoDB in case you’ve got a
Linux cloud hosting package with us, as the MySQL database storage engine is present on our advanced cloud web hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is required. You can run apps which need the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be selected automatically, so you won’t have to change any setting manually at any point. In addition, we’ll also carry out daily backups of all the databases that you’ve got in your account, so if you erase or overwrite anything, we can quickly restore it the way it was on any of the past seven days.
-
InnoDB in Semi-dedicated Hosting
You can activate a script-powered software app that requires InnoDB with any of our
semi-dedicated server packages, as all the accounts are set up on our cutting-edge cloud hosting platform where the MySQL database engine is installed. A new database can be created in two separate ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – if you use our one-click app installer. Either way, the required engine will be chosen automatically the moment the application’s installation starts, so you will not have to configure anything manually, regardless of whether the app requires InnoDB or the more regularly used MyISAM. In addition, we will always be able to restore any of your MySQL databases if you unintentionally delete one, as we generate several backups every day, each of which is kept for one week.
-
InnoDB in VPS Web Hosting
If our in-house built Hepsia hosting Control Panel is picked during the signup process for a new
Linux VPS web hosting packages , InnoDB will be installed on the server together with other needed pieces of software, so you will not have to do anything if you decide to use PHP-powered software apps that require this MySQL database storage engine. MyISAM – the default MySQL engine, will be installed too. You can create a brand new MySQL database and begin the app installation process manually or through our single-click installation tool. The system will automatically detect the engine that the app in question requires and will assign it to the specific MySQL database, so the installation process will continue impeccably and the application can enter its data into that database. Thus, you can manage apps with various prerequisites concerning the MySQL engine without the need to make any modifications on your VPS.
-
InnoDB in Dedicated Servers Hosting
All
Linux dedicated servers hosting packages ordered with our in-house built Hepsia Control Panel include a software bundle that’s pre-installed and among everything else, you’ll get the InnoDB database storage engine, so you won’t need to install it manually if you would like to run open-source scripts that require it. All it takes to install such a script is to create a new MySQL database and to begin the installation process – once the script setup wizard obtains access to the database in question and starts entering content into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You will also be able to install scripts that require the other very popular MySQL engine – MyISAM, so you will not have to edit any settings on the server. This will allow you to install different scripts on a single machine and to use it to its maximum capabilities.