InnoDB is a popular storage engine for the MySQL relational database management system. It is an alternative to the default engine – MyISAM, and it has got many strong sides that have made it the preferred engine for many PHP-powered software applications, including Magento and Joomla™, which have switched to InnoDB for good. For example, importing enormous amounts of data will be faster with InnoDB, as it locks only a single database row to carry out a specific task, not the entire table, which makes the engine ideal for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the way in which the info is treated. Simply put, importing new or editing existing data will either be entirely completed, or will be aborted and the operation will be rolled back if a given issue shows up during the process, hence the content that remains in the database will not be damaged.
InnoDB in Cloud Hosting
You’ll be able to use any script-based web application that requires InnoDB in case you’ve got a Linux cloud hosting
with us, as the database engine is present on our innovative cloud hosting platform by default. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is needed. You can install applications that need the MyISAM engine without any problem as well and, again, the engine will be pre-selected, so you won’t need to modify anything manually at any time. What’s more, we will also generate regular backups of all the databases that you’ve got in the account, so if you delete or overwrite something, we can quickly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Hosting
All our Linux semi-dedicated hosting services
support InnoDB and you’ll be able to use all the features offered by this MySQL database storage engine with any script-driven software application that requires it. It is among the engines that we have on our cloud platform, so the one that will be selected depends on the prerequisites of the specific application. You won’t have to do anything manually in order to enable InnoDB, since it will be set as the default engine when you install an application – whether manually or using our one-click application installer tool. To avoid any risk, we will generate daily backups of all your databases, so if something goes wrong following some update or if you erase some data by mistake, we will be able to get your database back to the way it was on any of the past 7 days.
InnoDB in VPS Web Hosting
If our in-house developed Hepsia Control Panel is selected during the registration process for a new Linux virtual private servers
, InnoDB will be activated on the server along with other necessary pieces of software, so you will not need to do anything if you decide to use open-source script-based web apps that require this MySQL database engine. MyISAM – the default MySQL engine, will be installed too. You can set up a new MySQL database and start installing the app manually or using our single-click installer. The system will recognize the engine that the particular app requires and will assign it to the specific database, so the installation process will continue impeccably and the app can dump its data in that database. Therefore, you can use applications with different prerequisites regarding the MySQL engine without having to make any changes on your server.
InnoDB in Dedicated Servers Hosting
InnoDB is included by default with all dedicated hosting services
that are ordered with the Hepsia hosting Control Panel. It is an essential part of the default software package that we install on all Hepsia-equipped dedicated servers, so as soon as your machine is ready, you will be able to log in and to install any type of PHP-powered software application that requires this database storage engine. When you create a new database via the hosting Control Panel, there won’t be any active engine until you begin installing an application. Once the app configuration wizard begins entering data into the database, the engine will be chosen automatically in accordance with the prerequisites of the app in question, so you can run both InnoDB and MyISAM without the need to select either of them explicitly at any point. Therefore, you can make use of a huge selection of applications for your Internet sites.