Database Manager

The Database Manager inside the Web Site Control Panel has a powerful but still uncomplicated user interface. You can easily configure a completely new MySQL or PostgreSQL database by just typing in a user name and security password. Also, you can create a backup file or change the password of any database with just a click of the mouse.

With the Database Manager you’ll possess direct access to the administrative area for all your databases, so you can make effortless changes in case you need to.

If you have dealt with databases, you already know that making a manual database back–up just isn’t a basic task. So as to change this, we have created an easy to understand tool that can back up your complete database with simply one click. The data backup file is going to be set for you in less than a minute, with regards to the size of the chosen database.

You won’t notice any limits on how many backup copies you can make for any selected database.

You are going to find PgSQL support in every one of our shared hosting plans plans. PgSQL databases aren’t as popular and commonly used as MySQL, but they provide the greatest level of stability for your web site content. For this reason, a lot of popular companies like Skype and Yahoo make use of PgSQL databases. Dealing with PgSQL databases is as elementary as MySQL, on account of the easy–to–use interface of the Database Manager.

PgSQL databases are included automatically within the most sophisticated web hosting plans. For the standard packages, they’re included as upgrades.

With Host1n1, you will consistently discover the most up–to–date build of MySQL plus the default MySQL storage engine – InnoDB, set up.

InnoDB is more reliable than the former storage engine’s version – MyISAM. It is ACID–compliant and, even more importantly – it gives full transaction support. You’ll find, it makes use of row–level locking, instead of MyISAM’s table–level locking, that previously used to trigger effectiveness problems at peak usage times.

Monitoring the load produced by the databases in your busy site assists you to prevent any sort of overload troubles that can slow it down and ward off website visitors. For this purpose, we have bundled a comprehensive Database Stats tool straight into the Web Site Control Panel. There you shall find extensive information about the inbound requests to your databases for each and every hour, day and month.

In line with the volume of daily and by the hour queries, you’ll be able to find out which databases are employed the most as well as take steps to enhance their work.