From the Databases Manager built into the Online Control Panel, you will be able to make brand new MySQL and PgSQL databases in an instant! In addition, you will get direct access to the admin area software tools (phpMyAdmin and phpPgAdmin, respectively), so you’re able to conveniently revise the database you want.
A Simple to operate User interface
Command your databases with only a click
Taking control of your databases now is easier than ever before, as a result of Online Control Panel user interface for MySQL and PgSQL administration! Even though you may not have thorough knowledge of handling databases, it will be effortless to work with our Databases Manager.
You can make a new database by merely typing the user name and password or make a database back–up with a simple click of the mouse. Also, from the Data Manager you’ll possess direct access to the administrator area for each and every database, so that you can quite simply alter it.
Speedy Database Back–up
Back up your databases in just a minute
We have changed the manual database back–up generation into a simple task. To execute this: within the Databases Manager, click the ’clock’ icon beside the database that you intend to back up and then wait around for a few seconds for the backup process to take place. With respect to the size of the database, the generation of a back–up file will need somewhere between a couple of seconds and a minute.
You can create as many back–ups of a database as you would like. We have not specified any limits about the amount of databases that you could back up as well.
Support for PgSQL
Warranted reliability for your personal databases
PgSQL databases are much less popular as opposed to the popular MySQL databases. However, they represent a preferred choice for developers who seek the uttermost protection for their websites and apps. Via the intuitive Databases Manager built–into the DataExtend Hosting Service Control Panel, you can administer all of your PostgreSQL databases with simply a click of the mouse.
You can find PgSQL databases incorporated automatically inside the advanced Linux hosting packages packages. If you are with a basic hosting package, you are able to ask for PgSQL databases to be included in your cloud hosting account as upgrades.
The new face of MySQL
We have added InnoDB – the new default MySQL database engine on every one of our servers. InnoDB is good for significant database web sites that need high effectiveness and scalability. Trials have revealed that sites making use of InnoDB based tables attain a 3–fold operation boost for huge joins, as opposed to those making use of MyISAM tables.
InnoDB takes advantage of row–level locking in order to be able to eliminate effectiveness difficulties detected at the maximum consumption times of the previous version of the database engine – MyISAM, which uses table–level locking.
Detailed Database Stats
Detailed statistics for your databases
With the thorough database statistics tool included in the Online Control Panel, it will be possible to keep tabs of the stress produced by your active web sites at any hour. Every single overload problem with your websites can lower the loading speeds and have a bad impact on the overall experience of your website visitors. Consequently, having details for the database work right away, it will be straightforward to solve overload difficulties as fast as possible.
The database statistics interface reveals info of the volume of daily, hourly and monthly queries, to help you to review just how the load is spread over different time frames.