Databases Manager

Overseeing your databases is less complicated than before, because of the Hosting Control Panel user interface for MySQL and PgSQL management! Even if you do not have extensive experience of working with databases, you will find it an easy task to manage our Databases Manager.

You can make a completely new database merely by keying in the user name and password or produce a database backup with simply a mouse click. Likewise, through the Data Manager you have direct access to the administrator area for every single database, which means you can quite simply update it.

We’ve transformed the manual database backup formation into a very easy activity. To execute that: inside the Databases Manager, click on the ’clock’ image on the side of the database that you intend to back up and then wait around for a few seconds for the backup process to take place. With respect to the size of the database, the creation of any backup file will take between a couple of seconds and a minute.

You can create as many back–ups of a database as you wish. We have not specified any limits about the quantity of databases you could back up as well.

The majority of the Linux shared hosting packages provide PgSQL support. Whilst falling behind MySQL when considering level of popularity and usage, PgSQL databases are renowned for delivering the top level of protection for your site content material. That’s the reason why businesses like Skype and Yahoo make use of PgSQL databases as an alternative to MySQL.

In relation to database administration, PgSQL is equally easy to use as MySQL.

The MySQL databases on our servers work with the most recent release of the InnoDB storage engine. InnoDB is meant to ensure the max functionality for web sites that operate with large volumes of data. It delivers CPU performance that can not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and offers full transaction support, meaning that you’ll be able to update/insert/create/alter/drop many times for one "operation" of your app. Also, it employs row–level locking in place of MyISAM’s table–level locking, that boosts multi–user concurrency and functionality.

From your all–encompassing database stats tool incorporated into the Hosting Control Panel, you are able to keep track of the stress generated by your busy sites around the clock. Virtually any overload issue with your sites can reduce the loading rates and have a negative effect on the overall experience of your website visitors. So, by having info for the database work right away, it will be possible to fix overload issues straight away.

The database stats user interface shows data of the number of daily, hourly and monthly lookups, which enables you to review just how the load is distributed over various periods of time.