InnoDB is a MySQL storage engine, which has been gaining popularity lately, because it offers a much better overall performance and an improved crash recovery in comparison with the default engine that is used by the MySQL DBMS – MyISAM. InnoDB is endorsed by many web developers that create scalable applications, because it works more efficiently with huge data volumes, while it keeps the server processing load low. Moreover, it it locks only one row in the database in case any info should be modified, whereas lots of other engines lock the entire table and hence need more time to complete several sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – if the modification of the entire data cannot be completed successfully for whatever reason, the operation is rolled back to prevent scrambling or the loss of data. Magento and the newest Joomla editions are two examples of widespread script-driven web applications which have switched over to InnoDB.
InnoDB in Cloud Hosting
Every script-powered software application that needs InnoDB will function flawlessly on our avant-garde cloud web hosting platform and the MySQL storage engine comes with all our cloud hosting plans. Each time you create a database manually or our app installer tool creates one automatically and an app installation process is initiated, the engine that the database will use will be selected based on the app’s prerequisites without the need to update any setting in your shared web hosting account. InnoDB will be picked automatically for any application that requires this particular engine and you will be able to take advantage of its full capacity. We will keep daily backups of your content, so in case you accidentally remove a MySQL database that you need or you overwrite a specific part of it, we’ll be able to restore your content the way it was just a few hours ago.
InnoDB in Semi-dedicated Hosting
You can install a script-powered web app that needs InnoDB with any of our semi-dedicated server plans, due to the fact that all the accounts are created on our cutting-edge cloud platform where the database engine is installed. A new MySQL database can be set up in two separate ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you make use of our one-click app installer tool. In either case, the required engine will be picked automatically the moment the installation of the app starts, so you won’t have to change anything manually, regardless 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 if you unintentionally remove one, as we generate a few database backups every day, each of which is stored for one whole week.
InnoDB in VPS Hosting
If our custom Hepsia Control Panel is chosen during the registration process for a new Linux VPS hosting packages , InnoDB will be installed on the Virtual Private Server together with other needed pieces of software, so you won’t need to do anything if you decide to activate PHP-based web apps that need this MySQL database engine. The default MySQL engine, MyISAM, will be installed as well. You can set up a brand new database and start installing the application manually or using our one-click installer tool. The system will detect which engine the app in question needs and will set it for the specific MySQL database, so the installation process will continue impeccably and the app can insert its data into that database. In this way, you can activate apps with different prerequisites regarding the MySQL engine without the need to make any changes on your VPS server.
InnoDB in Dedicated Web Hosting
InnoDB comes as standard with all Linux dedicated servers hosting packages ordered with the Hepsia Control Panel. It is included in the software bundle that will be installed on all Hepsia-equipped servers, so once your physical machine is ready, you’ll be able to sign in and to install any type of open-source script-based software app that requires this particular MySQL database engine. If you create a new MySQL database through the Control Panel, there won’t be any activated engine till you begin installing an app. Once the app installation wizard starts inserting content into the database, the engine will be set automatically based on the given app’s prerequisites, so you can run both MyISAM and InnoDB without the need to select either one specifically at any point. Therefore, you can make use of an immense range of apps for your sites.