We grant you a convenient–to–use Database Manager, incorporated within our Control Panel, from where you could set up new MySQL and PgSQL databases directly. Moreover, you’re able to oversee all of their configuration settings from the easy access given to the phpMyAdmin and phpPgAdmin software tools.
Tidy and Simple Interface
Manage all of your databases from within one place
The Database Manager inside the Control Panel contains an effective yet easy to navigate user interface. You’ll be able to configure a whole new MySQL or PostgreSQL database by just specifying a username and security password. What’s more, you may create a back–up file or change the password of the database with simply a mouse click.
From the Database Manager you will get direct access to the administrator area for each of your databases, so that you can make easy changes should you need to.
Quick Database Back up
Back up your databases in a moment
We’ve developed the manual database back–up generation into a quite easy activity. To execute this: inside the Database Manager, click on the ’clock’ image on the side of the database that you would like to back up and wait for a few seconds for the process to take place. Depending upon the size of the database, the creation of a back–up file can take somewhere between a couple of seconds and a minute.
You may make as many backup copies of a database as you desire. We have not specified any boundaries for the amount of databases you could back up too.
Support for PgSQL
Guaranteed security for your personal databases
PgSQL databases are much less widespread than the prevalent MySQL databases. Nevertheless, they are a favorite selection for designers who are looking for the greatest stability for their web sites and apps. Thanks to the user–friendly Database Manager integrated into the JnD Web Solutions Control Panel, you can administer all of your PostgreSQL databases with only a mouse click.
You can find PgSQL databases incorporated automatically in the best Linux cloud hosting packages packages. Provided that you are with a standard hosting package, it is easy to ask for PgSQL databases to be included in your web hosting account as upgrades.
The brand new face of MySQL
We’ve set up InnoDB – the new standard MySQL database engine on each of our web servers. InnoDB is made for huge database sites which need high levels of effectiveness and scalability. Trials have demonstrated that web sites making use of InnoDB based tables achieve a 3–fold performance grow for very large joins, compared with those applying MyISAM tables.
InnoDB takes advantage of row–level locking in order to clear away the performance issues witnessed at the peak usage times of the prior version of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Thorough statistics for all your databases
Checking the load generated by the databases on your active site makes it possible to avoid all sorts of overload problems that might slow it down and ward off visitors. As a result, we have included a in–depth Database Stats tool directly into the Control Panel. There you shall find all–encompassing information about the incoming requests to your databases for each and every hour, day and month.
In line with the volume of day–to–day and hourly queries, you are going to be able to find out what databases are used the most and then consider actions to optimize their load.