While in the PNN Hosting Web Control Panel you will find a fully–fledged, easy to navigate Databases Manager! Employ it to experience complete control of your databases. You’re able to simply configure new MySQL and PgSQL databases and manage them through the phpMyAdmin and phpPgAdmin software programs, respectively.
A Convenient User interface
The most effective database administration interface
Database management might sound like a difficult job to newbie web hosting customers, but with the Databases Manager, it’s in fact really simple! To configure a completely new database, you just have to enter the username and password. Database backup copies are just a mouse click away as well.People who need to examine their databases and then revise them can make use of the phpMyAdmin and phpPgAdmin tools.
Quick and easy Database Back–up
Database backups are just a mouse click away
Through the Databases Manager you are able to create an archived duplicate of your database anytime you need! For this reason, you will always have a back–up of your active content material in case your web site gets compromised or if you mistakenly get rid of a database. To make a backup: click on the ’clock’ symbol next to a given database and after that just wait for a couple of seconds for the process to be concluded.
There are not any restricts about the number of databases you are able to back up or the volume of backups you may make for a database.
The most stable open source databases
A majority of our Linux cloud service packages present PgSQL support. Although dropping behind MySQL in terms of level of popularity and usage, PgSQL databases are renowned for providing the maximum level of security for your website content. That’s the key reason why businesses like Skype and Yahoo rely on PgSQL databases and not MySQL.
When it comes to database administration, PgSQL is identically easy to understand as MySQL.
The fresh face of MySQL
The MySQL databases on PNN Hosting’s web servers utilize the most recent version of the InnoDB storage engine. InnoDB is built to guarantee the max effectiveness for websites that deal with big volumes of data. It delivers CPU performance that can not be matched up by any other different disk–based relational database engines.
InnoDB is ACID–compliant and provides complete transaction support, so that it’s possible to update/insert/create/alter/drop more than once for a single "operation" of your web application. At the same time, it makes use of row–level locking and not MyISAM’s table–level locking, that increases multi–user concurrency and effectiveness.
Detailed Database Stats
Detailed statistics for your databases
Checking the load accumulated by the databases within your dynamic website will help you prevent any sort of overload difficulties that can slow it down and ward off visitors. For this reason, we have provided a descriptive Database Stats tool directly into the Web Control Panel. There you can see in depth info on the arriving requests to your databases for each and every hour, day and month.
Using the volume of daily and per hour queries, you’ll be able to determine which databases are being used the most and also take actions to optimize their load.