InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, because it provides a significantly better overall performance and a faster database failure recovery compared with the default engine that’s used by the MySQL DBMS – MyISAM. InnoDB is used by plenty of devs that run scalable software applications, since it works more efficiently with immense volumes of data, while it keeps the server load low. Additionally, it locks only a single database row in case anything should be updated, while many other engines lock the entire table and hence need much more time to process several consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – in case the entire data modification cannot be completed for any reason, the operation is rolled back to avoid scrambling or data loss. Magento and the newest editions of Joomla are two instances of famous script-based software platforms which have switched to InnoDB.
InnoDB in Website Hosting
While InnoDB is either not available or a paid upgrade with other hosting companies, it’s an integral part of the standard set of services that we are offering with our website hosting packages. In case you’d like to use a script-based web application that requires InnoDB particularly, in order to be activated and to work correctly, you will not face any impediments as the InnoDB database engine is available on our in-house built cloud hosting platform. No matter if you create a brand-new MySQL database and install an application manually or take advantage of our single-click app installer software tool, InnoDB will be selected automatically by our system as the default engine if the app requires InnoDB rather than MyISAM. Besides the incredible crash recovery that InnoDB is offering, we also store regular database backups, so that we can quickly restore any MySQL database in your shared web hosting account.
InnoDB in Semi-dedicated Servers
You can make use of an open-source script-powered software app that needs InnoDB with any of our semi-dedicated server plans, as all the accounts are created on our avant-garde cloud platform where the MySQL storage engine is installed. A new database can be set up in two ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you take advantage of our one-click application installer. Either way, the needed engine will be selected automatically once the activation of the app starts, so you will not have to edit anything manually, irrespective of whether the application needs InnoDB or the more widely used MyISAM. In addition, we will always be able to retrieve any of your databases in case you unintentionally erase one, as we carry out a couple of MySQL database backups every day, each of which is saved for 7 days.
InnoDB in VPS Servers
All VPS web hosting plans that are ordered with the Hepsia Control Panel come with InnoDB already installed, so you will be able to take advantage of any PHP-powered app that needs the MySQL storage engine without activating anything manually. You can pick Hepsia on the VPS order page and your brand-new Virtual Private Server will be up and running within 1 hour, so you can log in and start building your sites straight away. Once you set up a brand new database and start the app activation process, our system will pick the engine for this MySQL database automatically. In this way, you can use various applications at the same time without having to update anything on the Virtual Private Server. You can create a WordPress-based personal weblog that makes use of MyISAM – the default MySQL engine, and a Magento-powered e-commerce site that uses InnoDB, for example.
InnoDB in Dedicated Servers
InnoDB is available as standard with all dedicated web hosting plans ordered with the Hepsia Control Panel. It’s included in the default software package that will be installed on all Hepsia-equipped servers, so once your machine is up and running, you’ll be able to sign in and to activate any type of PHP-powered application that needs this particular storage engine. When you create a new database via the hosting Control Panel, there won’t be any active engine until you begin installing an app. Once the app configuration wizard begins entering content into the database, the engine will be selected automatically in accordance with the prerequisites of the specific application, so you can run both MyISAM and InnoDB without the need to select either one of them specifically at any time. In this way, you can make use of an extensive variety of applications for your Internet sites.