InnoDB is a very popular storage engine for the MySQL relational database management system. It is an alternative to the default MyISAM engine and it has a lot of pluses which have made it the preferred engine for a lot of open-source script-driven software apps, among them Joomla and Magento, which have shifted over to InnoDB for good. For example, adding immense amounts of data will be faster with InnoDB, due to the fact that it locks only one database row to perform an operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the information is tackled. In simpler words, adding new or editing existing data will either be fully completed, or will be annulled and the operation will be rolled back if some problem appears in the meantime, hence the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

Every PHP script-based web app that requires InnoDB will function flawlessly on our avant-garde cloud platform and the MySQL database storage engine is offered with all our shared hosting plans. Every time you create a MySQL database manually or our app installer creates one automatically and an app installation is started, the engine that the database will make use of will be selected on the basis of the app’s requirements without the need to configure any setting in your account. InnoDB will be selected automatically for any app that requires this specific engine and you’ll be able to make the most of its full capacity. We’ll perform regular backups of your content, so in case you unintentionally remove a database that you need or you overwrite a specific part of it, we’ll be able to restore your content the way it was just a couple of hours ago.

InnoDB in Semi-dedicated Servers

InnoDB is available with all our semi-dedicated servers by default, so as soon as you order a new semi-dedicated account, you can go on and install any script-powered app that needs the MySQL database engine. Several engines are pre-installed on our cloud web hosting platform, so when you set up a brand new MySQL database and begin installing an app manually, or opt to use the Hepsia hosting Control Panel-integrated application installer, the engine for the database will be chosen on the basis of the given app’s prerequisites. This will allow you to activate and run InnoDB-specific apps without running into any obstacle and without changing 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 delete or alter any content accidentally, we can quickly rescue it.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you will be able to use any PHP script-powered software app that needs this database engine without installing anything manually. You can select Hepsia on the VPS configuration page and your brand new server will be ready within one hour, so you can log in and start building your Internet sites right away. Once you set up a new database and start the app installation process, our system will choose the engine for that MySQL database automatically. Thus, you can make use of different applications simultaneously without having to edit anything on the VPS server. You can create a WordPress personal blog that makes use of MyISAM – the default MySQL engine, and a Magento-powered Internet shop that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options that you can choose on the server configuration page when you purchase a dedicated server from our company. As this is the most powerful kind of hosting, it’s pretty likely that you will manage highly popular websites that will attract a lot of visitors, and since InnoDB is among the very best options for such websites, we’ll enable it along with all the other software apps that are offered with a Hepsia-equipped dedicated server. When you set up a brand-new MySQL database in your dedicated account, there won’t be any active MySQL database engine until you start installing a script, whether manually through your Internet browser or using the automatic script installation tool that is integrated into the hosting Control Panel. The necessary engine will be recognized automatically and will be assigned to the database in question, so you can install scripts that require InnoDB, as well as ones that require the default MySQL engine – MyISAM, without the need to deal with any difficulty.