InnoDB is a popular storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has a number of pluses that make it the preferred engine for many open-source script-based software applications, including Magento and Joomla, which have shifted over to InnoDB permanently. For example, importing immense amounts of data will be much faster with InnoDB, since it locks only one database row to accomplish an operation, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and transactions – these refer to the manner in which the information is tackled. Simply put, importing new or editing existent data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if some issue shows up during the process, so the content that remains in the database won’t be damaged.
InnoDB in Shared Website Hosting
You’ll be able to install any script-based software application that needs InnoDB if you’ve got a Linux shared website hosting package with our company, as the MySQL database storage engine is present on our innovative cloud website hosting platform by default. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly if this engine is required. You can activate apps that require the MyISAM engine without the need to deal with any problem as well and, again, the engine will be pre-selected, so you won’t need to change anything manually at any time. On top of that, we will also create daily backups of all the MySQL databases that you’ve got in your shared account, so if you erase or overwrite anything, we can swiftly get it back to the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Hosting
You can activate a PHP-based software application that requires InnoDB with all of our semi-dedicated server plans, because all the accounts are created on our leading-edge cloud web hosting platform where the database storage engine is installed. A new MySQL database can be created in two ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you use our 1-click application installer. Either way, the needed engine will be selected automatically as soon as the installation of the application begins, so you will not need to update anything manually, no matter if the app needs InnoDB or the more commonly used MyISAM. Also, we’ll always be able to retrieve any of your MySQL databases in case you accidentally delete one, as we carry out a couple of MySQL database backups every day, each of which is stored for seven days.
InnoDB in VPS
In case our in-house developed Hepsia hosting Control Panel is selected during the signup process for your new Linux VPS packages , InnoDB will be installed on the Virtual Private Server together with other essential software, so you will not need to do anything if you choose to run open-source script-driven apps that need this MySQL database storage engine. The default MySQL engine – MyISAM, will be installed too. You can set up a brand new database and start the app installation process manually or using our 1-click installation tool. The system will detect the engine that the particular app requires and will assign it to the specific database, so the installation process will proceed impeccably and the app can enter its data into that database. In this way, you can manage apps with various prerequisites in regard to the MySQL engine without the need to make any modifications on your VPS.
InnoDB in Dedicated Hosting
When you get a new dedicated server, you’ll be able to choose any of the 3 Control Panels offered by our company – cPanel, DirectAdmin and Hepsia. Any dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you won’t need to install this database engine manually so as to be able to run PHP script-driven software applications that need it. InnoDB is used for scalable apps and since a dedicated server will give you all the resources that you require to run large-size Internet sites, it’s very possible that you’ll resort to InnoDB. You’ll be able to make use of other engines as well, so in case a certain app requires MyISAM instead of InnoDB, you will not have to deal with any impediment while managing it. The engine that will be used will be recognized automatically once the app installation procedure starts, so you won’t need to change any settings manually at any time.