InnoDB is a popular storage engine for the MySQL RDBMS. It’s an alternative to the default engine – MyISAM, and it has got plenty of strong sides that have made it the engine of choice for many PHP script-driven applications, such as Joomla and Magento, which have moved to InnoDB for good. For example, adding huge amounts of data will be faster with InnoDB, since it locks only one database row to complete a specific task, not the entire database table, which makes the engine ideal for scalable applications. It also supports foreign keys and transactions – these refer to the manner in which the info is tackled. Put simply, importing new or editing existing data will either be fully completed, or will be annulled and the operation will be rolled back if any problem appears during the process, which is why the content that remains in the database won’t be damaged.
InnoDB in Shared Hosting
Any open-source script-based software app that requires InnoDB will run flawlessly on our leading-edge cloud hosting platform and the MySQL database storage engine comes with all our shared hosting plans. Each time you create a database manually or our app installer creates one automatically and an app installation process is started, the engine that the database will make use of will be selected based on the app’s specifications without the need to modify any setting in your shared account. InnoDB will be selected automatically for any application that requires this specific engine and you will be able to take advantage of its full potential. We’ll maintain daily content backups, so if you accidentally erase a MySQL database that’s important to you or you overwrite some part of it, we’ll be able to restore your data the way it was only a couple of hours ago.
InnoDB in Semi-dedicated Servers
You can activate a PHP script-driven software app that requires InnoDB with all of our semi-dedicated server packages, since all the accounts are set up on our cutting-edge cloud hosting platform where the database storage engine is installed. A new MySQL database can be set up in two separate ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our one-click application installer tool. In either case, the needed engine will be chosen automatically once the application’s activation begins, so you won’t have to update anything manually, regardless of whether the app needs InnoDB or the more commonly used MyISAM. Also, we will always be able to recover any of your MySQL databases if you delete one by mistake, as we create a couple of backups every day, each of which is stored for 1 week.
InnoDB in VPS Servers
If our in-house built Hepsia Control Panel is chosen during the signup process for your new VPS hosting plans , InnoDB will be installed on the server along with other required software, so you will not have to do anything if you choose to run script-powered web apps that need this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated too. You can create a brand-new database and begin installing the application manually or through our 1-click installer. The system will recognize which engine the particular application requires and will assign it to the specific MySQL database, so the installation process will continue impeccably and the application can import its content into that database. Therefore, you can use applications with different requirements regarding the MySQL engine without the need to make any modifications on your VPS server.
InnoDB in Dedicated Servers
InnoDB comes by default with all Linux dedicated servers that are ordered with the Hepsia Control Panel. It’s an integral part of the software bundle that will be pre-installed on all Hepsia-managed servers, so as soon as your physical machine is assembled, you’ll be able to sign in and to activate a various PHP script-powered software application that needs this MySQL storage engine. When you create a new database through the hosting Control Panel, there won’t be any activated engine until you begin installing an app. As soon as the app configuration wizard begins dumping data in the newly created database, the engine will be selected automatically in accordance with the requirements of the specific application, so you can use both MyISAM and InnoDB without the need to select either one of them specifically at any moment. Thus, you can make use of a broad collection of apps for your websites.