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 plenty of advantages that make it the engine of choice for a lot of PHP script-based web applications, including Joomla™ and Magento, which have moved to InnoDB permanently. For instance, importing huge volumes of data will be faster with InnoDB, since it locks only one row to carry out a certain task, not the entire database table, which makes the engine excellent for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the info is tackled. Simply put, adding new or updating existing data will either be thoroughly completed, or will be canceled and the operation will be rolled back if a given problem occurs in the meantime, which is why the content that remains in the database won’t be damaged.
InnoDB in Web Hosting
InnoDB is available with all our Linux web hosting by default, not as a paid upgrade or upon request, so you will be able to install and run any PHP-based software app that requires the MySQL storage engine without having to deal with any difficulty once you order your shared web hosting account. InnoDB will be pre-selected as the default engine for a particular MySQL database during the app installation, irrespective of whether you make use of our 1-click installer or create the MySQL database and activate the app manually, provided that the application requires it instead of the more famous MyISAM engine. We’ll maintain regular database backups, so you can rest assured that you will never lose any content if you erase a database by mistake or you overwrite some key info – you’ll just need to contact us and we’ll restore your content the way it was.
InnoDB in Semi-dedicated Servers
If you set up a brand-new MySQL database from the Control Panel included with each of our semi-dedicated server accounts and you start installing an open-source script-driven app either manually or using our one-click application installer, the MySQL database storage engine will be selected automatically on the basis of the requirements of the given application. As InnoDB is present on the cloud website hosting platform where your new semi-dedicated server account will be set up, 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 application or if you delete a database unintentionally, we’ll carry out a backup of all your databases each day, so if something happens, we can retrieve your data.
InnoDB in VPS Servers
If our custom Hepsia hosting Control Panel is selected during the signup process for a new VPS servers , InnoDB will be installed on the VPS server together with other required software, so you will not have to do anything if you decide to activate open-source script-based applications that require this MySQL database engine. The default MySQL engine, MyISAM, will be installed too. You can create a brand new MySQL database and start installing the application manually or through our one-click installer tool. The system will automatically recognize the engine that the application in question requires and will set it for the specific database, so the installation process will continue flawlessly and the application can enter its content into that database. Thus, you can activate applications with different prerequisites in regard to the MySQL engine without making any changes on your Virtual Private Server.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the options which you can choose on the order form when you purchase a dedicated server from our company. As this is the most powerful type of website hosting, it is quite likely that you will manage very popular sites that will attract many people, and since InnoDB is one of the best choices for such Internet sites, we’ll activate it together with all the other software applications that come with a Hepsia-managed dedicated server. When you create a brand new database in your dedicated account, there won’t be any active storage engine until you begin installing a PHP script, whether manually via your Internet browser or using the automatic scripts installer tool that is available in the Control Panel. The necessary engine will be detected automatically and will be set for the database in question, so you can activate scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without running into any problem.