Find out about InnoDB and find out why it’s been selected as the default MySQL database engine.
InnoDB is a very popular database storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got lots of upsides that have made it the engine of choice for many PHP-based web apps, including Magento and Joomla™, which have moved to InnoDB for good. For instance, importing large data volumes will be much faster with InnoDB, since it locks only a single row to execute an 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 information is handled. Simply put, adding new or updating existing data will either be fully completed, or will be aborted and the operation will be rolled back in case a certain issue occurs during the process, which is why the content that remains in the database will not be damaged.
InnoDB in Cloud Website Hosting
Every script-based application that needs InnoDB will function impeccably on our advanced cloud hosting platform and the storage engine is available with all our cloud website hosting
packages. Each time you create a MySQL database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database will make use of will be selected based on the app’s specifications without having to modify any setting in your account. InnoDB will be chosen automatically for any application that requires this specific engine and you’ll be able to get the most out of its full capacity. We will generate daily backups of your content, so in case you accidentally delete a database that’s important to you or you overwrite some part of it, we will be able to restore your content the way it was just a couple of hours earlier.
InnoDB in Semi-dedicated Hosting
You can make use of an open-source script-powered software app that requires InnoDB with any of our semi-dedicated server
packages, as all the accounts are created on our avant-garde cloud platform where the database storage engine is installed. A new MySQL database can be created in two separate ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our one-click app installer tool. Either way, the required engine will be selected automatically once the app’s installation starts, so you will not have to change anything manually, irrespective of whether the app requires InnoDB or the more commonly used MyISAM. On top of that, we will always be able to restore any of your databases in case you remove one by accident, as we generate a few MySQL database backups every day, each of which is kept for 1 week.
InnoDB in VPS Web Hosting
All VPS web hosting services
that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you’ll be able to take advantage of any PHP script-powered application that requires this MySQL database storage engine without the need to configure anything manually. You can choose Hepsia on the VPS order page and your brand-new VPS server will be ready within 1 hour, so you can sign in and start setting up your Internet sites straight away. Once you set up a brand-new database and begin the app activation process, our system will set the engine for this database automatically. Thus, you can manage various apps simultaneously without updating anything on the VPS server. You can have a WordPress-driven personal journal that makes use of the default MySQL engine – MyISAM, and a Magento-based e-commerce portal that makes use of the InnoDB engine, for instance.
InnoDB in Dedicated Servers Hosting
If you purchase a new dedicated server
, you will be able to choose any of the three hosting Control Panels that we’re offering – Hepsia, DirectAdmin and cPanel. Any server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to add this MySQL database storage engine manually to be able to manage PHP-powered software applications that require it. InnoDB is used for scalable apps and since a dedicated server will provide you with all the system resources that you need to manage large-scale websites, it’s very possible that you will resort to InnoDB. You will be able to use other engines as well, so in case a particular application requires MyISAM rather than InnoDB, you will not run into any problem while using it. The engine that will be used will be recognized automatically the moment the app installation procedure starts, so you won’t have to update any settings manually whatsoever.