Within the Commerce Servers Web Control Panel you can find a fully–featured, uncomplicated Databases Manager! Utilize it to enjoy complete command over your databases. You are able to simply create new MySQL and PgSQL databases and supervise them with the phpMyAdmin and phpPgAdmin software tools, respectively.
Neat and Very easy Interface
Deal with all your databases from a single location
The Databases Manager within our Web Control Panel contains a powerful but user friendly interface. It is possible to configure a whole new MySQL or PostgreSQL database by just specifying a user name and password. Also, you could make a back–up file or change the security password of any database with a click of the mouse.
Via the Databases Manager you’ll get direct access to the administration area for all of your databases, so that you can make hassle–free corrections if you happen to need to.
Quick Database Data backup
Defend your database content with just a mouse click
Assuming you have worked with databases, you know that generating a manual database back–up isn’t a simple job. As a way to change this, we’ve made a simple and easy to use tool that can back up the entire database with simply one click. The data backup file is going to be completely ready for you in under a minute, with respect to the size of the selected database.
There are no limitations on just how many backup copies you can create for any specific database.
By far the most secure open source databases
A lot of our cloud hosting bundles feature PgSQL support. While dropping behind MySQL with respect to global recognition and application, PgSQL databases are famous for presenting the maximum level of protection for your website content. That’s the key reason why companies like Skype and Yahoo rely upon PgSQL databases in lieu of MySQL.
In terms of database management, PgSQL is equally easy to use as MySQL.
The newest face of MySQL
We’ve installed InnoDB – the brand new standard MySQL database engine on all our machines. InnoDB is made for sizeable database websites that need high levels of effectiveness and scalability. Experiments have demonstrated that sites using InnoDB based tables achieve a 3–fold functionality grow for big joins, in comparison with those making use of MyISAM tables.
InnoDB makes use of row–level locking in order to clear away the effectiveness issues noticed at the maximum consumption times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Thorough stats for all your databases
Commerce Servers offers you a simple way to keep track of the database use on your powerful web sites. From your in depth database statistics user interface, which is built into the Web Control Panel, you are able to track the load generated from your dynamic websites in real time. The displayed details will assist you to evaluate the database load variations every hour, every day or monthly.
It is easy to keep an eye on the database load for all of your websites in the Database Stats portion of the Web Control Panel. The table onscreen features the database lookups generated within the present month. To check information for a previous month, simply click on the back arrows situated at the top.