Databases Manager

The Databases Manager inside the Web Site Control Panel features a refined but still convenient to use user interface. It is possible to set up a brand new MySQL or PostgreSQL database by just typing a username and password. In addition, you may create a back–up file or alter the password of the database with only a click of the mouse.

Through the Databases Manager you will get direct access to the administration area for every one of your databases, so its possible to make simple and easy alterations if you ever have to.

Provided you have dealt with databases, you already know that making a manual database backup isn’t an elementary job. In order to change this, we have developed a simple and easy to use tool that can back up your complete database with merely one click. The backup file will be prepared for you in under a minute, with regards to the size of the chosen database.

You won’t notice any limits on exactly how many copies you can make for a selected database.

Practically all of the Linux shared hosting plans provide PgSQL support. While falling behind MySQL with regard to level of popularity and utilization, PgSQL databases are renowned for giving the best level of safety for your website content material. That is the reason why companies such as Skype and Yahoo use PgSQL databases and not MySQL.

With regard to database administration, PgSQL is equally easy to use as MySQL.

With Net Stargate, you’ll regularly discover the most recent build of MySQL as well as the default MySQL storage engine – InnoDB, set up.

InnoDB is definitely more secure as compared to the past storage engine’s version – MyISAM. It is ACID–compliant and, most of all – it includes complete transaction support. Additionally, it works by using row–level locking, as a substitute for MyISAM’s table–level locking, that previously used to result in effectiveness problems at high usage times.

Monitoring the load accumulated by the databases within your active web site assists you to stop any kind of overload troubles that might slow it down and chase away visitors. For this purpose, we have incorporated a comprehensive Database Stats tool within the Web Site Control Panel. There you shall find thorough info on the inbound requests to your databases for each hour, day and month.

In line with the quantity of daily and by the hour queries, you are going to be able to find out which databases are employed the most and then take procedures to enhance their work.