Through the Database Manager integrated into the Site Control Panel, it will be easier to build brand new MySQL and PgSQL databases straight away! At the same time, you’ll possess direct access to the administrator area software programs (phpMyAdmin and phpPgAdmin, respectively), which means you can almost instantly modify the database you want.
A Simple to use User interface
Command your databases with a click
Taking control of your databases now is easier than in the past, thanks to the Site Control Panel user interface for MySQL and PgSQL control! In case you do not have thorough expertise in dealing with databases, it will be very easy to work with the Database Manager.
You may create a brand new database merely by specifying the user name and security password or produce a database backup with just a mouse click. Furthermore, within the Data Manager you will possess direct access to the admin area for every database, allowing you to quickly manage it.
Swift Database Back–up
Back up your databases in just a moment
We’ve made the manual database backup creation into a quite simple activity. To do this: inside of the Database Manager, click the ’clock’ icon beside the database that you would like to back up and afterwards wait around for a couple of seconds for the backup process to take place. Depending on the size of your database, the building of any backup file is going to take somewhere between a few seconds and a minute.
You can create as many backup copies of a database as you desire. We’ve not determined any limitations for the number of databases you could back up too.
Essentially the most risk–free open source databases
Most of PPN Hosting Services’s Linux cloud services bundles offer PgSQL support. Although falling behind MySQL in terms of global recognition and application, PgSQL databases are renowned for offering the best level of security for your web site content. That’s the reason why companies like Skype and Yahoo rely on PgSQL databases and not MySQL.
With regard to database administration, PgSQL is identically simple as MySQL.
The newest face of MySQL
The MySQL databases on our servers make use of the most up–to–date release of the InnoDB storage engine. InnoDB is made to guarantee the max efficiency for web sites that operate with significant amounts of data. It grants CPU efficiency that can not be equalled by any other different disk–based relational database engines.
InnoDB is ACID–compliant and supplies 100% transaction support, meaning that you can update/insert/create/alter/drop repeatedly for a single "operation" of your web application. Furthermore, it uses row–level locking and not MyISAM’s table–level locking, that improves multi–user concurrency and functionality.
Detailed Database Stats
In depth stats for all of your databases
Keeping track of the load caused by the databases on your busy web site will help you stop all overload difficulties that can slow it down and ward off site visitors. As a result, we’ve provided a comprehensive Database Stats tool into your Site Control Panel. There you can see comprehensive information regarding the incoming requests to your databases for each hour, day and month.
Based on the volume of daily and hourly queries, you will be able to find out what databases are utilized the most and then take actions to enhance their load.