Within the Your Domain Ninja Website Control Panel you’re going to find a fully–fledged, simple point and click Databases Manager! Utilize it to have full control over all your databases. It’s possible to quickly configure new MySQL and PgSQL databases and control them with the phpMyAdmin and phpPgAdmin software programs, respectively.
An Easy to navigate Interface
Deal with your databases with just a click of the mouse
Taking control of your databases is less complicated than ever, due to the Website Control Panel user interface for MySQL and PgSQL management! Provided you do not have substantial knowledge of dealing with databases, you will find it very easy to deal with our Databases Manager.
You can create a new database by simply keying in the user name and security password or generate a database backup with merely a click of the mouse. Also, with the Data Manager you’ll get direct access to the administrator area for every single database, which means you can easily alter it.
Simple and easy Database Back–up
Database backups are just a click away
Within the Databases Manager you’ll be able to produce an archived copy of your database anytime you desire! That way, you are going to always have a back–up of your operating content material in case your site gets compromised or you incorrectly eliminate a database. To make a back–up: click the ’clock’ image on the side of a particular database and after that wait for a couple of seconds for the backup process to be done.
There are not any restricts about the quantity of databases you are able to back up or the amount of backups you may make for any database.
Support for PgSQL
Assured safety for one’s databases
PgSQL databases are significantly less common when compared to the widespread MySQL databases. Then again, they are a preferred alternative for programmers who seek the uttermost protection for their web sites and web apps. Via the intuitive Databases Manager incorporated into the Your Domain Ninja Control Panel, you can control all of your PostgreSQL databases with a simple mouse click.
You’re going to find PgSQL databases integrated by default with the top Linux web hosting services packages. In case you are using a regular hosting package, it is possible to ask for PgSQL databases to be added to your account as upgrades.
The brand new face of MySQL
We’ve integrated InnoDB – the new standard MySQL database engine on each of our machines. InnoDB is great for massive database websites that demand high performance and scalability. Tests indicate that web sites applying InnoDB based tables achieve a 3–fold general performance grow for huge joins, compared with those applying MyISAM tables.
InnoDB works by using row–level locking in an effort to clear away the functionality problems found at the maximum consumption times of the earlier variant of the database engine – MyISAM, which employs table–level locking.
Detailed Database Stats
Precise statistics for all your databases
Monitoring the load made by the databases on your powerful website will help you reduce any overload issues that might slow it down and chase away visitors. For this reason, we have incorporated a comprehensive Database Stats tool straight into the Website Control Panel. There you will find all–inclusive info on the inbound requests to your databases for every single hour, day and month.
Based on the quantity of daily and hourly queries, you are going to be able to determine which databases are being used the most and then consider measures to optimize their load.