InnoDB is a popular database engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has many upsides that have made it the preferred engine for numerous script-driven web applications, including Joomla™ and Magento, which have switched to InnoDB permanently. For instance, importing large amounts of data will be faster with InnoDB, because it locks only a single row to carry out an operation, not the entire database table, which makes the engine excellent for scalable apps. InnoDB also supports foreign keys and database transactions – these refer to the manner in which the info is tackled. Simply put, appending new or editing existent data will either be thoroughly completed, or will be annulled and the procedure will be rolled back in case a given problem shows up in the meantime, so the content that remains in the database won’t be damaged.

InnoDB in Web Hosting

You will be able to install any script-driven app that needs InnoDB if you have a web hosting with our company, as the MySQL database storage engine is present on our leading-edge cloud hosting platform as standard. Throughout the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup process will continue impeccably in case this engine is required. You can activate apps which require the MyISAM engine without any problems as well and, again, the engine will be selected automatically, so you won’t have to modify anything manually at any time. In addition, we will also make daily backups of all the databases that you have in the shared account, so if you erase or overwrite something, 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 use a script-based software app that needs InnoDB with all of our semi-dedicated server plans, since all the accounts are created on our cutting-edge cloud web hosting platform where the MySQL database engine is installed. A new MySQL database can be set up in two ways – manually from the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you take advantage of our one-click app installer. In either case, the required engine will be chosen automatically as soon as the application’s installation starts, so you will not need to change anything manually, regardless of whether the app requires InnoDB or the more widely used MyISAM. On top of that, 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 7 days.

InnoDB in VPS Servers

In case our in-house built Hepsia hosting Control Panel is picked during the registration process for your new VPS servers , InnoDB will be activated on the Virtual Private Server along with other essential pieces of software, so you won’t need to do anything if you choose to activate PHP script-powered software applications that need this MySQL storage engine. The default MySQL engine – MyISAM, will be installed too. You can create a new database and begin the app installation procedure manually or through our 1-click installer tool. The system will automatically detect which engine the particular app needs and will assign it to the specific database, so the installation will continue flawlessly and the app can insert its content into that database. Therefore, you can install applications with different requirements concerning the MySQL engine without the need to make any modifications on your VPS.

InnoDB in Dedicated Servers

Our Hepsia hosting Control Panel is one of the features that you can choose on the order page when you purchase a dedicated server from us. Since this is the most powerful kind of hosting, it’s quite likely that you will manage very popular Internet sites that will draw lots of visitors, and since InnoDB is among the very best choices for such websites, we will install it along with all the other software apps that come with a Hepsia-equipped dedicated server. If you create a new MySQL database in your dedicated server account, there won’t be any active MySQL storage engine until you begin installing a PHP script, whether manually via your web browser or using the automatic scripts installer tool that is included in the hosting Control Panel. The needed engine will be automatically detected and will be set for that database, so you can use scripts that need InnoDB, as well as ones that require the default MySQL engine – MyISAM, without having any problem.