Find out more on InnoDB and see why it’s already been chosen as the default MySQL database engine.
InnoDB is a very popular storage engine for the MySQL relational database management system. It’s an alternative to the default MyISAM engine and it has got a lot of upsides that have made it the preferred engine for many PHP-based software apps, including Magento and Joomla™, which have switched to InnoDB for good. For example, importing huge data volumes will be faster with InnoDB, since it locks only a single database row to accomplish a certain operation, not the entire database table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the way in which the information is handled. In simpler words, importing new or modifying existing data will either be entirely completed, or will be canceled and the operation will be rolled back in case a given issue shows up in the meantime, which is why the content that remains in the database won’t be damaged.
InnoDB in Shared Web Hosting
You will be able to activate any open-source script-driven app that needs InnoDB if you have a shared web hosting service
with our company, as the database storage engine is available on our innovative cloud web hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly in case this engine is required. You can install applications which use the MyISAM engine without any problem as well and, once again, the engine will be pre-selected, so you won’t have to change any setting manually at any point. Furthermore, we’ll also carry out regular backups of all the databases that you have in your shared hosting account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Servers
All our Linux semi-dedicated servers
include InnoDB and you can use all the options offered by this database engine with any script-powered app that needs it. It’s one of the engines that are available on our cloud website hosting platform, so the one that will be used depends on the prerequisites of the given application. You won’t need to do anything manually in order to activate InnoDB, because it will be set as the default engine when you install an app – whether manually or using our one-click app installer. To avoid any risk, we’ll carry out daily backups of all your databases, so if something goes wrong following an update or if you erase some data accidentally, we will be able to restore the database the way it was on any of the previous seven days.
InnoDB in VPS Servers
In case our in-house built Hepsia Control Panel is picked during the signup process for a new VPS servers
, InnoDB will be activated on the VPS server together with other necessary pieces of software, so you won’t need to do anything if you decide to make use of open-source script-driven software apps that need this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated as well. You can create a brand-new database and begin installing the application manually or through our single-click installer. The system will automatically recognize which engine the particular app requires and will assign it to the specific database, so the installation will proceed flawlessly and the application can enter its data into that database. Thus, you can activate apps with different prerequisites in regard to the MySQL engine without making any changes on your VPS.
InnoDB in Dedicated Servers
InnoDB is included as standard with all dedicated service
ordered with the Hepsia Control Panel. It is included in the standard software package that will be installed on all Hepsia-managed dedicated servers, so once your machine is set up, you’ll be able to log in and to install a various PHP-powered web application that requires this database storage engine. If you create a new database through the Control Panel, there won’t be any activated engine until you begin installing an application. Once the app setup wizard starts entering information into the newly created database, the engine will be chosen automatically in accordance with the specific app’s prerequisites, so you can use both InnoDB and MyISAM without the need to select either one specifically at any point. Thus, you can use a huge collection of apps for your sites.