InnoDB is a popular database engine for the MySQL DBMS. It is an alternative to the default engine – MyISAM, and it has many pluses that have made it the engine of choice for many script-based applications, among them Magento and Joomla™, which have switched over to InnoDB for good. For example, adding immense volumes of data will be faster with InnoDB, as it locks only a single database row to perform a given operation, not the entire table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the info is treated. Put simply, importing new or editing existing data will either be fully completed, or will be annulled and the procedure will be rolled back if some problem occurs in the meantime, so the content that remains in the database won’t be lost.

InnoDB in Shared Web Hosting

InnoDB is offered with all our shared web hosting plans by default, not upon request or as a paid upgrade, so you can install and run any open-source script-powered software application that needs the InnoDB storage engine without having to deal with any difficulty as soon as you activate your shared hosting account. InnoDB will be selected automatically as the default engine for a given database during the app installation, irrespective of whether you make use of our one-click installation tool or create the MySQL database and install the app manually, as long as the application requires InnoDB instead of the more famous MyISAM engine. We’ll maintain daily MySQL database backups, so you can be sure that you won’t ever lose any content in case you delete a database by mistake or you overwrite some essential information – you’ll just have to get in touch with us and we’ll restore everything back to normal.

InnoDB in Semi-dedicated Servers

If you set up a new MySQL database from the hosting Control Panel included with all our semi-dedicated server packages and you start installing an open-source script-based web app either manually or using our 1-click application installer, the storage engine for the database will be picked automatically depending on the prerequisites of the given app. Since InnoDB is present on the cloud web hosting platform where your new semi-dedicated hosting account will be created, it will be set as the default engine for any app that needs it without the need for any manual action on your end at any time. To avoid any chance of losing information if you update an app or if you remove a database by accident, we’ll perform backups of all your MySQL databases each and every day, so if anything goes wrong, we can recover your content.

InnoDB in VPS Servers

If our custom Hepsia Control Panel is selected during the signup process for your new VPS hosting plans , InnoDB will be activated on the Virtual Private Server along with other essential software, so you will not need to do anything if you choose to run PHP script-powered software apps that require this MySQL database engine. MyISAM, the default MySQL engine, will be installed as well. You can create a brand-new database and begin the app installation process manually or through our 1-click installer. The system will recognize which engine the application in question needs and will assign it to the specific database, so the installation process will proceed impeccably and the app can insert its data into that database. In this way, you can activate applications with various prerequisites regarding the MySQL engine without making any modifications on your server.

InnoDB in Dedicated Servers

Our Hepsia Control Panel is one of the options which you can select on the server configuration page when you buy a dedicated server from our company. As this is the most powerful kind of web hosting, it is rather likely that you will manage popular websites that will attract plenty of visitors, and since InnoDB is one of the best options for such sites, we will activate it together with all the other software applications that are available with a Hepsia-managed dedicated server. When you create a brand-new MySQL database in your dedicated server account, there won’t be any active database engine until you start installing a script, whether manually through your Internet browser or using the automatic scripts installation tool that is available in the Control Panel. The required engine will be automatically detected and will be set for the database in question, so you can use scripts that need InnoDB, as well as ones that need MyISAM, the default MySQL engine, without the need to cope with any obstacle.