Via the Database Manager integrated into the Web Control Panel, it will be easier to create brand new MySQL and PgSQL databases right away! Furthermore, you’ve got immediate access to the admin area software programs (phpMyAdmin and phpPgAdmin, respectively), to help you to efficiently modify the database you want.
A User–friendly and uncomplicated Interface
Easy and simple database managing user interface
Database management may seem like a difficult task to beginner website hosting users, nevertheless with the Database Manager, it’s in fact pretty simple! To set up a new database, you only need to key in your username and password. Database backups are simply a click away too.People who need to explore their databases and update them should use the phpMyAdmin and phpPgAdmin tools.
Rapid Database Back up
Back up your databases in a minute
We’ve changed the manual database backup generation into a very easy task. To do so: in the Database Manager, click on the ’clock’ symbol on the side of the database that you intend to back up and afterwards wait for a couple of seconds for the backup process to take place. With respect to the size of your database, the building of the backup file is going to take between a few seconds and a minute.
You may create as many copies of a database as you wish. We have not fixed any boundaries for the quantity of databases that you can back up as well.
Support for PgSQL
Assured reliability for your personal databases
PgSQL databases are less widespread compared to the standard MySQL databases. Nevertheless, they represent a favorite option for programmers seeking the uttermost protection for their web sites and apps. Through the intuitive Database Manager incorporated into the Please Host My Site Control Panel, you can administer all your PostgreSQL databases with only a click of the mouse.
You can discover PgSQL databases provided automatically within the best shared web hosting packages. Assuming that you are with a regular hosting package, you can ask for PgSQL databases to be added in your website hosting account as upgrades.
The new face of MySQL
We’ve integrated InnoDB – the brand new standard MySQL database engine on every one of our web servers. InnoDB is designed for large database websites which require high levels of overall performance and scalability. Experiments have established that sites using InnoDB based tables attain a 3–fold performance boost for significant joins, as opposed to those working with MyISAM tables.
InnoDB employs row–level locking in an effort to clear away the general performance difficulties observed at the maximum usage times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Complete statistics for all of your databases
Keeping track of the load generated by the databases within your dynamic site assists you to reduce all sorts of overload problems that could slow it down and chase away website visitors. As a result, we’ve incorporated a descriptive Database Stats tool within the Web Control Panel. There you can get complete information on the inbound requests to your databases for each and every hour, day and month.
Based on the number of day–to–day and hourly queries, it will be easier to find out which databases are utilized the most and also consider procedures to optimize their work.