Find out more on InnoDB and see why it’s been chosen as the default MySQL database engine.
InnoDB is a very popular storage engine for MySQL. It is an alternative to the default MyISAM engine and it has many strengths that make it the preferred engine for plenty of open-source script-driven software apps, such as Joomla™ and Magento, which have switched over to InnoDB for good. For instance, adding huge data volumes will be faster with InnoDB, because it locks only one row to carry out a given operation, not the entire table, which makes the engine ideal for scalable applications. InnoDB also supports foreign keys and transactions – these refer to the way in which the information is tackled. Put simply, importing new or updating existing data will either be fully completed, or will be canceled and the procedure will be rolled back if some problem occurs during the process, thus the content that remains in the database will not be lost.
InnoDB in Website Hosting
You’ll be able to run any script-powered web app that requires InnoDB if you’ve got a website hosting service
with us, as the MySQL database storage engine is present on our leading-edge cloud platform as standard. During the app activation – manual or automatic, InnoDB will be selected as the default engine and the setup will proceed flawlessly if this engine is required. You can activate applications which need the MyISAM engine without encountering any problem as well and, again, the engine will be pre-selected, so you won’t have to update anything manually at any time. In addition, we’ll also create daily backups of all the databases that you have in the account, so in case you delete or overwrite something, we can quickly get it back to the way it was on any of the past 7 days.
InnoDB in Semi-dedicated Servers
If you create a brand-new MySQL database through the hosting Control Panel provided with all our semi-dedicated server
accounts and you begin installing a PHP script-powered software application either manually or using our single-click app installer tool, the MySQL database storage engine will be selected automatically depending on the given app’s requirements. Since InnoDB is available on the cloud platform where your new semi-dedicated hosting account will be set up, it will be set as the default engine for any app that needs it without the need for any manual action on your end at any point. To avoid any risk of losing information if you update an application or if you remove a database accidentally, we will make a backup of all your databases each and every day, so if anything goes wrong, we can recover your content.
InnoDB in VPS Servers
All VPS servers
that are ordered with the Hepsia Control Panel come with InnoDB pre-activated, so you will be able to use any open-source script-powered app that requires the MySQL database engine without needing to set up anything manually. You can select Hepsia on the VPS configuration page and your brand new server will be ready within the hour, so you can sign in and begin building your sites straight away. Once you create a brand new MySQL database and begin the app activation process, our system will pick the engine for that MySQL database automatically. Thus, you can activate various apps at the same time without changing anything on the VPS server. You can set up a WordPress-powered personal journal that uses MyISAM – the default MySQL engine, and a Magento-powered online shop that uses InnoDB, for instance.
InnoDB in Dedicated Servers
Our Hepsia hosting Control Panel is one of the options that you can select on the server order page when you buy a dedicated server
from us. Since this is the most powerful kind of website hosting, it is pretty likely that you’ll run popular Internet sites that will draw a lot of visitors, and since InnoDB is among the best choices for such Internet sites, we’ll activate it along with all the other software applications that come with a Hepsia-managed server. If you create a new MySQL database in your dedicated server account, there won’t be any activated MySQL database storage engine till you start installing an open-source script, whether manually via your browser or using the automatic scripts installer tool that is included in the hosting Control Panel. The required engine will be recognized automatically and will be assigned to that database, so you can install scripts that require InnoDB, as well as ones that need MyISAM – the default MySQL engine, without needing to deal with any problem.