InnoDB is a very popular storage engine for the MySQL RDBMS. It’s an alternative to the default MyISAM engine and it has got lots of upsides which have made it the preferred engine for a lot of PHP-powered web apps, including Joomla and Magento, which have moved to InnoDB for good. For instance, adding immense amounts of data will be faster with InnoDB, since it locks only one row to complete a given task, not the entire 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 treated. To put it simply, importing new or modifying existing data will either be fully completed, or will be annulled and the operation will be rolled back in case any issue appears in the meantime, so the content that remains in the database won’t be damaged.
InnoDB in Shared Hosting
You will be able to run any script-based app that needs InnoDB in case you have a shared hosting with us, as the MySQL database engine is present on our cutting-edge cloud web 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 any problem as well and, once again, the engine will be pre-selected, so you will not need to change any setting manually at any point. Furthermore, we’ll also carry out daily backups of all the MySQL databases that you’ve got in the shared account, so if you delete or overwrite anything, we can quickly restore it the way it was on any of the past seven days.
InnoDB in Semi-dedicated Hosting
InnoDB is included with all our semi-dedicated hosting by default, so the moment you buy a new semi-dedicated account, you can go ahead and activate any PHP script-based software app that requires this particular MySQL database storage engine. A few engines are installed on our cloud web hosting platform, so when you set up a brand new database and start installing an application manually, or opt to make use of the Hepsia Control Panel-integrated application installer, the engine for the database will be chosen in accordance with the requirements of the respective app. This will allow you to activate and run InnoDB-specific applications without the need to deal with any complication and without changing any settings in your semi-dedicated account. To avoid any risk, we’ll always have a 1-week-old backup of all your databases, so if you remove or edit any content by mistake, we can swiftly restore it.
InnoDB in VPS Web Hosting
All VPS web hosting packages that are ordered with the Hepsia hosting Control Panel come with InnoDB pre-activated, so you will be able to use any PHP-driven software app that requires this particular MySQL storage engine without having to configure anything manually. You can pick Hepsia on the VPS configuration page and your brand-new server will be ready within 60 minutes, so you can sign in and begin creating your websites right away. When you set up a brand new database and start the app activation process, our system will set the engine for this MySQL database automatically. In this way, you can manage various applications at the same time without the need to update anything on the Virtual Private Server. You can have a WordPress-powered weblog that makes use of MyISAM – the default MySQL engine, and a Magento-powered web store that makes use of the InnoDB engine, for example.
InnoDB in Dedicated Servers Hosting
When you order a new dedicated server, you’ll be able to choose one of the 3 Control Panels offered by our company – cPanel, DirectAdmin and Hepsia. Each dedicated server ordered with the Hepsia Control Panel comes with InnoDB pre-activated, so you will not need to enable this database storage engine manually in order to be able to run open-source script-driven software applications that need it. InnoDB is used for scalable apps and since a dedicated server will offer you all the server resources that you require to manage large-scale websites, it is very likely that you will use InnoDB. You’ll be able to use other engines as well, so if a certain application needs MyISAM instead of InnoDB, you won’t need to deal with any problem while running it. The engine that will be used will be automatically detected as soon as the app installation process commences, so you will not need to modify any setting manually at any moment.