InnoDB is a MySQL database storage engine, which has been gaining popularity lately, as it offers a better overall performance and an improved database crash recovery in comparison to the default engine used by the MySQL DBMS – MyISAM. InnoDB is used by many programmers that run highly scalable web applications, due to the fact that it works much better with immense data volumes, while it keeps the server load at a minimum. Furthermore, it it locks only one row in the database in case anything should be modified, whereas many other engines lock the entire table and hence need much more time to execute several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification cannot be completed for some reason, the operation is rolled back to avoid confusion or losing data. Magento and the latest versions of Joomla are two instances of famous PHP script-driven software platforms which have shifted over to InnoDB.
InnoDB in Shared Hosting
While InnoDB is either not available or a paid upgrade with many hosting companies, it is an essential part of the standard set of services that we are offering with our shared hosting packages. If you want to use a script-powered web app that needs InnoDB in particular, in order to be installed and to operate correctly, you will not have to deal with any impediments since the MySQL storage engine is available on our custom-developed cloud platform. No matter if you create a new database and activate an app manually or use our 1-click app installer instrument, InnoDB will be selected automatically by our platform as the default engine if the app needs it instead of MyISAM. Besides the incredible crash recovery that InnoDB offers, we also perform daily database backups, so we can swiftly recover any MySQL database in your shared hosting account.
InnoDB in Semi-dedicated Servers
InnoDB comes with all our semi-dedicated service by default, so once you purchase a new account, you can go on and install any PHP script-based app that requires the MySQL database storage engine. A number of engines are installed on our cloud website hosting platform, so when you create a new database and begin installing an app manually, or opt to take advantage of the Hepsia Control Panel-integrated application installer tool, the engine for the database will be chosen based on the concrete app’s requirements. This will allow you to install and manage InnoDB-specific applications without any problems and without the need to change any settings in your account. To avoid any risk, we will always keep a seven-day-old backup of all your databases, so if you delete or change any content accidentally, we can swiftly retrieve it.
InnoDB in VPS Servers
All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you’ll be able to take advantage of any PHP-powered software application that requires the MySQL storage engine without setting up anything manually. You can pick Hepsia on the VPS order page and your brand-new Virtual Private Server will be set up within one hour, so you can log in and begin creating your web sites straight away. Once you set up a brand-new database and start the app installation process, our system will pick the engine for that database automatically. Thus, you can use different applications at the same time without modifying anything on the Virtual Private Server. You can have a WordPress-based weblog that uses the default MySQL engine – MyISAM, and a Magento-powered online shop that uses InnoDB, for example.
InnoDB in Dedicated Servers
InnoDB comes as standard with all dedicated service that are ordered with the Hepsia Control Panel. It is an integral part of the standard software package that will be pre-installed on all Hepsia-managed dedicated servers, so once your physical machine is up and running, you will be able to sign in and to activate any kind of open-source script-based application that requires this MySQL storage engine. If you set up a new MySQL database through the hosting Control Panel, there won’t be any activated engine until you start installing an app. Once the app installation wizard starts entering data into the newly created database, the engine will be chosen automatically on the basis of the prerequisites of the application in question, so you can run both InnoDB and MyISAM without selecting either of them explicitly at any moment. Therefore, you can use a vast variety of apps for your Internet sites.