Databases Manager

Managing your databases is much simpler than in the past, on account of the Web Site Control Panel user interface for MySQL and PgSQL management! Even if you do not have thorough knowledge in making use of databases, it will be easy to deal with Host a Domain’s Databases Manager.

You could make a completely new database by simply typing the user name and security password or create a database back–up with just a click of the mouse. Likewise, with the Data Manager you’ll get direct access to the administrative area for each database, so you’re able to easily edit it.

We’ve made the manual database backup creation into a quite easy task. To execute that: inside the Databases Manager, click the ’clock’ icon next to the database that you would like to back up and wait for a couple of seconds for the backup process to take place. Depending upon the size of your database, the generation of a backup file will take between a couple of seconds and a minute.

You can make as many backup copies per database as you want. We haven’t set any limitations on the volume of databases that you can back up either.

A majority of the cloud service packages provide PgSQL support. While falling behind MySQL in terms of global recognition and application, PgSQL databases are renowned for offering the greatest level of stability for your site content and articles. This is the key reason why companies such as Skype and Yahoo use PgSQL databases rather than MySQL.

In terms of database administration, PgSQL is identically simple as MySQL.

The MySQL databases on Host a Domain’s machines utilize the latest build of the InnoDB storage engine. InnoDB has been made to guarantee the top performance for websites that process large amounts of data. It provides CPU efficiency that can not be equalled by other disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, so that it is easy to update/insert/create/alter/drop several times for a single "operation" of your application. Furthermore, it employs row–level locking as an alternative for MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.

Through the comprehensive database statistics tool incorporated into the Web Site Control Panel, you’re going to be able to make a record of the load produced by your active web sites twenty–four hours a day. Every overload trouble with your sites could lower the loading rates and have a bad impact on the online experience of your website visitors. Thus, by having info about the database load right away, you’ll be able to resolve overload issues straight away.

The database data user interface shows details of the number of daily, hourly and monthly lookups, so you’re able to assess just how the load is allocated over several time periods.