From within the Database Manager built into the Control Panel, you will be able to build new MySQL and PgSQL databases straight away! In addition, you will have immediate access to the administrative area software programs (phpMyAdmin and phpPgAdmin, respectively), so you’re able to immediately modify the database you want.
Neat and Uncomplicated Interface
Command all your databases from just one place
The Database Manager in the Control Panel includes a robust yet well designed interface. It is possible to configure a brand new MySQL or PostgreSQL database by simply specifying a user name and security password. Moreover, you could make a back–up file or customize the security password of an database with a mouse click.
With the Database Manager you will get immediate access to the administration area for each of your databases, so its possible to make uncomplicated alterations if you happen to need to.
Straightforward Database Back–up
Guard your database information with only a mouse click
In case you have worked with databases, you know that making a manual database back–up is not a simple job. In order to change this, we have created an effortless to use tool that will back up the entire database with only a single click. The back–up file will be all set for you in under a minute, depending upon the size of the chosen database.
There are no confines on how many backups you can make for a selected database.
Support for PgSQL
Assured reliability for one’s databases
PgSQL databases are less widespread as compared to the standard MySQL databases. Then again, they’re a favorite selection for programmers seeking the greatest protection for their sites and apps. Because of the easy–to–use Database Manager built–into the BADJohn64 Network Control Panel, you can administer all your PostgreSQL databases with merely a click of the mouse.
Yow will discover PgSQL databases included automatically inside the best Linux cloud website hosting packages. In case you are with a regular hosting package, you’ll be able to request PgSQL databases to be added in your account as upgrades.
The fresh face of MySQL
We have set up InnoDB – the new default MySQL database engine on all of our web servers. InnoDB is good for large database sites that need high levels of effectiveness and scalability. Experiments have revealed that sites working with InnoDB based tables reach a 3–fold overall performance increase for very large joins, in comparison with those applying MyISAM tables.
InnoDB makes use of row–level locking in an effort to clear away the efficiency issues witnessed at the top consumption times of the prior variant of the database engine – MyISAM, which employs table–level locking.
Detailed Database Stats
In depth stats for your databases
Through the thorough database stats tool built–into the Control Panel, it will be possible to keep track of the stress produced through your active sites twenty–four hours a day. Any overload difficulty with your sites can slow the loading speeds and have a damaging influence over the overall impression of your website visitors. So, having data about the database work in real time, you are able to fix overload difficulties straight away.
The database statistics interface reveals data of the quantity of daily, hourly and monthly queries, in order to review the way the load is allocated over several time frames.