What?s InnoDB? Why has it been selected as the default MySQL storage engine?
InnoDB is a very popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has numerous advantages which make it the engine of choice for plenty of open-source script-powered software applications, such as Magento and Joomla™, which have switched to InnoDB permanently. For instance, importing enormous data volumes will be much faster with InnoDB, since it locks only a single row to execute a certain task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the information is tackled. Simply put, importing new or editing existent data will either be entirely completed, or will be aborted and the operation will be rolled back in case a certain problem appears in the meantime, so the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
While InnoDB is either not offered or it is a paid upgrade with other web hosts, it’s included in the standard set of services offered with our shared hosting
plans. In case you wish to use a PHP script-driven software application that requires InnoDB in particular, in order to be installed and to operate properly, you will not need to deal with any obstacles as the InnoDB database engine is available on our in-house developed cloud hosting platform. Regardless of whether you set up a new MySQL database and install an application manually or take advantage of our one-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the respective app needs it rather than MyISAM. Besides the remarkable database crash recovery offered by InnoDB, we also generate regular backups of all databases, so we can easily restore any database in your shared website hosting account.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting
support InnoDB and you’ll be able to take full advantage of all the features of this database engine with any open-source script-powered web app that needs it. InnoDB is among 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 won’t need to do anything manually to activate InnoDB, since it will be set as the default engine whenever you install an app – whether manually or using our 1-click app installer tool. To be on the safe side, we will make daily backups of all your MySQL databases, so if something goes wrong after an update or if you delete some content by mistake, we will be able to get the database back to the way it was on any of the past 7 days.
InnoDB in VPS Hosting
All Linux VPS hosting
that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to run any script-based software application that requires this particular database engine without the need to activate anything manually. You can choose Hepsia on the VPS configuration page and your new VPS server will be ready within the hour, so you can sign in and begin building your sites right away. Once you set up a brand-new MySQL database and begin the app activation process, our system will pick the engine for that MySQL database automatically. Thus, you can run different apps at the same time without the need to update anything on the VPS server. You can have a WordPress-powered personal weblog that makes use of MyISAM – the default MySQL engine, and a Magento-driven online store that makes use of the InnoDB engine, for instance.
InnoDB in Dedicated Web Hosting
If you purchase a new dedicated server
, you will be able to select any of the three Control Panels that we are offering – cPanel, DirectAdmin and Hepsia. Any dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not have to enable this MySQL database engine manually in order to be able to run open-source script-based software applications that need it. InnoDB is used by scalable applications and since a dedicated server will provide you with all the server resources that you need to manage very large websites, it’s quite possible that you’ll use InnoDB. You’ll be able to use other engines as well, so in case a certain app needs MyISAM rather than InnoDB, you won’t encounter any complication while using it. The engine that will be used will be recognized automatically as soon as the app installation process commences, so you will not need to tweak any setting manually at any time.