While in the WebProHosting XYZ Online Control Panel you can find a feature–rich, user friendly Database Manager! Utilize it to enjoy total control of all your databases. It’s possible to quickly create new MySQL and PgSQL databases and manage them via the phpMyAdmin and phpPgAdmin software programs, respectively.
Neat and Uncomplicated Interface
Deal with all of your databases from one location
The Database Manager in our Online Control Panel has a robust nevertheless uncomplicated interface. You can configure a brand new MySQL or PostgreSQL database by simply typing a user name and password. Additionally, you can create a back–up file or alter the password of any database with a mouse click.
Within the Database Manager you have direct access to the administrative area for each of your databases, meaning you can make quick adjustments in case you have to.
Easy Database Backup
Back up your databases in a moment
We have designed the manual database back–up formation into a quite easy activity. To execute that: within the Database Manager, click on the ’clock’ image beside the database that you want to back up and then hang on for a few seconds for the process to take place. With respect to the size of your database, the building of any back–up file is going to take between a few seconds and a minute.
You can create as many backups per database as you want. We’ve not fixed any limits on the number of databases you can back up too.
Support for PgSQL
Assured reliability for your databases
PgSQL databases are much less sought after compared to the widespread MySQL databases. However, they’re a favored alternative for designers who seek the finest security for their websites and apps. Thanks to the user–friendly Database Manager built into the WebProHosting XYZ Control Panel, you can administer all your PostgreSQL databases with a simple click of the mouse.
You are going to find PgSQL databases included by default inside the advanced cloud hosting packages. In case you are using a regular hosting package, you’re able to request PgSQL databases to be added to your cloud hosting account as upgrades.
The new face of MySQL
With WebProHosting XYZ, you will consistently discover the most up–to–date build of MySQL along with the default MySQL storage engine – InnoDB, mounted.
InnoDB is definitely more dependable than the former storage engine’s version – MyISAM. It is ACID–compliant and, best of all – it has complete transaction support. It also takes advantage of row–level locking, as an alternative to MyISAM’s table–level locking, that seemed to lead to functionality issues at high usage occasions.
Detailed Database Stats
In depth statistics for all your databases
Monitoring the load caused by the databases within your busy website will let you avoid any kind of overload difficulties that could slow it down and chase away visitors. For this purpose, we have built in a in–depth Database Stats tool into your Online Control Panel. There you shall find detailed information on the inbound requests to your databases for every hour, day and month.
Using the amount of day–to–day and per hour queries, it is possible to find out what databases are utilized the most and then consider actions to optimize their work.