InnoDB is a very popular storage engine for MySQL. It’s an alternative to the default MyISAM engine and it has numerous strong sides that make it the preferred engine for numerous script-powered web applications, among them Magento and Joomla, which have moved to InnoDB for good. For instance, importing huge data volumes will be much faster with InnoDB, since it locks only a single database row to complete a specific task, not the entire database table, which makes the engine excellent for scalable apps. It also supports foreign keys and database transactions – these refer to the manner in which the data is handled. To put it simply, importing new or modifying existing data will either be entirely completed, or will be canceled and the procedure will be rolled back if a certain issue occurs in the meantime, which is why the content that remains in the database won’t be lost.
InnoDB in Cloud Web Hosting
You’ll be able to activate any PHP script-based software application that needs InnoDB in case you’ve got a cloud web hosting service with us, as the storage engine is available on our advanced cloud hosting platform by default. Throughout the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is required. You can run applications which require the MyISAM engine without any difficulties as well and, again, the engine will be pre-selected, so you will not need to update any setting manually at any time. In addition, we will also make daily backups of all the MySQL databases that you have in the shared web hosting account, so if you erase or overwrite something, we can quickly get it back to the way it was on any of the previous seven days.
InnoDB in Semi-dedicated Servers
You can use an open-source script-driven application that needs InnoDB with all of our semi-dedicated server packages, because all the accounts are created on our leading-edge cloud platform where the MySQL database engine is installed. A new database can be set up in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – when you make use of our 1-click application installer tool. In either case, the needed engine will be selected automatically the moment the app’s activation starts, so you will not have to change anything manually, no matter if the app requires InnoDB or the more regularly used MyISAM. In addition, we’ll always be able to restore any of your databases if you delete one by accident, as we carry out several backups every day, each of which is kept for 1 whole week.
InnoDB in VPS Servers
If our in-house built Hepsia hosting Control Panel is picked during the registration process for a new VPS servers , InnoDB will be installed on the VPS server together with other required pieces of software, so you will not have to do anything if you choose to use open-source script-driven web applications that need this MySQL database storage engine. The default MySQL engine, MyISAM, will be activated as well. You can create a brand-new MySQL database and begin installing the application manually or using our one-click installation tool. The system will detect the engine that the application in question requires and will set it for the specific database, so the installation process will continue impeccably and the application can dump its data in that database. In this way, you can make use of applications with different requirements concerning the MySQL engine without the need to make any modifications on your VPS server.
InnoDB in Dedicated Servers
InnoDB is available as standard with all dedicated servers that are ordered with the Hepsia Control Panel. It’s an essential part of the default software package that we install on all Hepsia-managed servers, so as soon as your physical machine is up and running, you’ll be able to sign in and to install any kind of open-source script-driven software application that needs this particular database engine. If you create a new MySQL database through the hosting Control Panel, there won’t be any active engine until you begin installing an app. Once the app installation wizard begins dumping data in the newly created database, the engine will be selected automatically depending on the particular app’s requirements, so you can use both MyISAM and InnoDB without selecting either one of them explicitly at any time. Therefore, you can use an immense range of apps for your Internet sites.