While in the 9wired Site Control Panel you’re going to find a fully–fledged, simple to operate Database Manager! Utilize it in order to enjoy full control of all your databases. It is possible to very easily set up new MySQL and PgSQL databases and oversee them through the phpMyAdmin and phpPgAdmin software programs, respectively.
Tidy and Uncomplicated User interface
Manage all of your databases from just one place
The Database Manager within our Site Control Panel comes with a refined yet simplified interface. You are able to set up a new MySQL or PostgreSQL database by just typing a username and password. Also, you can make a backup file or change the security password of a database with a click of the mouse.
Within the Database Manager you’ll have direct access to the administration area for all of your databases, meaning you can make effortless modifications when you need to.
Hassle–free Database Back–up
Defend your database content with simply a click
If you have dealt with databases, you know that creating a manual database back–up isn’t a basic task. So as to change this, we have developed very simple tool that can back up your whole database with merely a single click of the mouse. The data backup file will be prepared for you in under a minute, depending on the size of the chosen database.
There are not any restrictions on exactly how many copies you can create for a selected database.
Support for PgSQL
Assured protection for one’s databases
PgSQL databases are significantly less popular compared to the widespread MySQL databases. Then again, they’re a favorite choice for programmers seeking the greatest stability for their sites and web apps. Because of the user–friendly Database Manager incorporated into the 9wired Control Panel, you can manage all your PostgreSQL databases with simply a mouse click.
You can discover PgSQL databases incorporated by default within the top Linux shared web hosting services packages. In case you are with a regular hosting package, you’re able to request PgSQL databases to be added in your account as upgrades.
InnoDB Databases
The newest face of MySQL
With 9wired, you’ll consistently discover the newest edition of MySQL as well as the default MySQL storage engine – InnoDB, installed.
InnoDB is definitely more dependable as compared to the past storage engine’s edition – MyISAM. It is ACID–compliant and, above all – it gives 100% transaction support. In addition, it uses row–level locking, as a substitute for MyISAM’s table–level locking, that seemed to trigger effectiveness issues at high usage periods.
Detailed Database Stats
In depth statistics for your databases
Keeping track of the load generated by the databases within your dynamic website will help you reduce virtually any overload problems that could slow it down and chase away site visitors. For this reason, we’ve provided a in depth Database Stats tool into your Site Control Panel. There you can find detailed information about the inbound requests to your databases for every hour, day and month.
Based on the volume of day–to–day and per hour queries, it is possible to determine which databases are employed the most as well as consider procedures to enhance their load.
