InnoDB is a MySQL storage engine, which has been gaining in popularity in recent years, as it offers a significantly better overall performance and a faster crash recovery in comparison to the default engine that is used by the MySQL database management system – MyISAM. InnoDB is used by many developers that run highly scalable web apps, because it works much better with enormous amounts of data, while it keeps the server load at a minimum. Furthermore, it locks only one database row in case anything should be edited, whereas lots of other engines lock the entire table and thus require more time to accomplish multiple consecutive tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the entire data modification process cannot be completed for whatever reason, the operation is rolled back to avoid confusion or the loss of data. Magento and the latest releases of Joomla are two instances of famous PHP-based applications which have switched to InnoDB.
InnoDB in Shared Web Hosting
You’ll be able to use any script-based web app that needs InnoDB in case you have a shared web hosting plan with our company, as the MySQL database storage engine is present on our cutting-edge cloud web hosting platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup process will proceed impeccably in case this engine is required. You can install apps which require the MyISAM engine without having to deal with any problem as well and, once again, the engine will be pre-selected, so you will not need to update any setting manually at any time. In addition, we will also carry out daily backups of all the databases that you have in your shared web hosting account, so in case you delete or overwrite something, we can easily restore it the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Servers
You can run an open-source script-powered software application that requires InnoDB with all of our semi-dedicated server packages, as all the accounts are set up on our innovative cloud platform where the MySQL database engine is installed. A new MySQL database can be created in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – if you use our 1-click application installer tool. In either case, the needed engine will be selected automatically the moment the installation of the app begins, so you will not have to change anything manually, no matter if the app requires InnoDB or the more widely used MyISAM. Also, we’ll always be able to retrieve any of your MySQL databases if you accidentally erase one, as we make a couple of database backups every day, each of which is stored for one whole week.
InnoDB in VPS Servers
If you buy a VPS server from our company, you will be able to make use of our custom-developed Hepsia hosting Control Panel to manage your content. A Hepsia-equipped Virtual Private Server will allow you to use any script-based web app which requires InnoDB, as this particular storage engine is included in the software bundle that will be installed on your VPS server during its creation. When you set up a new MySQL database through the Control Panel, you’ll just need to start installing an app – manually or using our application installer tool. InnoDB will be set as the default engine given that the app in question needs it, so you won’t have to do anything else in your VPS account. Identically, if an app requires MyISAM, it will be automatically set as the default engine for this specific MySQL database.
InnoDB in Dedicated Servers
InnoDB comes as standard with all dedicated servers ordered with the Hepsia hosting Control Panel. It’s included in the default software package that will be pre-installed on all Hepsia-equipped dedicated servers, so as soon as your machine is assembled, you will be able to log in and to install any PHP-powered app that requires this storage engine. If you create a new MySQL database through the hosting Control Panel, there won’t be any active engine till you begin installing an application. Once the app setup wizard begins inserting content into the newly created database, the engine will be set automatically on the basis of the requirements of the particular app, so you can run both MyISAM and InnoDB without the need to select either one of them explicitly at any point. Thus, you can use a wide selection of apps for your sites.