Database Manager

Taking control of your databases now is easier than ever, thanks to the Site Control Panel user interface for MySQL and PgSQL management! Even if you do not have considerable expertise in utilizing databases, you will find it effortless to use our Database Manager.

You can create a completely new database by merely specifying the username and security password or make a database back–up with merely a click of the mouse. Moreover, from the Data Manager you’ll get direct access to the administration area for each and every database, which means you can almost instantly manage it.

We have changed the manual database back–up generation into a simple task. To do so: within the Database Manager, click on the ’clock’ icon on the side of the database that you would like to back up and wait for a few seconds for the backup process to take place. Depending upon the size of the database, the creation of the backup file will require between a couple of seconds and a minute.

You may create as many backup copies of a database as you wish. We have not fixed any boundaries about the quantity of databases that you could back up as well.

A lot of Renstay’s Linux shared hosting plans feature PgSQL support. While dropping behind MySQL when it comes to reputation and utilization, PgSQL databases are renowned for delivering the maximum level of protection for your site content and articles. This is the key reason why companies like Skype and Yahoo rely on PgSQL databases as an alternative to MySQL.

In relation to database management, PgSQL is identically uncomplicated as MySQL.

We have integrated InnoDB – the brand new default MySQL database engine on each of our machines. InnoDB is made for massive database websites which need high performance and scalability. Experiments have established that web sites making use of InnoDB based tables achieve a 3–fold effectiveness increase for massive joins, in comparison with those employing MyISAM tables.

InnoDB takes advantage of row–level locking so as to eliminate functionality issues seen at the peak consumption times of the earlier variant of the database engine – MyISAM, which uses table–level locking.

Keeping tabs on the load accumulated by the databases within your powerful site makes it possible to reduce virtually any overload troubles that can slow it down and chase away visitors. For this purpose, we have integrated a thorough Database Stats tool inside the Site Control Panel. There you can see detailed information on the incoming requests to your databases for every single hour, day and month.

Using the amount of daily and hourly queries, it will be easier to find out which databases are utilized the most as well as take steps to enhance their load.