InnoDB is a MySQL database engine, which has been gaining popularity lately, because it provides a much better overall performance and a faster database crash recovery compared with the default engine used by the MySQL relational database management system – MyISAM. InnoDB is used by lots of developers that create scalable software applications, due to the fact that it works much better with large volumes of data, while it keeps the server processing load low. Moreover, it locks only a single database row if any information should be edited, whereas many other engines lock the entire database table and hence need more time to perform several sequential tasks. Last, but not least, InnoDB abides by the "all-or-nothing" rule – in case the modification of the entire data cannot be completed for whatever reason, the action is rolled back to prevent confusion or losing data. Magento and the newest releases of Joomla are two instances of widespread script-based web applications that have moved to InnoDB.
InnoDB in Shared Web Hosting
Any open-source script-driven software app that requires InnoDB will run flawlessly on our cutting-edge cloud web hosting platform and the MySQL database storage engine comes with all our shared web hosting packages. Whenever you create a database manually or our app installer 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 specifications without the need to change any setting in your account. InnoDB will be selected automatically for any application that requires this specific engine and you’ll be able to take advantage of its full capacity. We will generate daily content backups, so in case you unintentionally erase a MySQL database that is important to you or you overwrite specific parts of it, we will be able to restore your content the way it was only a couple of hours ago.
InnoDB in Semi-dedicated Hosting
InnoDB is offered with all our Linux semi-dedicated hosting by default, so as soon as you order a new account, you can go ahead and install any open-source script-based software application that needs this particular database storage engine. A couple of engines are pre-installed on our cloud website hosting platform, so when you set up a brand new MySQL database and begin installing an app manually, or opt to use the Hepsia Control Panel-integrated application installer, the engine for the database will be set based on the prerequisites of the respective app. This will allow you to install and manage InnoDB-specific applications without running into any obstacle and without the need to edit any settings in your account. To be on the safe side, we’ll always keep a 1-week-old backup of all your MySQL databases, so if you erase or change any content by mistake, we can swiftly retrieve it.
InnoDB in VPS Web Hosting
All Linux VPS web hosting that are ordered with the Hepsia Control Panel come with InnoDB pre-installed, so you will be able to make use of any open-source script-based web app that needs the MySQL storage engine without activating anything manually. You can select Hepsia on the VPS order form and your new VPS server will be ready within 60 minutes, so you can sign in and begin setting up your websites right away. When you set up a brand-new MySQL database and begin the app activation process, our system will pick the engine for this database automatically. Thus, you can activate different applications at the same time without modifying anything on the VPS server. You can have a WordPress online blog that uses the default MySQL engine – MyISAM, and a Magento Internet shop that makes use of InnoDB, for instance.
InnoDB in Dedicated Servers Hosting
All Linux dedicated servers hosting that are ordered with our in-house built Hepsia hosting Control Panel include a software package that is pre-activated and besides everything else, you’ll get the InnoDB storage engine, so you won’t need to activate it manually in case you want to activate scripts that require it. All it takes to run such a script is to create a new database and to begin the installation process – once the script configuration wizard gains access to the database in question and starts dumping data in it, InnoDB will be set as the default engine for this database as long as it is the one required by the script. You will also be able to use scripts that need MyISAM – the other widely used MySQL engine, so you will not need to configure any settings on the dedicated server. This will allow you to activate various scripts on a single machine and to use the latter to its full potential.