InnoDB is a popular storage engine for the MySQL DBMS. It’s an alternative to the default MyISAM engine and it has got numerous advantages which have made it the preferred engine for plenty of PHP-driven applications, such as Joomla™ and Magento, which have moved to InnoDB for good. For example, importing huge data volumes will be faster with InnoDB, since it locks only one database row to execute a certain task, not the entire database table, which makes the engine excellent for scalable applications. InnoDB also supports foreign keys and database transactions – these refer to the way in which the data is tackled. Put simply, adding new or editing existing data will either be thoroughly completed, or will be canceled and the procedure will be rolled back if any issue appears in the meantime, which is why the content that remains in the database won’t be damaged.
InnoDB in Cloud Website Hosting
Every script-driven web app that needs InnoDB will function flawlessly on our advanced cloud web hosting platform and the database storage engine is offered with all our cloud website hosting plans. Whenever you create a MySQL database manually or our app installer tool creates one automatically and an app installation is started, the engine that the database in question will use will be selected based on the app’s specifications without having to modify any setting in your account. InnoDB will be picked automatically for any app that requires this specific engine and you’ll be able to make the most of its full potential. We will generate daily backups of your content, so in case you unintentionally remove a MySQL database that’s important to you or you overwrite specific parts of it, we will be able to restore your database the way it was only a couple of hours ago.
InnoDB in Semi-dedicated Hosting
If you set up a brand-new MySQL database through the Control Panel coming with all our semi-dedicated server packages and you start installing an open-source script-based application either manually or using our 1-click application installer tool, the storage engine for the MySQL database will be picked automatically depending on the requirements of the specific application. Since InnoDB is available on the cloud platform where your new semi-dedicated account will be created, it will be set as the default engine for each application that needs it without any manual intervention required on your end at any moment. To prevent any risk of losing info if you update an app or if you remove a database by mistake, we will perform a backup of all your MySQL databases every day, so if something goes wrong, we can rescue your data.
InnoDB in VPS
All Linux VPS that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to run any PHP script-driven web application that needs this MySQL database engine without activating anything manually. You can select Hepsia on the VPS order form and your new server will be set up within the hour, so you can log in and begin building your Internet sites straight away. Once you create a brand new MySQL database and start the app activation process, our system will pick the engine for this MySQL database automatically. Thus, you can install different apps at the same time without the need to edit anything on the server. You can set up a WordPress-based blog that uses MyISAM – the default MySQL engine, and a Magento shopping portal that uses InnoDB, for example.
InnoDB in Dedicated Hosting
If you purchase a new dedicated server, you’ll be able to pick one of the three Control Panels offered by our company – Hepsia and cPanel. Each dedicated server ordered with Hepsia comes with InnoDB pre-installed, so you will not need to add this database engine manually so as to be able to run script-powered applications that require it. InnoDB is used by scalable apps and since a dedicated server will give you all the system resources that you require to run large-size Internet sites, it’s very likely that you will use InnoDB. You will be able to make use of other engines as well, so if a particular application requires MyISAM rather than InnoDB, you will not run into any problem while using it. The engine that will be used will be automatically detected as soon as the app installation process starts, so you won’t have to edit any settings manually whatsoever.