InnoDB is a very popular database engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has got a number of pluses which make it the preferred engine for a lot of PHP script-driven apps, such as Joomla™ and Magento, which have shifted over to InnoDB permanently. For instance, adding large amounts of data will be faster with InnoDB, because it locks only a single row to complete a certain operation, not the entire database table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the data is tackled. Put simply, appending new or editing existing data will either be fully completed, or will be annulled and the procedure will be rolled back if any issue occurs during the process, therefore the content that remains in the database won’t be lost.
InnoDB in Shared Web Hosting
You’ll be able to run any open-source script-driven web app that requires InnoDB in case you’ve got a Linux shared web hosting plan with us, as the MySQL database engine is available on our avant-garde cloud hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably if this engine is required. You can activate applications which require the MyISAM engine without having any problem as well and, again, the engine will be selected automatically, so you will not have to configure any setting manually at any point. Furthermore, we’ll also generate regular backups of all the MySQL databases that you have in your account, so if you delete or overwrite anything, we can quickly get it back to the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Servers
You can install a script-driven software app that requires InnoDB with all of our semi-dedicated server plans, due to the fact that all the accounts are set up on our cutting-edge cloud platform where the MySQL storage engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia website hosting Control Panel, or automatically – in case you take advantage of our single-click app installer. In either case, the needed engine will be selected automatically as soon as the activation of the application starts, so you won’t have to change anything manually, no matter if the app requires InnoDB or the more commonly used MyISAM. Furthermore, we’ll always be able to retrieve any of your MySQL databases in case you erase one by accident, as we perform a couple of MySQL database backups every day, each of which is saved for 1 week.
InnoDB in VPS Servers
All Linux VPS plans that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you’ll be able to use any PHP script-powered web application that requires this MySQL storage engine without needing to configure anything manually. You can choose Hepsia on the VPS order form and your brand new Virtual Private Server will be set up within the hour, so you can log in and start creating your web sites straight away. When you set up a brand-new database and start the app installation process, our system will choose the engine for this MySQL database automatically. In this way, you can make use of different apps at the same time without having to configure anything on the Virtual Private Server. You can have a WordPress-driven blog that uses the default MySQL engine – MyISAM, and a Magento online shop that uses the InnoDB engine, for example.
InnoDB in Dedicated Servers
Our Hepsia Control Panel is one of the features that you can pick on the server configuration page when you buy a dedicated server from our company. As this is the most powerful type of hosting, it’s quite likely that you’ll manage highly popular websites that will attract plenty of individuals, and since InnoDB is among the very best choices for such sites, we’ll install it together with all the other software apps that are available with a Hepsia-managed dedicated server. If you create a brand-new MySQL database in your account, there won’t be any active database storage engine till you begin installing an open-source script, whether manually via your Internet browser or using the automatic script installer tool that is integrated into the hosting Control Panel. The necessary engine will be automatically detected and will be assigned to the database in question, so you can use scripts that require InnoDB, as well as ones that need MyISAM, the default MySQL engine, without the need to cope with any impediment.