Databases Manager

The Databases Manager in the Web Site Control Panel incorporates an effective but intuitive interface. It’s possible to configure a completely new MySQL or PostgreSQL database by just entering a user name and security password. Furthermore, you can create a back–up file or customize the security password of your database with a mouse click.

Within the Databases Manager you’ll possess direct access to the administrator area for all of your databases, which enables you to make hassle–free corrections when you have to.

Within the Databases Manager it is simple to produce an archived copy of your database when you need! Therefore, you’ll always have a data backup of your dynamic content material if your website gets hacked or you erroneously get rid of a database. To generate a backup: click the ’clock’ symbol next to a particular database and then just wait for a couple of seconds for the backup process to be done.

There aren’t any restricts for the quantity of databases you can back up or the quantity of backup copies you can create for any database.

Most of the Linux shared packages bundles grant PgSQL support. Whilst dropping behind MySQL with respect to popularity and utilization, PgSQL databases are famous for offering the greatest level of safety for your site content material. That’s the reason why businesses like Skype and Yahoo make use of PgSQL databases as an alternative to MySQL.

When it comes to database management, PgSQL is identically straightforward as MySQL.

We’ve set up InnoDB – the brand new standard MySQL database engine on all of our servers. InnoDB is made for significant database websites which need high performance and scalability. Trials have shown that sites using InnoDB based tables achieve a 3–fold operation boost for large joins, in comparison to those making use of MyISAM tables.

InnoDB uses row–level locking in order to be able to eliminate performance issues discovered at the high usage times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.

Checking the load made by the databases in your powerful web site makes it possible to reduce all overload problems that could slow it down and chase away website visitors. For this purpose, we have designed a in depth Database Stats tool within the Web Site Control Panel. There you can find comprehensive information about the arriving requests to your databases for each and every hour, day and month.

Based on the number of daily and hourly queries, it will be easier to find out which databases are being used the most as well as take procedures to enhance their load.