Databases Manager

Database management may seem like a difficult job to newbie website hosting customers, but with CrownHost’s Databases Manager, it’s in fact relatively easy! To configure a completely new database, you simply need to provide your username and password. Database back–ups are a click away on top of that.People who choose to examine their databases and modify them can use the phpMyAdmin and phpPgAdmin tools.

Via the Databases Manager it is simple to make an archived copy of your database whenever you would like! This way, you will always have a data backup of your dynamic content in case your web site gets broken into or if you erroneously delete a database. To produce a backup: click on the ’clock’ image beside a certain database and after that simply wait for a couple of seconds for the process to be performed.

There aren’t any restrictions for the volume of databases you are able to back up or the volume of backups you may make for any database.

PgSQL databases are much less sought after as opposed to the standard MySQL databases. Even so, they represent a favored choice for programmers who seek the best stability for their web sites and web apps. Because of the user–friendly Databases Manager incorporated into the CrownHost Control Panel, you can administer all your PostgreSQL databases with simply a mouse click.

You will find PgSQL databases integrated by default in the advanced Linux web hosting service packages. If you are with a basic hosting package, it’s possible to ask for PgSQL databases to be added to your cloud hosting account as upgrades.

With CrownHost, you will inevitably find the most up–to–date variant of MySQL along with the default MySQL storage engine – InnoDB, set up.

InnoDB is far more dependable when compared to the past storage engine’s version – MyISAM. It’s ACID–compliant and, best of all – it provides complete transaction support. What’s more, it uses row–level locking, as an alternative for MyISAM’s table–level locking, that used to lead to effectiveness troubles at high usage occasions.

Keeping tabs on the load produced by the databases in your dynamic site will let you reduce all sorts of overload difficulties that can slow it down and ward off site visitors. As a result, we’ve designed a complete Database Stats tool directly into the Website Control Panel. There you will find extensive info about the incoming requests to your databases for each hour, day and month.

Depending on the amount of day–to–day and hourly queries, it is possible to find out which databases are being used the most as well as consider actions to enhance their load.