Databases Manager

The Databases Manager in the Web Control Panel boasts a refined nevertheless convenient user interface. It’s possible to set up a new MySQL or PostgreSQL database by just typing a user name and password. What’s more, you may create a back–up file or modify the password of an database with just a mouse click.

Through the Databases Manager you have direct access to the administration area for all of your databases, so you can make convenient adjustments should you have to.

We’ve changed the manual database back–up formation into a quite simple job. To do so: inside the Databases Manager, click on the ’clock’ image beside the database that you intend to back up and afterwards hang on for a couple of seconds for the backup process to take place. Depending upon the size of your database, the generation of the backup file is going to take somewhere between a few seconds and a minute.

You may create as many backup copies of a database as you wish. We haven’t specified any boundaries about the amount of databases you can back up as well.

You’ll find PgSQL support in each of our cloud hosting plans. PgSQL databases aren’t as sought after and commonly used as MySQL, but they deliver the highest possible level of safety for your website content. Due to this, many famous companies like Skype and Yahoo take advantage of PgSQL databases. Controlling PgSQL databases is as simple and easy as MySQL, due to the incredibly user–friendly user interface of the Databases Manager.

PgSQL databases are incorporated by default in the most sophisticated web hosting plans. For the regular packages, they’re offered as upgrades.

The MySQL databases on our servers utilize the most current release of the InnoDB storage engine. InnoDB is created to ensure the highest functionality for websites that operate with substantial volumes of data. It offers CPU effectiveness that can not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and provides full transaction support, meaning that it’s possible to update/insert/create/alter/drop more than once for a single "operation" of your web app. Also, it works by using row–level locking and not MyISAM’s table–level locking, that boosts multi–user concurrency and functionality.

Monitoring the load produced by the databases in your powerful site will help you prevent virtually any overload issues that could slow it down and chase away visitors. For this specific purpose, we have bundled a comprehensive Database Stats tool into your Web Control Panel. There you can get detailed info about the inbound requests to your databases for every hour, day and month.

Based on the quantity of day–to–day and hourly queries, you’re going to be able to find out what databases are utilized the most and then consider actions to enhance their work.