InnoDB is a very popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has got many upsides that have made it the engine of choice for numerous open-source script-powered web applications, including Magento and Joomla, which have switched to InnoDB permanently. For instance, importing large volumes of data will be much faster with InnoDB, due to the fact that it locks only a single database row to perform a given operation, 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. Put simply, adding new or updating existent data will either be fully completed, or will be annulled and the procedure will be rolled back if a certain problem occurs during the process, which means that the content that remains in the database won’t be lost.
InnoDB in Shared Hosting
You will be able to activate any PHP-driven app that requires InnoDB in case you’ve got a shared hosting with our company, as the MySQL storage engine is present on our leading-edge cloud web hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue flawlessly in case this engine is required. You can install applications which use the MyISAM engine without encountering any problem as well and, again, the engine will be pre-selected, so you won’t need to modify anything manually at any time. On top of that, we will also perform regular backups of all the MySQL databases that you have in your shared hosting account, so in case 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
All our semi-dedicated servers include InnoDB and you’ll be able to take full advantage of all the features of this MySQL database engine with any script-driven software app that needs it. InnoDB is one of the engines that we have on our cloud platform, so the one that will be picked depends on the prerequisites of the particular application. You will not need to do anything manually to activate InnoDB, because it will be set as the default engine when you install an application – whether manually or using our one-click app installer. To avoid any risk, we will perform regular backups of all your MySQL databases, so if anything goes wrong after some update or if you remove some data by accident, we’ll be able to get the database back to the way it was on any of the previous seven days.
InnoDB in VPS Servers
All VPS servers that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you’ll be able to take advantage of any PHP script-powered web app that requires this particular database engine without activating anything manually. You can choose Hepsia on the VPS configuration page and your new Virtual Private Server will be up and running within the hour, so you can log in and begin building your websites right away. When you set up a new database and start the app installation process, our system will pick the engine for this database automatically. Thus, you can make use of various applications simultaneously without having to update anything on the VPS server. You can set up a WordPress-powered personal blog that makes use of the default MySQL engine – MyISAM, and a Magento web shop that uses the InnoDB engine, for example.
InnoDB in Dedicated Servers
If you order a new dedicated server, you will be able to select any of the 3 hosting Control Panels offered by us – DirectAdmin, Hepsia and cPanel. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-installed, so you won’t have to install this storage engine manually to be able to run PHP script-driven web apps that need it. InnoDB is used by scalable apps and since a dedicated server will supply you with all the resources that you need in order to manage very large sites, it’s pretty possible that you’ll resort to InnoDB. You will be able to make use of other engines as well, so if a certain application requires MyISAM rather than InnoDB, you will not have to deal with any complication while using it. The engine that will be used will be detected automatically once the app installation begins, so you won’t have to update any settings manually at any point.