Databases Manager

Database management might sound like a hard task to inexperienced cloud hosting clients, nevertheless with HostMasterG’s Databases Manager, it’s actually reasonably easy! To create a whole new database, you only have to type in the username and password. Database backups are a click away also.People who choose to explore their databases and alter them may use the phpMyAdmin and phpPgAdmin tools.

We’ve designed the manual database backup formation into a quite easy job. To execute this: inside the Databases Manager, click on the ’clock’ symbol next to the database that you would like to back up and after that hang on for a couple of seconds for the backup process to take place. With regards to the size of your database, the building of the back–up file will need somewhere between a couple of seconds and a minute.

You may make as many back–ups of a database as you want. We haven’t specified any restrictions for the amount of databases that you could back up as well.

Practically all of HostMasterG’s shared hosting packages present PgSQL support. Whilst falling behind MySQL with respect to popularity and application, PgSQL databases are famous for providing the greatest level of security for your website content. It is the key reason why businesses like Skype and Yahoo employ PgSQL databases in lieu of MySQL.

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

The MySQL databases on HostMasterG’s web servers employ the newest build of the InnoDB storage engine. InnoDB is created to guarantee the maximum performance for sites that process large volumes of data. It supplies CPU effectiveness that can not be equalled by other disk–based relational database engines.

InnoDB is ACID–compliant and gives 100% transaction support, which means you can easily update/insert/create/alter/drop more than once for a single "operation" of your app. In addition, it employs row–level locking in contrast to MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

Our company offers you a painless way to track the database use for your powerful web sites. Via the detailed database stats interface, that’s included in the Web Control Panel, you’re able to record the load accumulated through your dynamic sites in real time. The offered info will help you assess the database load fluctuations every hour, daily or on a monthly basis.

You’re able to keep an eye on the database load for your web sites in the Database Stats part of the Web Control Panel. The table onscreen shows the database queries created in the present month. To examine data for a previous month, simply click on the back arrows placed at the top.