Databases Manager

The Databases Manager inside our Control Panel includes a refined but still uncomplicated user interface. You can configure a new MySQL or PostgreSQL database by simply typing a user name and security password. Additionally, you can make a backup file or change the security password of the database with just a mouse click.

Within the Databases Manager you will get direct access to the admin area for all your databases, allowing you to make simple and easy modifications if you ever have to.

In case you have worked with databases, you know making a manual database back–up is not really an elementary task. So as to change this, we have developed very simple tool that can back up the entire database with just a single click. The back–up file shall be prepared for you in less than a minute, based on the size of the chosen database.

There are no limits on the amount of backup copies you can make for a chosen database.

The majority of the Linux website hosting bundles grant PgSQL support. Whilst falling behind MySQL when it comes to acceptance and utilization, PgSQL databases are renowned for providing the maximum level of safety for your web site content. That’s the basic reason why companies like Skype and Yahoo rely upon PgSQL databases and not MySQL.

With regards to database management, PgSQL is as quick as MySQL.

With Design-Resource Technologies, you will consistently find the most up–to–date version of MySQL as well as the default MySQL storage engine – InnoDB, installed.

InnoDB is definitely more stable compared to the earlier storage engine’s edition – MyISAM. It is ACID–compliant and, best of all – it gives full transaction support. Additionally, it utilizes row–level locking, as a substitute for MyISAM’s table–level locking, that would always trigger efficiency problems at peak usage times.

We supply you a surprisingly simple way for you to observe the database consumption for your active web sites. From your in depth database statistics interface, that’s incorporated into the Control Panel, you’ll be able to record the load created through your active sites in real time. The offered details will let you analyze the database load changes per hour, every day or monthly.

You’ll be able to monitor the database load for all of your web sites through the Database Stats part of the Control Panel. The table onscreen presents the database queries created within the present month. To look at details for a previous month, just click on the back arrows situated at the top.