InnoDB is a MySQL database engine, which has been gaining popularity in recent years, because it offers a better overall performance and an improved database failure recovery in comparison with the default engine that’s used by the MySQL RDBMS – MyISAM. InnoDB is preferred by a lot of web developers that write scalable web applications, as it works much more efficiently with huge amounts of data, while it keeps the server load at a minimum. Moreover, it locks only a single database row in case anything should be modified, while lots of other engines lock the entire database table and hence require more time to execute multiple sequential tasks. Last, but not least, InnoDB obeys a set of "all-or-nothing" rules – if the entire data modification cannot be completed successfully for whatever reason, the action is rolled back to avoid confusion or losing data. Magento and the latest Joomla editions are two examples of famous script-based software apps that have shifted over to InnoDB.
InnoDB in Shared Hosting
Every PHP-based software application that requires InnoDB will run flawlessly on our cutting-edge cloud website hosting platform and the database engine is offered with all our shared hosting packages. Whenever you create a database manually or our app installer creates one automatically and an app installation is initiated, the engine that the database in question will use will be selected in accordance with the app’s specifications without the need to update any setting in your web hosting account. InnoDB will be picked automatically for any application that requires this specific engine and you’ll be able to get the most out of its full potential. We will perform regular content backups, so if you unintentionally erase a MySQL database that you need or you overwrite a certain part of it, we’ll be able to restore everything the way it was just a couple of hours ago.
InnoDB in Semi-dedicated Hosting
You can run an open-source script-powered application that requires InnoDB with any of our semi-dedicated server packages, because all the accounts are set up on our avant-garde cloud hosting platform where the database storage engine is installed. A new MySQL database can be set up in two different ways – manually through the Database Manager section of the Hepsia web hosting Control Panel, or automatically – when you make use of our 1-click application installer tool. Either way, the required engine will be selected automatically as soon as the application’s activation starts, so you won’t have to update anything manually, irrespective of whether the app needs InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to retrieve any of your databases in case you accidentally delete one, as we make several backups every day, each of which is saved for 7 days.
InnoDB in VPS Hosting
All VPS hosting that are ordered with the Hepsia Control Panel come with InnoDB already activated, so you will be able to make use of any PHP script-powered software application that requires this particular MySQL database storage engine without the need to activate anything manually. You can choose Hepsia on the VPS configuration page and your brand-new server will be ready within 60 minutes, so you can sign in and begin building your sites straight away. Once you create a brand-new MySQL database and start the app installation process, our system will pick the engine for that MySQL database automatically. In this way, you can make use of various apps at the same time without configuring anything on the VPS server. You can create a WordPress personal weblog that uses the default MySQL engine – MyISAM, and a Magento-based e-shop that makes use of InnoDB, for example.
InnoDB in Dedicated Web Hosting
InnoDB is available by default with all Linux dedicated servers hosting packages ordered with the Hepsia Control Panel. It is an essential part of the software package that will be installed on all Hepsia-managed dedicated servers, so once your machine is up and running, you will be able to log in and to activate any open-source script-powered software app that needs this storage engine. If you create a new database through the hosting Control Panel, there won’t be any activated engine till you start installing an app. As soon as the app installation wizard starts importing content into the newly created database, the engine will be selected automatically depending on the given app’s prerequisites, so you can use both MyISAM and InnoDB without selecting either of them specifically at any moment. In this way, you can make use of an immense collection of apps for your websites.