With the Database Manager built into the Site Control Panel, you’ll be able to create brand–new MySQL and PgSQL databases immediately! Moreover, you’ll possess direct access to the admin area software programs (phpMyAdmin and phpPgAdmin, respectively), so you’re able to conveniently revise the database you want.
An Uncomplicated User interface
Take care of your databases with only a click
Overseeing your databases is simpler than before, because of the Site Control Panel user interface for MySQL and PgSQL management! Even if you do not have thorough experience in managing databases, you will find it an easy task to manage the Database Manager.
You could make a new database merely by typing the username and password or create a database back–up with a simple click of the mouse. Also, with the Data Manager you’ll get direct access to the admin area for each and every database, meaning you can conveniently update it.
Swift Database Back up
Back up your databases in a minute
We’ve changed the manual database back–up creation into a quite simple task. To do so: in the Database Manager, click on the ’clock’ symbol beside the database that you plan to back up and afterwards hang on for a few seconds for the backup process to take place. Depending upon the size of your database, the generation of the backup file will require somewhere between a couple of seconds and a minute.
You can make as many backup copies of a database as you want. We haven’t specified any limits about the quantity of databases that you could back up as well.
By far the most stable open source databases
The majority of the shared service plans grant PgSQL support. Whilst falling behind MySQL with respect to popularity and utilization, PgSQL databases are renowned for offering up the highest level of stability for your site content material. That’s the key reason why companies such as Skype and Yahoo go with PgSQL databases and not MySQL.
When it comes to database administration, PgSQL is identically straightforward as MySQL.
The fresh face of MySQL
With Duland Business Source, you’ll inevitably discover the newest edition of MySQL along with the default MySQL storage engine – InnoDB, set up.
InnoDB is much more reliable in comparison to the earlier storage engine’s edition – MyISAM. It’s ACID–compliant and, most importantly – it offers 100% transaction support. Additionally, it utilizes row–level locking, in contrast to MyISAM’s table–level locking, that previously used to cause efficiency issues at high usage occasions.
Detailed Database Stats
Complete statistics for all of your databases
Keeping track of the load caused by the databases in your busy website will help you stop all sorts of overload problems that might slow it down and chase away visitors. As a result, we have included a in depth Database Stats tool in the Site Control Panel. There you can get comprehensive information regarding the arriving requests to your databases for each and every hour, day and month.
Using the volume of day–to–day and hourly queries, it will be easier to find out what databases are utilized the most and also consider steps to optimize their load.