Database Manager

The Database Manager inside our Web Site Control Panel boasts a robust yet user–friendly and uncomplicated interface. It’s possible to configure a completely new MySQL or PostgreSQL database by just typing a user name and password. Moreover, you can create a backup file or alter the password of a database with just a click of the mouse.

Through the Database Manager you will possess direct access to the administration area for all of your databases, so you can make simple changes if you happen to have to.

In case you have dealt with databases, you know generating a manual database backup just isn’t an elementary job. In an effort to change this, we’ve developed an easy to understand tool that will back up your whole database with only one mouse click. The backup file will be completely ready for you in less than a minute, depending on the size of the chosen database.

You won’t notice any limitations on the actual number of copies you could make for a particular database.

Just about all of our Linux website hosting packages deliver PgSQL support. While falling behind MySQL with respect to reputation and application, PgSQL databases are renowned for providing the best level of stability for your site content material. That’s the main reason why companies like Skype and Yahoo rely upon PgSQL databases and not MySQL.

With regards to database administration, PgSQL is equally uncomplicated as MySQL.

With Critchfield Web Hosting Services, you shall always find the latest version of MySQL and the default MySQL storage engine – InnoDB, set up.

InnoDB is much more dependable than the previous storage engine’s edition – MyISAM. It is ACID–compliant and, best of all – it includes complete transaction support. Furthermore, it takes advantage of row–level locking, as opposed to MyISAM’s table–level locking, that seemed to lead to functionality problems at peak usage periods.

Tracking the load produced by the databases for your active website will let you reduce any sort of overload problems that could slow it down and ward off website visitors. Therefore, we’ve integrated a descriptive Database Stats tool within the Web Site Control Panel. There you can find thorough information about the inbound requests to your databases for each and every hour, day and month.

Depending on the amount of day–to–day and hourly queries, it will be easy to determine which databases are utilized the most and also take steps to optimize their load.