Databases Manager

Database management may sound like a difficult job to novice cloud hosting customers, but with Yellowknife Hosting’s Databases Manager, it’s in fact pretty simple! To make a completely new database, you only need to key in the username and password. Database backup copies are a mouse click away at the same time.People who need to explore their databases and also alter them are able to use the phpMyAdmin and phpPgAdmin tools.

We have transformed the manual database back–up generation into a very simple task. To do this: in the Databases Manager, click on the ’clock’ symbol near the database that you intend to back up and after that wait around for a couple of seconds for the process to take place. With regards to the size of your database, the building of the backup file can take between a couple of seconds and a minute.

You may create as many copies per database as you want. We’ve not determined any limitations for the amount of databases that you can back up as well.

You’re going to find PgSQL support in all of our Linux website hosting packages. PgSQL databases aren’t as well–known and widespread as MySQL, nonetheless they provide the best level of security for your site content. For this reason, a lot of widely known companies like Skype and Yahoo use PgSQL databases. Taking care of PgSQL databases is as easy and simple as MySQL, because of the intuitive interface of the Databases Manager.

PgSQL databases are included by default in the most innovative web hosting packages. For the regular bundles, they’re included as upgrades.

We’ve integrated InnoDB – the new default MySQL database engine on each of our servers. InnoDB is ideal for large database web sites that demand high levels of effectiveness and scalability. Trials show that web sites utilizing InnoDB based tables achieve a 3–fold efficiency increase for huge joins, as opposed to those utilizing MyISAM tables.

InnoDB uses row–level locking as a way to get rid of the operation problems seen at the peak usage times of the previous release of the database engine – MyISAM, which employs table–level locking.

We supply you a surprisingly simple solution to keep an eye on the database use of your busy web sites. From your descriptive database statistics user interface, that’s included in the Control Panel, you are able to keep track of the load accumulated through your dynamic sites in real time. The provided information will assist you to evaluate the database load changes per hour, every day or on a monthly basis.

You’ll be able to monitor the database load for your sites from the Database Stats part of the Control Panel. The table on–screen shows the database lookups created in the present month. To have a look at details for an earlier month, simply click on the back arrows positioned at the top.