InnoDB

InnoDB is a popular database engine for the MySQL database management system. It’s an alternative to the default engine – MyISAM, and it has a lot of strong sides which have made it the engine of choice for a lot of PHP script-based web apps, among them Joomla^™ and Magento, which have switched to InnoDB for good. For instance, importing immense amounts of data will be much faster with InnoDB, because it locks only one row to perform a task, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the data is treated. To put it simply, appending new or modifying existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if some issue shows up in the meantime, so the content that remains in the database will not be lost.

InnoDB in Shared Web Hosting

InnoDB is available with all our shared web hosting by default, not as a paid upgrade or upon request, so you’ll be able to activate and run any PHP script-driven app which needs the database storage engine without encountering any difficulty as soon as you order your shared account. InnoDB will be selected automatically as the default engine for a particular database during the app activation, no matter if you take advantage of our one-click installation tool or create the database and set up the application manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We will make regular backups of all your databases, so you can be sure that you will never lose any content if you delete a database by mistake or you overwrite some crucial information – you’ll simply need to inform us and we will restore the database the way it was.

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 take advantage of any PHP script-based software app that needs this particular MySQL database engine without having to install anything manually. You can select Hepsia on the VPS configuration page and your brand-new server will be up and running within one hour, so you can sign in and start creating your Internet sites straight away. Once you create a brand-new MySQL database and start the app installation process, our system will select the engine for this MySQL database automatically. In this way, you can install different apps at the same time without the need to modify anything on the Virtual Private Server. You can create a WordPress personal journal that makes use of MyISAM – the default MySQL engine, and a Magento-based e-commerce portal that uses InnoDB, for example.

InnoDB in Dedicated Servers

If you obtain a new dedicated server, you’ll be able to choose one of the three hosting Control Panels that we offer – cPanel, Hepsia and DirectAdmin. Each server ordered with the Hepsia hosting Control Panel comes with InnoDB pre-activated, so you won’t have to enable this database storage engine manually so as to be able to run script-driven software apps that need it. InnoDB is used by scalable apps and since a dedicated server will give you all the system resources that you need to manage very large websites, it’s quite likely that you’ll use InnoDB. You will be able to use other engines too, so if a specific application needs MyISAM instead of InnoDB, you will not have any impediment while using it. The engine that will be used will be recognized automatically the moment the app installation procedure starts, so you won’t have to tweak any setting manually at any point.