From the Database Manager included in the Web Control Panel, it’s possible to make new MySQL and PgSQL databases immediately! At the same time, you will possess direct access to the administrator area software programs (phpMyAdmin and phpPgAdmin, respectively), so that you can immediately alter the database you want.
Neat and User–friendly User interface
Manage all of your databases from one place
The Database Manager inside the Web Control Panel features a refined but simple to use user interface. It is possible to configure a whole new MySQL or PostgreSQL database by just entering a username and password. Moreover, you could make a back–up file or alter the security password of a database with just a click of the mouse.
Within the Database Manager you will have immediate access to the administration area for all your databases, allowing you to make simple corrections in case you need to.
Instant Database Back–up
Back up your databases in a moment
We’ve transformed the manual database backup generation into a quite simple job. To execute this: inside of the Database Manager, click on the ’clock’ icon beside the database that you would like to back up and afterwards wait around for a few seconds for the process to take place. With respect to the size of your database, the creation of a back–up file will need somewhere between a few seconds and a minute.
You may make as many backups of a database as you want. We haven’t determined any confines about the quantity of databases that you could back up as well.
Essentially the most risk–free open source databases
A lot of our hosting service plans present PgSQL support. Whilst falling behind MySQL with regards to popularity and application, PgSQL databases are renowned for presenting the greatest level of security for your website content material. This is the main reason why brands like Skype and Yahoo employ PgSQL databases as a substitute for MySQL.
With regards to database administration, PgSQL is just as hassle–free as MySQL.
The fresh new face of MySQL
The MySQL databases on FriendHost.IN’s machines work with the newest version of the InnoDB storage engine. InnoDB was built to guarantee the top functionality for websites that deal with huge amounts of data. It features CPU effectiveness that can not be matched up by other different disk–based relational database engines.
InnoDB is ACID–compliant and gives complete transaction support, meaning it’s possible to update/insert/create/alter/drop many times for a single "operation" of your web application. Also, it employs row–level locking as an alternative for MyISAM’s table–level locking, that boosts multi–user concurrency and effectiveness.
Detailed Database Stats
Detailed stats for your databases
Keeping track of the load accumulated by the databases on your dynamic site assists you to avoid all overload difficulties that can slow it down and chase away site visitors. As a result, we’ve incorporated a in depth Database Stats tool into your Web Control Panel. There you will find all–encompassing info on the arriving requests to your databases for every hour, day and month.
Depending on the amount of day–to–day and hourly queries, you are able to determine which databases are employed the most and take steps to optimize their work.