InnoDB is a very popular storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got a lot of upsides which have made it the preferred engine for numerous PHP script-powered apps, such as Magento and Joomla, which have moved to InnoDB for good. For instance, adding immense amounts of data will be much faster with InnoDB, since it locks only one database row to carry out a specific operation, not the entire table, which makes the engine perfect for scalable apps. It also supports foreign keys and transactions – these refer to the manner in which the information is treated. Put simply, appending new or updating existent data will either be thoroughly completed, or will be annulled and the operation will be rolled back if any problem appears during the process, hence the content that remains in the database will not be lost.

InnoDB in Hosting

You’ll be able to install any PHP-driven application that requires InnoDB if you have a Linux hosting service with us, as the MySQL database storage engine is available on our avant-garde cloud website hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue impeccably if this engine is needed. You can run apps which need the MyISAM engine without encountering any difficulty as well and, once again, the engine will be pre-selected, so you won’t need to configure any setting manually at any point. On top of that, we will also carry out regular backups of all the databases that you’ve got in your shared account, so in case you erase or overwrite something, we can swiftly restore it the way it was on any of the previous seven days.

InnoDB in Semi-dedicated Servers

You can use a PHP-driven app that needs InnoDB with any of our semi-dedicated server plans, because all the accounts are set up on our innovative cloud platform where the MySQL database storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia website hosting Control Panel, or automatically – when you take advantage of our one-click application installer. Either way, the needed engine will be picked automatically once the activation of the app starts, so you will not need to change anything manually, no matter if the app requires InnoDB or the more frequently used MyISAM. Also, we’ll always be able to retrieve any of your databases if you accidentally delete one, as we generate a few database backups every day, each of which is stored for one whole week.

InnoDB in VPS Servers

In case our in-house developed Hepsia hosting Control Panel is picked during the registration process for your new VPS servers , InnoDB will be installed on the VPS server together with other essential software, so you will not need to do anything if you choose to use PHP-based software applications that require this MySQL database engine. The default MySQL engine, MyISAM, will be activated as well. You can create a new database and begin the app installation procedure manually or using our 1-click installer tool. The system will detect which engine the application in question needs and will assign it to the specific database, so the installation process will proceed flawlessly and the application can enter its content into that database. Thus, you can run applications with various prerequisites regarding the MySQL engine without having to make any modifications on your VPS.

InnoDB in Dedicated Servers

InnoDB is included by default with all dedicated servers ordered with the Hepsia Control Panel. It is an essential part of the standard software package that we install on all Hepsia-equipped servers, so as soon as your machine is ready, you will be able to log in and to activate any script-based software app that requires this particular storage engine. If you set up a new MySQL database through the 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 database, the engine will be set automatically depending on the requirements of the application in question, so you can use both MyISAM and InnoDB without selecting either one of them explicitly at any point. In this way, you can use a vast collection of applications for your sites.