InnoDB is a MySQL database engine, which has been gaining in popularity in recent years, as it offers a much better overall performance and a faster database crash recovery compared with the default engine that is used by MySQL – MyISAM. InnoDB is endorsed by numerous programmers that build highly scalable applications, since it works much better with immense data volumes, while it keeps the server processing load low. What’s more, it locks only one database row in case any info should be modified, while lots of other engines lock the entire table and therefore require much more time to handle several sequential tasks. Last, but not least, InnoDB follows the "all-or-nothing" rule – if the entire data modification process cannot be completed for some reason, the action is rolled back to prevent scrambling or the loss of data. Magento and the latest Joomla™ editions are two instances of widely used open-source script-powered software applications that have switched to InnoDB.
InnoDB in Cloud Website Hosting
InnoDB is offered with all our cloud website hosting packages by default, not as a paid upgrade or upon request, so you will be able to install and manage any script-powered web app which requires the database storage engine without having any problem once you activate your shared hosting account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation, regardless of whether you use our single-click installer or create the MySQL database and set up the app manually, as long as the application requires InnoDB instead of the more popular MyISAM engine. We’ll create regular database backups, so you can rest assured that you won’t ever lose any data in case you erase a database accidentally or you overwrite some important info – you just need to alert us and we will restore everything the way it was.
InnoDB in Semi-dedicated Hosting
If you set up a brand new MySQL database from the Control Panel included with each of our semi-dedicated server plans and you start installing an open-source script-powered web app either manually or using our one-click application installer tool, the storage engine for the MySQL database will be set automatically on the basis of the requirements of the particular app. Since InnoDB is available on the cloud website hosting platform where your new account will be created, it will be set as the default engine for any app that needs it without any manual action required on your end at any point. To avoid any risk of losing information if you update an app or if you delete a database by mistake, we’ll perform a backup of all your databases each and every day, so if anything goes wrong, we can rescue your data.
InnoDB in VPS
In case our custom Hepsia Control Panel is selected during the registration process for your new Linux VPS packages , InnoDB will be installed on the VPS server together with other essential pieces of software, so you will not have to do anything if you choose to install PHP-based applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed as well. You can create a new database and begin the app installation manually or through our one-click installation tool. The system will automatically detect which engine the app in question requires and will set it for the specific database, so the installation process will continue impeccably and the app can import its data into that database. Thus, you can run applications with various prerequisites in regard to the MySQL engine without the need to make any changes on your server.
InnoDB in Dedicated Hosting
All dedicated hosting that are ordered with our custom Hepsia Control Panel come with a software package that’s pre-activated and among everything else, you will get the InnoDB database engine, so you will not have to activate it manually if you wish to use open-source scripts that need it. All it takes to use such a script is to set up a new database and to start the setup – as soon as the script setup wizard acquires access to the database in question and starts dumping data in it, InnoDB will be set as the default MySQL engine for this database as long as it is the one needed by the particular script. You will also be able to install scripts that need MyISAM – the other popular MySQL engine, so you won’t need to edit any settings on the dedicated server. This will allow you to activate different scripts on a single physical server and to use the latter to its full capabilities.