Databases Manager

Administering your databases is much easier than ever, due to the Control Panel user interface for MySQL and PgSQL control! Provided you do not have detailed expertise in utilizing databases, you will find it easy to use the Databases Manager.

You could make a whole new database by merely keying in the user name and security password or make a database backup with simply a click of the mouse. Moreover, via the Data Manager you’ll possess direct access to the management area for every database, which means you can effectively revise it.

Assuming you have worked with databases, you are aware that making a manual database backup isn’t a simple task. As a way to change this, we’ve made an easy to understand tool that can back up your complete database with simply one click of the mouse. The backup file will be ready for you in under a minute, depending upon the size of the chosen database.

You won’t notice any restrictions on the total number of copies you could make for a specific database.

Just about all of the Linux shared website hosting plans grant PgSQL support. While dropping behind MySQL with regards to acceptance and employment, PgSQL databases are famous for presenting the best level of safety for your website content material. It is the key reason why companies like Skype and Yahoo use PgSQL databases instead of MySQL.

With respect to database management, PgSQL is identically effortless to use as MySQL.

The MySQL databases on our web servers use the latest version of the InnoDB storage engine. InnoDB is created to guarantee the max effectiveness for web sites that operate with substantial volumes of data. It offers CPU effectiveness that could not be matched up by any other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies full transaction support, meaning that you’ll be able to update/insert/create/alter/drop repeatedly for one "operation" of your app. Moreover, it makes use of row–level locking as an alternative to MyISAM’s table–level locking, that increases multi–user concurrency and performance.

We supply you an uncomplicated route to keep an eye on the database use on your dynamic sites. From the descriptive database statistics interface, that is built–into the Control Panel, it’s possible to monitor the load accumulated by your busy sites in real time. The supplied data will help you to evaluate the database load changes on an hourly basis, per day or monthly.

You are able to monitor the database load for your web sites within the Database Stats area of the Control Panel. The table on–screen reveals the database queries created in the present month. To take a look at details for an earlier month, click on the back arrows located at the top.