Databases Manager

Supervising your databases is easier than ever before, thanks to the Online Control Panel interface for MySQL and PgSQL administration! Even if you do not have in depth expertise in managing databases, you will find it an easy task to manage compurus.com’s Databases Manager.

You may create a brand new database by just typing the user name and password or make a database backup with a simple click of the mouse. Likewise, with the Data Manager you’ll possess direct access to the admin area for each individual database, so you’re able to effectively alter it.

We’ve made the manual database backup formation into a quite simple task. To execute this: inside of the Databases Manager, click the ’clock’ symbol near the database that you plan to back up and after that wait for a couple of seconds for the process to take place. With regards to the size of the database, the building of any backup file will take somewhere between a couple of seconds and a minute.

You can create as many backups per database as you desire. We haven’t set any limitations on the volume of databases you could back up too.

PgSQL databases are significantly less common as opposed to the common MySQL databases. Then again, they’re a favored option for programmers who seek the best protection for their websites and applications. Thanks to the intuitive Databases Manager integrated into the compurus.com Control Panel, you can control your PostgreSQL databases with a click of the mouse.

You’ll find PgSQL databases included by default in the top Linux hosting packages. Assuming that you are using a standard hosting package, you can easily request PgSQL databases to be included in your cloud hosting account as upgrades.

We have incorporated InnoDB – the new default MySQL database engine on all our web servers. InnoDB is designed for substantial database websites that demand high levels of general performance and scalability. Trials have shown that sites using InnoDB based tables attain a 3–fold performance increase for large joins, in comparison to those utilizing MyISAM tables.

InnoDB makes use of row–level locking in order to clear away the performance problems seen at the top usage times of the previous variant of the database engine – MyISAM, which employs table–level locking.

We offer you a very easy way to keep track of the database usage on your powerful websites. Through the in depth database statistics interface, that is integrated into the Online Control Panel, it is possible to keep track of the load accumulated by your dynamic websites in real time. The presented details will let you assess the database load variations by the hour, every day or on a monthly basis.

You can easily monitor the database load for all of your sites within the Database Stats portion of the Online Control Panel. The table on–screen presents the database queries made within the present month. To review data for a previous month, simply click on the back arrows located at the top.