InnoDB is a popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has numerous advantages that make it the engine of choice for a lot of PHP script-driven applications, including Joomla and Magento, which have moved to InnoDB permanently. For example, importing immense data volumes will be faster with InnoDB, because it locks only one database row to carry out a 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 way in which the information is treated. In simpler words, appending new or updating existent data will either be fully completed, or will be annulled and the procedure will be rolled back in case any problem appears in the meantime, hence the content that remains in the database will not be lost.
InnoDB in Shared Hosting
You’ll be able to activate any PHP script-based web app that requires InnoDB if you have a shared hosting package with us, as the MySQL database storage engine is present on our leading-edge cloud website hosting platform by default. During the app installation – manual or automatic, InnoDB will be selected as the default engine and the setup will continue flawlessly in case this engine is required. You can run applications which need the MyISAM engine without the need to deal with any problem as well and, once again, the engine will be pre-selected, so you won’t have to change any setting manually at any time. What’s more, we will also make regular backups of all the databases that you have in your shared hosting account, so in case you erase or overwrite anything, we can quickly get it back to the way it was on any of the previous 7 days.
InnoDB in Semi-dedicated Hosting
You can make use of a PHP-powered app that requires InnoDB with all of our semi-dedicated server plans, because all the accounts are set up on our avant-garde cloud hosting platform where the storage engine is installed. A new MySQL database can be created in two different ways – manually through the Database Manager section of the Hepsia hosting Control Panel, or automatically – in case you make use of our 1-click app installer. In either case, the required engine will be selected automatically once the activation of the app begins, so you will not need to update anything manually, regardless of whether the app needs InnoDB or the more commonly used MyISAM. On top of that, we’ll always be able to recover any of your databases if you erase one by accident, as we generate a couple of backups every day, each of which is stored for one week.
InnoDB in Dedicated Web Hosting
When you obtain a new dedicated server, you will be able to pick one of the 3 hosting Control Panels offered by us – DirectAdmin, cPanel and Hepsia. Any server ordered with Hepsia comes with InnoDB pre-activated, so you won’t have to install this database storage engine manually to be able to manage PHP script-based applications that need it. InnoDB is used by scalable applications and since a dedicated server will supply you with all the resources that you need in order to manage large-size websites, it is very possible that you’ll use InnoDB. You’ll be able to use other engines too, so in case a given application requires MyISAM instead of InnoDB, you will not need to deal with any difficulty while running it. The engine that will be used will be automatically detected as soon as the app installation process starts, so you will not have to modify any setting manually at any moment.