Database Manager

The Database Manager within our Web Site Control Panel incorporates a powerful but user–friendly user interface. You’ll be able to set up a completely new MySQL or PostgreSQL database by just specifying a username and password. Additionally, you may create a backup file or change the password of an database with a click of the mouse.

Within the Database Manager you have direct access to the administration area for every one of your databases, so you’re able to make hassle–free corrections should you have to.

Provided you have dealt with databases, you know generating a manual database backup is not a basic job. As a way to change this, we have made very simple tool that will back up your whole database with just one click. The backup file is going to be set for you in under a minute, with respect to the size of the selected database.

There won’t be any restrictions on the total number of copies you can create for any chosen database.

Practically all of our Linux website hosting plans feature PgSQL support. Whilst dropping behind MySQL with regard to level of popularity and usage, PgSQL databases are famous for offering the maximum level of safety for your website content. That’s the reason why companies like Skype and Yahoo employ PgSQL databases instead of MySQL.

With regard to database management, PgSQL is just as easy to use as MySQL.

The MySQL databases on webflask’s machines use the most recent release of the InnoDB storage engine. InnoDB has been meant to guarantee the highest possible performance for sites that operate with huge amounts of data. It grants CPU efficiency that could not be matched by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, meaning that you can update/insert/create/alter/drop repeatedly for one "operation" of your web app. In addition, it utilizes row–level locking in lieu of MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

Monitoring the load accumulated by the databases in your active web site will help you reduce any kind of overload troubles that might slow it down and ward off site visitors. For this reason, we’ve provided a complete Database Stats tool inside the Web Site Control Panel. There you shall find thorough information about the inbound requests to your databases for every hour, day and month.

Based on the amount of day–to–day and per hour queries, it will be easy to determine which databases are used the most and also take actions to optimize their work.