InnoDB is a very popular database engine for MySQL. It is an alternative to the default engine – MyISAM, and it has many strengths which have made it the preferred engine for lots of script-based applications, including Magento and Joomla, which have switched over to InnoDB permanently. For instance, importing enormous data volumes will be faster with InnoDB, as it locks only one database row to complete a particular operation, not the entire table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the way in which the info is tackled. To put it simply, appending new or editing existent data will either be fully completed, or will be annulled and the operation will be rolled back if a certain issue shows up during the process, thus the content that remains in the database will not be damaged.

InnoDB in Cloud Website Hosting

While InnoDB is either not available or a paid upgrade with many web hosting companies, it’s part of the default set of features that we offer with our cloud website hosting plans. If you’d like to make use of an open-source script-driven application that requires InnoDB specifically, in order to be installed and to operate properly, you will not experience any problems as the MySQL database storage engine is available on our in-house built cloud hosting platform. Regardless of whether you set up a brand new database and activate an app manually or make use of our 1-click application installer instrument, InnoDB will be selected automatically by our system as the default engine if the app requires it rather than MyISAM. Besides the exceptional database crash recovery that InnoDB is offering, we also maintain regular backups of all databases, so that we can swiftly restore any MySQL database in your shared web hosting account.

InnoDB in Semi-dedicated Hosting

You can use a PHP-based web application that needs InnoDB with all of our semi-dedicated server plans, as all the accounts are set up on our leading-edge cloud platform where the 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 hosting Control Panel, or automatically – when you use our single-click application installer tool. In either case, the needed engine will be picked automatically as soon as the activation of the application starts, so you won’t have to configure anything manually, no matter if the application needs InnoDB or the more commonly used MyISAM. In addition, we will always be able to retrieve any of your databases in case you accidentally erase one, as we make a few backups every day, each of which is saved for one whole week.

InnoDB in VPS Hosting

If our custom-built Hepsia hosting Control Panel is chosen during the registration process for a new Linux virtual private servers , InnoDB will be activated on the Virtual Private Server along with other necessary pieces of software, so you will not have to do anything if you decide to manage open-source script-based software applications that require this MySQL database storage engine. MyISAM, the default MySQL engine, will be installed as well. You can set up a brand new MySQL database and start the app installation manually or using our 1-click installer tool. The system will detect the engine that the particular application needs and will set it for the specific MySQL database, so the installation process will proceed flawlessly and the app can enter its data into that database. In this way, you can manage applications with different prerequisites with regard to the MySQL engine without having to make any changes on your VPS server.

InnoDB in Dedicated Web Hosting

Our Hepsia Control Panel is one of the features which you can choose on the order page when you purchase a dedicated server from our company. Since this is the most powerful kind of website hosting, it’s very likely that you’ll manage very popular sites that will attract many visitors, and since InnoDB is one of the very best options for such Internet sites, we’ll activate it together with all the other software apps that come with a Hepsia-managed dedicated server. If you create a new MySQL database in your dedicated server account, there won’t be any active storage engine till you begin installing an open-source PHP script, whether manually via your web browser or using the automatic scripts installation tool that is included in the hosting Control Panel. The necessary engine will be detected automatically and will be assigned to the database in question, so you can run scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without the need to cope with any obstacle.