InnoDB is a popular database engine for MySQL. It’s an alternative to the default MyISAM engine and it has lots of strengths which make it the preferred engine for many PHP script-driven web apps, among them Joomla™ and Magento, which have switched to InnoDB for good. For example, adding large data volumes will be faster with InnoDB, because it locks only a single database row to carry out a certain operation, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. To put it simply, importing new or modifying existing data will either be entirely completed, or will be canceled and the operation will be rolled back if a certain problem shows up in the meantime, hence the content that remains in the database will not be damaged.

InnoDB in Cloud Hosting

You will be able to use any script-powered software app that requires InnoDB if you’ve got a Linux cloud hosting with us, as the storage engine is present on our advanced cloud web hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably if this engine is needed. You can install apps that require the MyISAM engine without having to deal with any difficulty as well and, again, the engine will be pre-selected, so you won’t have to update anything manually at any moment. On top of that, we’ll also make daily backups of all the databases that you have in your shared hosting account, so in case you erase or overwrite anything, we can quickly restore it the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

InnoDB is available with each of our Linux semi-dedicated servers by default, so as soon as you purchase a new account, you can go ahead and activate any open-source script-powered application that requires this particular MySQL database engine. A few engines are installed on our cloud website hosting platform, so when you create a brand-new MySQL database and start installing an app manually, or opt to make use of the Hepsia Control Panel-integrated app installer tool, the engine for the database will be picked depending on the prerequisites of the respective application. This will allow you to activate and run InnoDB-specific apps without encountering any impediment and without needing to change any settings in your account. To avoid any risk, we will always keep a 1-week-old backup of all your databases, so if you remove or alter any content accidentally, we can swiftly restore it.

InnoDB in VPS Servers

If you get a VPS server from us, you will be able to take advantage of our in-house built Hepsia Control Panel to manage your web content. A Hepsia-equipped Virtual Private Server will allow you to activate any script-based software application that requires InnoDB, as this particular database engine is part of the default software bundle that will be installed on the Virtual Private Server during its creation. When you set up a brand new MySQL database through the Control Panel, you will simply need to begin installing an application – manually or using our application installer tool. InnoDB will be set as the default engine as long as the application in question needs it, so you won’t need to do anything else in your VPS account. Identically, if a certain app needs MyISAM, it will be automatically set as the default engine for this specific MySQL database.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is among the options which you can select on the order form when you buy a dedicated server from our company. As this is the most powerful kind of website hosting, it’s quite likely that you will run highly popular websites that will attract a lot of people, and since InnoDB is one of the very best options for such Internet sites, we’ll install it along with all the other software applications that are available with a Hepsia-managed dedicated server. If you create a brand new database in your dedicated server account, there won’t be any activated MySQL database storage engine until you begin installing an open-source PHP script, whether manually through your browser or using the automatic script installation tool that is available in the hosting Control Panel. The required engine will be automatically detected and will be set for the database in question, so you can make use of scripts that need InnoDB, as well as ones that need the default MySQL engine, MyISAM, without the need to cope with any impediment.