Databases Manager

The Databases Manager inside the Hosting Control Panel boasts a powerful yet user–friendly interface. You’re able to configure a brand new MySQL or PostgreSQL database by simply typing in a user name and password. In addition, you can make a back–up file or modify the password of the database with merely a click of the mouse.

Within the Databases Manager you have direct access to the administration area for all your databases, so you’re able to make simple corrections in case you need to.

Assuming you have worked with databases, you already know that making a manual database backup is just not a simple job. So as to change this, we’ve made a simple tool that will back up your complete database with only a single click. The data backup file is going to be ready for you in under a minute, depending upon the size of the selected database.

There are no confines on the actual number of backup copies you can create for any selected database.

Most of MSM Instant Webs Hosting’s Linux web hosting bundles feature PgSQL support. While dropping behind MySQL with respect to popularity and application, PgSQL databases are renowned for giving the maximum level of security for your website content material. This is the primary reason why businesses like Skype and Yahoo rely on PgSQL databases as an alternative to MySQL.

When considering database administration, PgSQL is equally straightforward as MySQL.

We have incorporated InnoDB – the brand new default MySQL database engine on every one of our servers. InnoDB is ideal for sizeable database sites that demand high efficiency and scalability. Trials have demonstrated that web sites using InnoDB based tables achieve a 3–fold general performance grow for massive joins, as opposed to those making use of MyISAM tables.

InnoDB takes advantage of row–level locking so as to remove the functionality issues discovered at the peak consumption times of the previous version of the database engine – MyISAM, which utilizes table–level locking.

We offer you a painless option to track the database usage on your busy websites. Via the detailed database statistics interface, which is integrated into the Hosting Control Panel, you are able to track the load made by your active sites in real time. The offered information will assist you to assess the database load variations each hour, on a daily basis or monthly.

It is possible to record the database load for your web sites within the Database Stats area of the Hosting Control Panel. The table on–screen features the database lookups accumulated in the present month. To examine info for a past month, all you have to do is click on the back arrows placed at the top.