From the Databases Manager built into the Hosting Control Panel, you are able to set–up brand new MySQL and PgSQL databases instantly! Additionally, you will have direct access to the administrator area software tools (phpMyAdmin and phpPgAdmin, respectively), so you’re able to conveniently edit the database you want.
Clean and Uncomplicated Interface
Manage all of your databases from just one location
The Databases Manager inside the Hosting Control Panel includes a refined but easy to navigate user interface. You can easily set up a brand new MySQL or PostgreSQL database by just typing in a username and password. Furthermore, you may create a back–up file or alter the password of the database with only a click of the mouse.
From the Databases Manager you will possess immediate access to the admin area for every one of your databases, which means you can make quick alterations in case you need to.
Rapid Database Backup
Back up your databases in just a minute
We’ve evolved the manual database back–up formation into a very easy activity. To do this: inside of the Databases Manager, click on the ’clock’ icon next to the database that you would like to back up and wait around for a couple of seconds for the process to take place. With regards to the size of your database, the creation of any back–up file can take between a couple of seconds and a minute.
You may create as many back–ups of a database as you wish. We’ve not determined any limits on the quantity of databases you could back up either.
PgSQL Databases Support
Essentially the most safe open source databases
You can find PgSQL support in every one of our cloud website hosting services packages. PgSQL databases aren’t as famous and widespread as MySQL, nonetheless they deliver the maximum level of security for your site content. For this reason, many famous brands like Skype and Yahoo apply PgSQL databases. Handling PgSQL databases is as easy and simple as MySQL, thanks to the user–friendly interface of the Databases Manager.
PgSQL databases are included automatically in the most sophisticated web hosting plans. For the regular packages, they’re presented as upgrades.
InnoDB Databases
The fresh face of MySQL
We’ve installed InnoDB – the new default MySQL database engine on all of our web servers. InnoDB is good for huge database web sites which require high functionality and scalability. Experiments have shown that web sites making use of InnoDB based tables reach a 3–fold overall performance increase for substantial joins, in comparison with those making use of MyISAM tables.
InnoDB works by using row–level locking in an effort to clear away the performance issues detected at the peak consumption times of the earlier variant of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Thorough statistics for all your databases
Keeping track of the load accumulated by the databases for your powerful website assists you to prevent any overload troubles that might slow it down and ward off site visitors. For this specific purpose, we have built in a comprehensive Database Stats tool inside the Hosting Control Panel. There you shall find in depth information on the incoming requests to your databases for every hour, day and month.
Using the quantity of daily and by the hour queries, you’ll be able to find out which databases are employed the most and then consider steps to enhance their load.
