Databases Manager

The Databases Manager in the Website Control Panel provides a robust nevertheless straightforward user interface. You’re able to configure a brand new MySQL or PostgreSQL database by simply entering a username and password. Also, you can create a back–up file or modify the password of the database with only a click of the mouse.

Within the Databases Manager you will possess direct access to the administrator area for all your databases, in order to make simple adjustments in case you need to.

We have made the manual database backup formation into a very simple activity. To execute this: inside of the Databases Manager, click on the ’clock’ icon beside the database that you want to back up and wait around for a few seconds for the backup process to take place. With regards to the size of the database, the creation of the backup file will take somewhere between a couple of seconds and a minute.

You can create as many back–ups of a database as you would like. We have not set any limits for the volume of databases you can back up too.

Practically all of RCS-Tek Cloud Hosting’s shared hosting bundles grant PgSQL support. While dropping behind MySQL with respect to reputation and employment, PgSQL databases are famous for offering the top level of protection for your web site content and articles. That’s the primary reason why companies like Skype and Yahoo rely on PgSQL databases in lieu of MySQL.

With respect to database management, PgSQL is identically effortless to use as MySQL.

We’ve installed InnoDB – the new standard MySQL database engine on every one of our web servers. InnoDB is designed for substantial database websites that require high general performance and scalability. Tests demonstrate that sites employing InnoDB based tables achieve a 3–fold effectiveness boost for significant joins, compared with those applying MyISAM tables.

InnoDB works by using row–level locking so as to take away the functionality difficulties noticed at the top usage times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.

Tracking the load accumulated by the databases for your active website will let you avoid any sort of overload issues that could slow it down and ward off site visitors. For this specific purpose, we’ve designed a in depth Database Stats tool directly into the Website Control Panel. There you can find comprehensive information about the arriving requests to your databases for every hour, day and month.

Based on the amount of day–to–day and by the hour queries, it is possible to determine which databases are employed the most and take actions to enhance their work.