In the Peanksoft Web Hosting Services Web Site Control Panel you can find a fully–fledged, user–friendly and uncomplicated Database Manager! Utilize it to enjoy total control over all of your databases. It is possible to conveniently set up new MySQL and PgSQL databases and control them through the phpMyAdmin and phpPgAdmin software tools, respectively.
A User friendly Interface
The most efficient database administration interface
Database management may appear like a difficult task to newbie hosting clients, nevertheless with the Database Manager, it’s in fact pretty simple! To make a completely new database, you simply ought to enter the username and password. Database backup copies are only a click away also.Those who wish to explore their databases and also modify them may use the phpMyAdmin and phpPgAdmin tools.
Uncomplicated Database Data backup
Protect your database content with simply a mouse click
If you have worked with databases, you already know that generating a manual database back–up is simply not a simple job. In an effort to change this, we have created an easy to understand tool that can back up your complete database with just one mouse click. The backup file is going to be ready for you in under a minute, based on the size of the chosen database.
There are no confines on just how many back–ups you can create for a particular database.
The most stable open source databases
A majority of the shared hosting service plans offer PgSQL support. Whilst dropping behind MySQL with respect to level of popularity and usage, PgSQL databases are renowned for presenting the greatest level of security for your web site content and articles. That’s the basic reason why companies such as Skype and Yahoo rely on PgSQL databases in lieu of MySQL.
With regards to database management, PgSQL is equally simple and easy as MySQL.
The fresh face of MySQL
We have installed InnoDB – the brand new default MySQL database engine on every one of our servers. InnoDB is made for huge database sites which need high levels of efficiency and scalability. Trials indicate that sites making use of InnoDB based tables achieve a 3–fold effectiveness grow for large joins, as compared to those working with MyISAM tables.
InnoDB employs row–level locking so as to take away the functionality difficulties discovered at the peak usage times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Complete statistics for your databases
Tracking the load made by the databases within your powerful site will let you avoid all kinds of overload issues that can slow it down and chase away website visitors. For this purpose, we have included a detailed Database Stats tool directly into the Web Site Control Panel. There you can see detailed information about the arriving requests to your databases for each and every hour, day and month.
Based on the quantity of daily and by the hour queries, you’re going to be able to determine which databases are used the most as well as consider procedures to enhance their work.