Databases Manager

The Databases Manager inside our Web Site Control Panel comes with a powerful but intuitive user interface. You’re able to set up a new MySQL or PostgreSQL database simply by specifying a user name and password. Also, you may create a backup file or modify the password of the database with just a mouse click.

Through the Databases Manager you’ll possess direct access to the administration area for all your databases, in order to make convenient adjustments should you have to.

Via the Databases Manager it’s easy to produce an archived duplicate of your database whenever you need! That way, you will always have a back–up of your operating information if your website gets broken into or if you erroneously get rid of a database. To generate a back–up: click the ’clock’ symbol beside a certain database and after that just wait for a couple of seconds for the process to be finalized.

There are not any boundaries about the volume of databases you are able to back up or the quantity of backup copies you can make for a database.

You can find PgSQL support in each of our cloud web hosting packages. PgSQL databases are not as sought after and frequently used as MySQL, but they provide the top level of safety for your website content and articles. Therefore, several well–known companies such as Skype and Yahoo apply PgSQL databases. Controlling PgSQL databases is as simple and easy as MySQL, due to the intuitive interface of the Databases Manager.

PgSQL databases are integrated automatically in the most innovative web hosting plans. For the basic packages, they are included as upgrades.

With CharlestonHost.com, you will invariably discover the most current edition of MySQL plus the default MySQL storage engine – InnoDB, mounted.

InnoDB is more stable compared to the old storage engine’s version – MyISAM. It’s ACID–compliant and, most importantly – it gives you total transaction support. It also utilizes row–level locking, as opposed to MyISAM’s table–level locking, that used to lead to performance problems at high usage periods.

Tracking the load caused by the databases for your active web site will let you reduce any kind of overload issues that could slow it down and chase away website visitors. For this purpose, we’ve included a detailed Database Stats tool into your Web Site Control Panel. There you shall find extensive info on the arriving requests to your databases for every single hour, day and month.

In line with the quantity of daily and hourly queries, it will be easier to find out what databases are being used the most and also take steps to enhance their load.