InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default MyISAM engine and it has plenty of pluses which have made it the preferred engine for many script-based software apps, including Magento and Joomla, which have switched to InnoDB permanently. For example, adding large amounts of data will be faster with InnoDB, due to the fact that it locks only a single row to carry out a task, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. To put it simply, adding new or editing existent data will either be thoroughly completed, or will be annulled and the operation will be rolled back in case any problem shows up in the meantime, which is why the content that remains in the database will not be damaged.

InnoDB in Web Hosting

InnoDB is offered with all our Linux web hosting packages by default, not upon request or as a paid upgrade, so you can activate and manage any open-source script-based web app that needs the MySQL database engine without having to deal with any obstacle as soon as you activate your shared account. InnoDB will be pre-selected as the default engine for a certain database during the app activation, regardless of whether you take advantage of our 1-click installation tool or create the MySQL database and install the app manually, provided that the application requires it instead of the more famous MyISAM engine. We will keep regular MySQL database backups, so you can rest assured that you won’t ever lose any data in case you delete a database by mistake or you overwrite some important information – you simply have to notify us and we will restore your database the way it was.

InnoDB in Semi-dedicated Hosting

InnoDB comes with all our Linux semi-dedicated packages by default, so once you obtain a new semi-dedicated account, you can move on and install any open-source script-powered app that needs this particular MySQL database engine. A few engines are installed on our cloud hosting platform, so when you set up a brand-new database and start installing an app manually, or opt to take advantage of the Hepsia hosting Control Panel-integrated app installer, the engine for the database will be picked based on the requirements of the specific app. This will permit you to install and manage InnoDB-specific applications without encountering any complication and without editing any settings in your semi-dedicated account. To be on the safe side, we will always keep a 7-day-old backup of all your MySQL databases, so if you remove or change any content unintentionally, we can swiftly recover it.

InnoDB in VPS Web Hosting

All Linux VPS web hosting packages that are ordered with the Hepsia hosting Control Panel come with InnoDB already activated, so you will be able to take advantage of any PHP-driven application that needs this particular storage engine without installing anything manually. You can pick Hepsia on the VPS order page and your brand new Virtual Private Server will be set up within the hour, so you can sign in and start building your sites straight away. Once you create a brand new MySQL database and start the app installation process, our system will select the engine for that MySQL database automatically. In this way, you can run various apps simultaneously without the need to configure anything on the Virtual Private Server. You can set up a WordPress-driven online journal that makes use of the default MySQL engine – MyISAM, and a Magento-based e-commerce portal that makes use of the InnoDB engine, for example.

InnoDB in Dedicated Servers Hosting

If you purchase a new dedicated server, you’ll be able to pick any of the three hosting Control Panels that we are offering – DirectAdmin, cPanel and Hepsia. Any server ordered with Hepsia comes with InnoDB pre-activated, so you will not need to install this MySQL storage engine manually to be able to manage PHP-powered web applications that require it. InnoDB is used for scalable apps and since a dedicated server will supply you with all the system resources that you need to manage large-size websites, it is pretty likely that you will resort to InnoDB. You’ll be able to make use of other engines too, so if a particular application needs MyISAM rather than InnoDB, you will not run into any difficulty while using it. The engine that will be used will be automatically detected once the app installation process starts, so you will not have to change any setting manually at any moment.