Databases Manager

The Databases Manager in the Hosting Control Panel incorporates an effective but convenient–to–use user interface. You can easily set up a brand new MySQL or PostgreSQL database by just typing a user name and password. What’s more, you can create a back–up file or alter the security password of the database with just a click of the mouse.

From the Databases Manager you will get direct access to the management area for all your databases, so that you can make quick corrections in case you have to.

We’ve transformed the manual database backup generation into a very easy task. To do so: inside the Databases Manager, click the ’clock’ image near the database that you want to back up and after that wait around for a couple of seconds for the backup process to take place. With respect to the size of the database, the creation of a back–up file will need somewhere between a couple of seconds and a minute.

You can make as many backup copies of a database as you want. We’ve not determined any limitations on the quantity of databases you can back up either.

Just about all of the Linux cloud hosting packages packages grant PgSQL support. While falling behind MySQL when considering popularity and utilization, PgSQL databases are renowned for offering up the top level of safety for your web site content material. It is the main reason why brands like Skype and Yahoo employ PgSQL databases as opposed to MySQL.

With regards to database administration, PgSQL is just as uncomplicated as MySQL.

With REN Hosting, you’ll regularly find the most up–to–date variant of MySQL plus the default MySQL storage engine – InnoDB, set up.

InnoDB is definitely more secure compared to the previous storage engine’s edition – MyISAM. It’s ACID–compliant and, most significantly – it has total transaction support. In addition, it works by using row–level locking, as an alternative for MyISAM’s table–level locking, that used to result in functionality issues at peak usage times.

From the comprehensive database stats tool incorporated into the Hosting Control Panel, you are able to keep a record of the stress accumulated from your active web sites round the clock. Virtually any overload problem with your websites can reduce the loading rates and have a bad influence over the overall experience of your website visitors. Therefore, by having information about the database work instantly, it’s possible to resolve overload problems quickly.

The database stats interface displays info of the number of daily, hourly and monthly queries, meaning you can evaluate the way the load is spread over several time frames.