InnoDB is a very popular database engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has plenty of strengths which have made it the preferred engine for numerous PHP script-driven web applications, such as Magento and Joomla, which have switched to InnoDB for good. For example, adding huge amounts of data will be faster with InnoDB, since it locks only a single database row to accomplish a specific 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 info is treated. In simpler words, importing new or editing existent data will either be entirely completed, or will be canceled and the operation will be rolled back in case any issue appears during the process, therefore the content that remains in the database will not be lost.

InnoDB in Website Hosting

InnoDB is available with all our website hosting by default, not as a paid upgrade or upon request, so you can install and run any open-source script-based application which requires the database storage engine without having to deal with any impediment once you open your shared website hosting account. InnoDB will be pre-selected as the default engine for a given MySQL database during the app installation process, no matter if you make use of our one-click installer or create the database and install the application manually, on the condition that the app requires InnoDB instead of the more famous MyISAM engine. We will maintain regular MySQL database backups, so you can be certain that you’ll never lose any data in case you delete a database by mistake or you overwrite some important info – you’ll simply have to touch base with us and we will restore the database the way it was.

InnoDB in Semi-dedicated Servers

All our semi-dedicated servers include InnoDB and you’ll be able to take full advantage of all the options offered by this database engine with any script-powered web application that requires it. InnoDB is one of the engines that are available on our cloud web hosting platform, so the one that will be selected depends on the given app’s prerequisites. You will not have to do anything manually to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our 1-click application installer tool. To avoid any risk, we’ll make daily backups of all your databases, so if anything goes wrong following an upgrade or if you delete some data by mistake, we will be able to restore the database the way it was on any of the past seven days.

InnoDB in VPS Servers

All VPS servers that are ordered with the Hepsia hosting Control Panel come with InnoDB already installed, so you will be able to run any PHP-based app that requires the storage engine without needing to set up anything manually. You can pick Hepsia on the VPS order page and your brand new server will be set up within 1 hour, so you can log in and begin creating your web sites straight away. When you set up a new database and begin the app activation process, our system will choose the engine for that MySQL database automatically. In this way, you can activate different apps simultaneously without having to edit anything on the VPS server. You can set up a WordPress personal journal that uses MyISAM – the default MySQL engine, and a Magento-based web shop that makes use of the InnoDB engine, for instance.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the features which you can select on the order form when you buy a dedicated server from our company. Since this is the most powerful type of hosting, it is very likely that you’ll manage highly popular sites that will draw plenty of people, and since InnoDB is among the best choices for such Internet sites, we’ll install it together with all the other software applications that are available with a Hepsia-equipped server. When you set up a brand-new MySQL database in your dedicated server account, there won’t be any active database engine until you begin installing a script, whether manually through your web browser or using the automatic scripts installer that is integrated into the hosting Control Panel. The required engine will be automatically recognized and will be set for that database, so you can use scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without running into any problem.