Database Manager

Taking control of your databases is much easier than ever before, on account of the Web Hosting Control Panel interface for MySQL and PgSQL control! Assuming you do not have substantial knowledge in dealing with databases, it will be effortless to handle HR STORE’s Database Manager.

You could make a completely new database just by entering the username and password or create a database back–up with simply a click of the mouse. Likewise, from the Data Manager you will possess direct access to the administrative area for each individual database, which enables you to easily modify it.

We’ve developed the manual database backup creation into a quite easy activity. To do so: inside of the Database Manager, click on the ’clock’ icon on the side of the database that you plan to back up and after that hang on for a couple of seconds for the backup process to take place. With respect to the size of your database, the creation of any backup file will take somewhere between a few seconds and a minute.

You can make as many backups per database as you wish. We’ve not set any boundaries for the volume of databases that you could back up either.

Just about all of HR STORE’s shared website hosting plans provide PgSQL support. Whilst dropping behind MySQL when considering popularity and employment, PgSQL databases are renowned for offering the maximum level of stability for your website content and articles. It is the reason why businesses like Skype and Yahoo rely on PgSQL databases as opposed to MySQL.

With regards to database administration, PgSQL is identically effortless to use as MySQL.

With HR STORE, you’ll inevitably discover the most recent edition of MySQL and the default MySQL storage engine – InnoDB, set up.

InnoDB is a lot more secure when compared to the old storage engine’s edition – MyISAM. It’s ACID–compliant and, most importantly – it offers total transaction support. Furthermore, it makes use of row–level locking, as a substitute for MyISAM’s table–level locking, that seemed to lead to performance problems at high usage occasions.

We provide you a surprisingly simple route to keep track of the database use for your busy web sites. From your in depth database stats interface, that’s included in the Web Hosting Control Panel, you’re able to observe the load made by your busy websites in real time. The presented data will help you analyze the database load changes by the hour, daily or each month.

You’ll be able to observe the database load for your web sites from the Database Stats section of the Web Hosting Control Panel. The table onscreen presents the database lookups accumulated during the present month. To examine information and facts for a past month, click on the back arrows situated at the top.