From within the Database Manager built–into the Online Control Panel, you will be able to make completely new MySQL and PgSQL databases immediately! Additionally, you have immediate access to the administrative area software programs (phpMyAdmin and phpPgAdmin, respectively), to help you to effectively modify the database you want.
A Simple point and click User interface
Control your databases with merely a click of the mouse
Taking control of your databases is less complicated than ever, thanks to the Online Control Panel user interface for MySQL and PgSQL administration! In case you do not have substantial knowledge of utilizing databases, it will be effortless to handle the Database Manager.
You can make a brand new database by simply specifying the user name and password or produce a database back–up with just a mouse click. In addition, within the Data Manager you will have direct access to the administration area for each individual database, so you’re able to efficiently update it.
Easy Database Data backup
Back up your databases in a minute
We have designed the manual database backup creation into a very easy task. To execute this: inside the Database Manager, click on the ’clock’ icon on the side of the database that you want to back up and afterwards wait for a few seconds for the process to take place. With regards to the size of the database, the building of the back–up file will need somewhere between a couple of seconds and a minute.
You can create as many copies of a database as you desire. We haven’t specified any limits about the volume of databases you could back up too.
PgSQL Databases Support
The most protected open source databases
You’ll find PgSQL support in every one of our cloud plans plans. PgSQL databases are not as sought after and frequently used as MySQL, however they give the top level of security for your website content and articles. Due to this, a lot of well–known brands like Skype and Yahoo utilize PgSQL databases. Controlling PgSQL databases is as easy as MySQL, as a result of the intuitive user interface of the Database Manager.
PgSQL databases are provided by default in the most innovative web hosting plans. For the basic plans, they’re featured as upgrades.
The fresh face of MySQL
We’ve incorporated InnoDB – the brand new default MySQL database engine on all of our web servers. InnoDB is ideal for huge database web sites which need high levels of effectiveness and scalability. Experiments indicate that web sites using InnoDB based tables reach a 3–fold efficiency grow for very large joins, as compared with those employing MyISAM tables.
InnoDB employs row–level locking in order to eliminate effectiveness difficulties noticed at the peak consumption times of the prior release of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
In depth statistics for all your databases
Monitoring the load accumulated by the databases on your active site makes it possible to avoid all sorts of overload problems that could slow it down and chase away site visitors. For this reason, we have designed a in depth Database Stats tool directly into the Online Control Panel. There you shall find in–depth info about the inbound requests to your databases for each hour, day and month.
Using the volume of daily and per hour queries, it will be easier to determine which databases are utilized the most as well as consider measures to enhance their work.