InnoDB is a MySQL database storage engine, which has been gaining popularity in recent years, as it provides a much better overall performance and an improved database crash recovery compared with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is preferred by numerous developers that write scalable software applications, because it works more efficiently with large amounts of data, while it keeps the server processing load at a minimum. Additionally, it locks only a single database row in case any information should be updated, whereas lots of other engines lock the entire table and therefore need more time to perform multiple successive tasks. Last, but not least, InnoDB abides by 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 data loss. Magento and the newest releases of Joomla are two instances of widely used script-powered applications that have switched over to InnoDB.
InnoDB in Web Hosting
Every PHP script-driven app that needs InnoDB will run impeccably on our advanced cloud platform and the storage engine is available with all our web hosting packages. Each time you create a database manually or our app installer tool creates one automatically and an app installation process is started, the engine that the database in question will use will be selected based on the app’s requirements without the need to change any setting in your shared web hosting account. InnoDB will be chosen automatically for any app that requires this specific engine and you will be able to get the most out of its full potential. We will create regular content backups, so if you unintentionally remove a MySQL database that’s important to you or you overwrite a specific part of it, we will be able to restore the database the way it was only several hours ago.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated hosting service include InnoDB and you can get the most out of all the options offered by this database storage engine with any open-source script-powered web application that needs it. It’s among the engines that we have on our cloud web hosting platform, so the one that will be selected depends on the given app’s requirements. You won’t need to do anything manually in order to activate InnoDB, because it will be set as the default engine whenever you install an app – whether manually or using our 1-click application installer. To be on the safe side, we’ll store regular backups of all your MySQL databases, so if anything goes wrong following an upgrade or if you remove some content unintentionally, we’ll be able to restore the database the way it was on any of the previous seven days.
InnoDB in VPS Servers
All VPS hosting service that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to run any PHP script-based software app that requires this particular storage engine without the need to configure anything manually. You can select Hepsia on the VPS configuration page and your brand-new VPS server will be ready within sixty minutes, so you can sign in and begin building your web sites straight away. Once you create a new database and start the app activation process, our system will choose the engine for this MySQL database automatically. Thus, you can run various apps at the same time without the need to configure anything on the VPS server. You can set up a WordPress online journal that uses the default MySQL engine – MyISAM, and a Magento e-commerce website that makes use of InnoDB, for example.
InnoDB in Dedicated Servers
InnoDB comes as standard with all dedicated servers ordered with the Hepsia Control Panel. It’s included in the software package that will be pre-installed on all Hepsia-equipped dedicated servers, so as soon as your physical machine is up and running, you’ll be able to log in and to activate any PHP script-based application that needs this storage engine. If you create a new MySQL database via the Control Panel, there won’t be any active engine till you begin installing an application. As soon as the app installation wizard starts inserting data into the database, the engine will be chosen automatically in accordance with the requirements of the given application, so you can run both MyISAM and InnoDB without the need to select either of them specifically at any point. Thus, you can use an extensive collection of applications for your Internet sites.