Databases Manager

The Databases Manager in our Web Control Panel incorporates an effective nevertheless simple to operate interface. You are able to configure a new MySQL or PostgreSQL database by simply typing in a username and password. Also, you may create a back–up file or customize the password of an database with merely a mouse click.

Through the Databases Manager you’ll have direct access to the admin area for all of your databases, allowing you to make uncomplicated corrections if you ever have to.

If you have dealt with databases, you already know that making a manual database back–up is not really a basic task. So as to change this, we have developed an easy to understand tool that can back up the entire database with only one mouse click. The backup file shall be prepared for you in under a minute, depending upon the size of the selected database.

There are no limitations on the total number of copies you may make for any chosen database.

Almost all of the shared services packages present PgSQL support. Although dropping behind MySQL when considering level of popularity and application, PgSQL databases are famous for presenting the highest level of security for your website content and articles. That’s the basic reason why businesses like Skype and Yahoo go with PgSQL databases as a substitute for MySQL.

With regard to database administration, PgSQL is just as simple as MySQL.

The MySQL databases on our machines work with the most up–to–date build of the InnoDB storage engine. InnoDB was built to guarantee the optimum effectiveness for web sites that deal with massive amounts of data. It presents CPU performance that can not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, so that it is possible to update/insert/create/alter/drop many times for one "operation" of your application. At the same time, it works by using row–level locking in lieu of MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

We provide you a straightforward technique to monitor the database usage on your powerful websites. From your descriptive database stats interface, which is built into the Web Control Panel, you’ll be able to track the load generated by your active sites in real time. The delivered info will let you evaluate the database load changes per hour, on a daily basis or per month.

You are able to monitor the database load for all of your sites in the Database Stats section of the Web Control Panel. The table onscreen shows the database lookups generated during the present month. To have a look at details for a previous month, all you have to do is click on the back arrows located at the top.