InnoDB is a very popular database engine for the MySQL database management system. It is an alternative to the default MyISAM engine and it has a lot of strengths that make it the preferred engine for lots of PHP-based web apps, among them Magento and Joomla™, which have shifted over to InnoDB for good. For example, importing large data volumes will be much faster with InnoDB, as it locks only a single database row to execute a particular operation, not the entire table, which makes the engine ideal for scalable apps. It also supports foreign keys and database transactions – these refer to the way in which the data is treated. To put it simply, importing new or updating existent data will either be thoroughly completed, or will be aborted and the operation will be rolled back if a certain problem occurs during the process, which means that the content that remains in the database won’t be lost.
InnoDB in Shared Website Hosting
InnoDB is available with all our shared website hosting
by default, not as a paid upgrade or upon request, so you can activate and run any open-source script-driven web application that needs the MySQL database engine without having to deal with any obstacle once you open your shared web hosting account. InnoDB will be pre-selected as the default engine for a specific database during the app installation process, no matter if you take advantage of our 1-click installation tool or create the database and activate the application manually, provided that the application requires InnoDB instead of the more popular MyISAM engine. We’ll carry out regular database backups, so you can be certain that you will never lose any data in case you delete a database by accident or you overwrite some crucial info – you just need to get in touch with us and we will restore everything the way it was.
InnoDB in Semi-dedicated Hosting
If you create a brand-new MySQL database from the Control Panel coming with each of our semi-dedicated server
accounts and you start installing an open-source script-powered web app either manually or using our 1-click application installer tool, the database storage engine will be picked automatically on the basis of the prerequisites of the specific app. Since InnoDB is available on the cloud website hosting platform where your new semi-dedicated account will be created, it will be set as the default engine for each app that needs it without any manual action required on your end at any time. To prevent any risk of losing data if you update an app or if you erase a database unintentionally, we will carry out backups of all your databases each day, so if something goes wrong, we can rescue your data.
InnoDB in VPS Hosting
In case our custom-developed Hepsia hosting Control Panel is picked during the registration process for your new Linux virtual private servers
, InnoDB will be installed on the Virtual Private Server together with other required pieces of software, so you won’t need to do anything if you choose to use PHP script-driven software applications that require this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed as well. You can create a brand new database and start the app installation process manually or through our 1-click installer. The system will automatically recognize which engine the application in question needs and will set it for the specific database, so the installation process will continue flawlessly and the app can dump its content in that database. In this way, you can activate applications with different requirements regarding the MySQL engine without the need to make any changes on your VPS.
InnoDB in Dedicated Web Hosting
InnoDB is included by default with all Linux dedicated web hosting
that are ordered with the Hepsia hosting Control Panel. It is an integral part of the default software package that will be pre-installed on all Hepsia-managed dedicated servers, so once your machine is set up, you will be able to sign in and to activate any PHP script-powered app that requires this particular MySQL storage engine. If you set up a new database via the hosting Control Panel, there won’t be any activated engine till you start installing an app. Once the app activation wizard starts inserting data into the newly created database, the engine will be set automatically depending on the particular app’s requirements, so you can run both InnoDB and MyISAM without the need to select either of them specifically at any time. Therefore, you can make use of an immense range of applications for your websites.