Databases Manager

Managing your databases is simpler than before, on account of the Web Hosting Control Panel user interface for MySQL and PgSQL management! In case you do not have considerable experience in handling databases, it will be very easy to handle our Databases Manager.

You can create a new database by simply specifying the user name and password or produce a database back–up with a click of the mouse. Moreover, from the Data Manager you will get direct access to the administrator area for each database, so that you can efficiently revise it.

Provided you have worked with databases, you are aware that generating a manual database backup just isn’t an elementary job. As a way to change this, we’ve made a simple tool that will back up your entire database with simply one click of the mouse. The data backup file is going to be available for you in under a minute, depending on the size of the chosen database.

There are no restrictions on how many backup copies you can make for a particular database.

Practically all of the Linux website hosting packages packages deliver PgSQL support. Whilst dropping behind MySQL when considering reputation and employment, PgSQL databases are renowned for delivering the greatest level of security for your website content and articles. That’s the basic reason why companies like Skype and Yahoo rely upon PgSQL databases in lieu of MySQL.

With regards to database management, PgSQL is equally simple and easy as MySQL.

The MySQL databases on our servers work with the most up–to–date release of the InnoDB storage engine. InnoDB has been made to guarantee the optimum functionality for web sites that deal with sizeable amounts of data. It boasts CPU effectiveness that can not be equalled by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, meaning that it is easy to update/insert/create/alter/drop many times for a single "operation" of your application. Additionally, it uses row–level locking rather than MyISAM’s table–level locking, that enhances multi–user concurrency and efficiency.

Keeping tabs on the load accumulated by the databases in your dynamic site will help you reduce virtually any overload difficulties that might slow it down and ward off site visitors. Therefore, we have built–in a descriptive Database Stats tool within the Web Hosting Control Panel. There you can get broad information regarding the arriving requests to your databases for each hour, day and month.

Based on the amount of daily and hourly queries, it is possible to find out which databases are used the most and also take measures to enhance their work.