InnoDB is a database engine for MySQL databases, which is used by widely used PHP script-based software apps like Joomla™ v3 and Magento. It’s excellent for scalable applications, since it works remarkably well when processing enormous amounts of data. Rather than locking the whole database table to add new information to a database like many other engines do, InnoDB locks only one row, so it can carry out a lot more operations for the same period of time. Plus, InnoDB offers a faster database crash recovery and supports database transactions and foreign keys – a set of rules that determine how data imports and updates should be handled. If a certain operation hasn’t been thoroughly completed for whatever reason, the action will be rolled back. In this way, the database content will remain undamaged and won’t be partially mixed with newly inserted content.

InnoDB in Web Hosting

You will be able to activate any PHP-powered app that needs InnoDB if you have a web hosting service with us, as the MySQL database storage engine is available on our advanced cloud platform as standard. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed impeccably in case this engine is needed. You can run applications that use the MyISAM engine without any difficulties as well and, once again, the engine will be selected automatically, so you won’t have to change anything manually at any time. In addition, we’ll also perform regular backups of all the MySQL databases that you’ve got in the account, so in case you erase or overwrite anything, we can swiftly get it back to the way it was on any of the past 7 days.

InnoDB in Semi-dedicated Servers

InnoDB comes with all our Linux semi-dedicated servers by default, so once you create a new account, you can go on and install any PHP-powered web application that requires this particular storage engine. A few engines are installed on our cloud platform, so when you set up a brand new database and start installing an application manually, or opt to make use of the Hepsia hosting Control Panel-integrated application installer tool, the engine for the database will be selected on the basis of the prerequisites of the specific app. This will permit you to activate and manage InnoDB-specific applications without the need to cope with any difficulty and without the need to configure any settings in your semi-dedicated account. To be on the safe side, we’ll always keep a 7-day-old backup of all your MySQL databases, so if you erase or alter any content by accident, we can swiftly retrieve it.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to use any PHP script-powered software app that needs this MySQL storage engine without the need to activate anything manually. You can choose Hepsia on the VPS order form and your new VPS server will be set up within one hour, so you can log in and start creating your sites straight away. Once you set up a brand new MySQL database and start the app activation process, our system will choose the engine for that database automatically. Thus, you can activate various applications at the same time without modifying anything on the server. You can create a WordPress blog that uses the default MySQL engine – MyISAM, and a Magento online store that makes use of the InnoDB engine, for instance.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options that you can select on the server configuration page when you buy a dedicated server from us. Since this is the most powerful kind of web hosting, it’s pretty likely that you’ll manage popular sites that will attract a lot of people, and since InnoDB is one of the best options for such websites, we’ll activate it together with all the other software applications that are available with a Hepsia-managed dedicated server. If you create a brand-new MySQL database in your dedicated server account, there won’t be any active database engine till you begin installing a script, whether manually through your Internet browser or using the automatic scripts installer that is included in the hosting Control Panel. The needed engine will be detected and will be assigned to that database, so you can install scripts that require InnoDB, as well as ones that require MyISAM – the default MySQL engine, without any impediments.