Database Manager

Supervising your databases is simpler than ever before, thanks to the Site Control Panel interface for MySQL and PgSQL administration! Even if you do not have detailed experience of utilizing databases, you will find it an easy task to handle our Database Manager.

You can create a brand new database by merely entering the user name and password or make a database backup with just a mouse click. Moreover, through the Data Manager you will possess direct access to the administrator area for every database, so you can almost instantly edit it.

Assuming you have worked with databases, you are aware that creating a manual database back–up is simply not a simple job. As a way to change this, we have created a simple tool that will back up your complete database with merely a single mouse click. The back–up file will be set for you in less than a minute, with respect to the size of the chosen database.

There are no limitations on the amount of back–ups you can create for a specific database.

You’ll find PgSQL support in each of our cloud website hosting plans. PgSQL databases aren’t as well–known and commonly used as MySQL, nevertheless they provide the greatest level of security for your web site content and articles. Therefore, a lot of popular brands like Skype and Yahoo work with PgSQL databases. Dealing with PgSQL databases is as elementary as MySQL, thanks to the incredibly user–friendly interface of the Database Manager.

PgSQL databases are included automatically within the most sophisticated web hosting packages. For the standard plans, they are offered as upgrades.

The MySQL databases on PC service Providers’s web servers utilize the most current version of the InnoDB storage engine. InnoDB was meant to ensure the highest performance for sites that work with sizeable volumes of data. It boasts CPU performance that can not be equalled by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and supplies full transaction support, which means it’s possible to update/insert/create/alter/drop repeatedly for a single "operation" of your web app. Moreover, it utilizes row–level locking in contrast to MyISAM’s table–level locking, that increases multi–user concurrency and performance.

Monitoring the load made by the databases for your powerful web site makes it possible to prevent all kinds of overload troubles that might slow it down and ward off website visitors. For this purpose, we have bundled a in depth Database Stats tool within the Site Control Panel. There you will find in–depth information on the inbound requests to your databases for every hour, day and month.

Based on the number of day–to–day and per hour queries, it will be easy to find out which databases are being used the most and then take procedures to enhance their work.