Databases Manager

The Databases Manager within our Web Control Panel features a refined but still straightforward interface. You can easily configure a new MySQL or PostgreSQL database by simply typing in a user name and password. In addition, you could make a back–up file or change the security password of a database with merely a click of the mouse.

Within the Databases Manager you’ll possess direct access to the management area for each of your databases, allowing you to make effortless alterations if you happen to have to.

We have designed the manual database back–up formation into a quite easy task. To execute this: inside the Databases Manager, click on the ’clock’ image beside the database that you intend to back up and then wait around for a few seconds for the backup process to take place. Depending on the size of your database, the generation of a backup file will require between a few seconds and a minute.

You may create as many backups per database as you would like. We haven’t specified any confines about the volume of databases that you can back up either.

The majority of the shared hosting plans deliver PgSQL support. Whilst dropping behind MySQL with respect to acceptance and usage, PgSQL databases are renowned for delivering the maximum level of security for your site content and articles. It is the basic reason why businesses like Skype and Yahoo go with PgSQL databases as a substitute for MySQL.

In relation to database management, PgSQL is as easy to use as MySQL.

With Duoservers, you will inevitably find the most current version of MySQL along with the default MySQL storage engine – InnoDB, set up.

InnoDB is much more reliable when compared to the earlier storage engine’s edition – MyISAM. It is ACID–compliant and, most importantly – it provides 100% transaction support. It also employs row–level locking, rather than MyISAM’s table–level locking, that used to result in efficiency problems at peak usage periods.

Via the broad database stats tool included in the Web Control Panel, you are going to be able to keep a record of the load accumulated from your busy web sites twenty–four hours a day. Virtually any overload trouble with your sites could slow the loading rates and have a bad effect on the overall impression of your respective site visitors. Consequently, by having info for the database work right away, you are able to fix overload difficulties as quickly as possible.

The database statistics user interface displays information of the volume of daily, hourly and monthly queries, allowing you to evaluate how the load is spread over different time periods.