Databases Manager

The Databases Manager within our Site Control Panel boasts a powerful but user–friendly user interface. You can easily set up a new MySQL or PostgreSQL database by simply typing a user name and password. What’s more, you may create a backup file or alter the password of a database with merely a mouse click.

With the Databases Manager you will have direct access to the administration area for all your databases, so you’re able to make easy alterations when you have to.

We have changed the manual database backup creation into a very simple activity. To execute that: inside the Databases Manager, click on the ’clock’ icon next to the database that you would like to back up and then hang on for a couple of seconds for the backup process to take place. With respect to the size of the database, the creation of the back–up file will take somewhere between a few seconds and a minute.

You may make as many backup copies of a database as you wish. We haven’t set any confines for the number of databases you could back up either.

A majority of our cloud website hosting plans bundles feature PgSQL support. While falling behind MySQL when it comes to popularity and usage, PgSQL databases are renowned for supplying the maximum level of stability for your site content and articles. That is the key reason why businesses like Skype and Yahoo use PgSQL databases as an alternative to MySQL.

When considering database administration, PgSQL is as simple and easy as MySQL.

The MySQL databases on PNG Web Hosting’s machines use the most up–to–date release of the InnoDB storage engine. InnoDB was made to guarantee the top functionality for web sites that deal with substantial volumes of data. It boasts CPU effectiveness that can not be matched up by other different disk–based relational database engines.

InnoDB is ACID–compliant and grants complete transaction support, meaning you can easily update/insert/create/alter/drop many times for a single "operation" of your web application. At the same time, it makes use of row–level locking in lieu of MyISAM’s table–level locking, that enhances multi–user concurrency and efficiency.

With the complete database stats tool included in the Site Control Panel, you are able to keep a record of the stress accumulated from your active web sites 24 hour a day. Every overload trouble with your web sites could reduce the loading speeds and have a damaging effect on the overall experience of your site visitors. Therefore, having info about the database load immediately, you’ll be able to fix overload problems in a timely manner.

The database data user interface shows information of the volume of daily, hourly and monthly queries, in order to analyze just how the load is distributed over several periods of time.