InnoDB is a popular storage engine for MySQL. It is an alternative to the default engine – MyISAM, and it has numerous strong sides which make it the engine of choice for many script-powered applications, such as Magento and Joomla, which have shifted over to InnoDB for good. For instance, adding enormous data volumes will be faster with InnoDB, because it locks only one database row to perform an operation, not the entire database table, which makes the engine perfect for scalable applications. It also supports foreign keys and transactions – these refer to the way in which the info is treated. Put simply, adding new or modifying existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back in case some issue appears in the meantime, which is why the content that remains in the database won’t be damaged.

InnoDB in Shared Hosting

InnoDB is offered with all our shared hosting plans by default, not as a paid upgrade or upon request, so you will be able to install and run any PHP script-powered app which requires the database storage engine without any impediments as soon as you order your shared website hosting account. InnoDB will be pre-selected as the default engine for a given database during the app installation process, no matter if you make use of our single-click installation tool or create the MySQL database and install the application manually, on the condition that the app requires it instead of the more famous MyISAM engine. We’ll store daily backups of all your databases, so you can be sure that you’ll never lose any data if you erase a database by accident or you overwrite some key information – you just need to get in touch with us and we’ll restore the database the way it was.

InnoDB in Semi-dedicated Servers

If you create a brand new MySQL database through the Control Panel offered with each of our semi-dedicated server accounts and you begin installing an open-source script-powered app either manually or using our single-click application installer tool, the storage engine for the MySQL database will be selected automatically depending on the prerequisites of the specific application. Since InnoDB is present on the cloud website hosting platform where your new account will be set up, it will be set as the default engine for each app that needs it without any manual intervention required on your end at any moment. To avoid any chance of losing info if you update an application or if you erase a database by mistake, we’ll carry out a backup of all your databases every day, so if something goes wrong, we can rescue your data.

InnoDB in VPS Servers

If you pick a VPS server with our Hepsia hosting Control Panel, the InnoDB database engine will be part of the software package that will be pre-installed on your VPS server before we give it to you. You won’t have to set up anything manually and you’ll be able to install and manage any PHP-powered app that requires InnoDB once your Virtual Private Server is ready, which takes no more than 60 minutes after the order procedure itself. A number of engines are available, so every time you set up a MySQL database using the Hepsia hosting Control Panel, a particular engine will be selected when the app installation process starts and our system will recognize the engine that is required by the application in question. In case you need MyISAM, for example, you will not need to do anything different from installing the desired app, whether manually or using our app installer tool.

InnoDB in Dedicated Servers

All dedicated web hosting plans ordered with our custom Hepsia hosting Control Panel include a software package that’s pre-installed and besides everything else, you’ll get the InnoDB database engine, so you will not need to activate it manually if you need to run PHP scripts that require it. All it takes to install such a script is to create a new MySQL database and to start the setup – once the script configuration wizard gets access to the database and starts inserting data into it, InnoDB will be set as the default engine for this database provided that it is the one needed by the script. You’ll also be able to use scripts that require MyISAM – the other popular MySQL engine, so you won’t have to update any settings on the server. This will enable you to run different scripts on a single physical machine and to use the latter to its fullest capacity.