From within the Database Manager integrated into the Control Panel, you’ll be able to make brand new MySQL and PgSQL databases instantly! Additionally, you will have direct access to the administrative area software tools (phpMyAdmin and phpPgAdmin, respectively), in order for you to be able to effectively revise the database you want.
A Well designed Interface
The best database administration user interface
Database management may appear like a complicated job to novice web hosting clients, however with our Database Manager, it’s actually reasonably easy! To create a whole new database, you simply need to enter your username and password. Database back–ups are just a mouse click away also.People that need to look into their databases and also modify them may use the phpMyAdmin and phpPgAdmin tools.
Simple and easy Database Back–up
Database backup copies are just a click away
Within the Database Manager it’s easy to create an archived duplicate of your database anytime you want! Therefore, you are going to always have a back–up of your operating content if your site gets compromised or you erroneously erase a database. To produce a back–up: click on the ’clock’ symbol on the side of a certain database and afterwards just wait for a couple of seconds for the backup process to be completed.
There are no boundaries for the number of databases you are able to back up or the volume of backup copies you can make for a database.
PgSQL Support
The most risk–free open source databases
Most of the website hosting plans bundles offer PgSQL support. Whilst dropping behind MySQL with regards to acceptance and application, PgSQL databases are famous for presenting the greatest level of stability for your website content. This is the main reason why companies like Skype and Yahoo rely on PgSQL databases instead of MySQL.
In relation to database administration, PgSQL is as easy to understand as MySQL.
InnoDB Databases
The fresh face of MySQL
We have installed InnoDB – the brand new default MySQL database engine on our servers. InnoDB is perfect for sizeable database sites that need high levels of efficiency and scalability. Trials have revealed that sites using InnoDB based tables reach a 3–fold performance increase for large joins, when compared to those working with MyISAM tables.
InnoDB uses row–level locking in order to get rid of the overall performance difficulties witnessed at the maximum usage times of the previous version of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Complete statistics for all of your databases
Monitoring the load accumulated by the databases on your busy web site will help you avoid all kinds of overload troubles that can slow it down and chase away visitors. For this specific purpose, we have designed a detailed Database Stats tool into your Control Panel. There you shall find comprehensive information about the inbound requests to your databases for each hour, day and month.
Using the quantity of day–to–day and per hour queries, you will be able to determine which databases are utilized the most and then take actions to optimize their work.
