Database Manager

Overseeing your databases is less complicated than in the past, because of the Hosting Control Panel interface for MySQL and PgSQL administration! Provided you do not have in depth knowledge in managing databases, you will find it effortless to deal with our Database Manager.

You could make a completely new database just by specifying the user name and password or produce a database backup with only a click of the mouse. Additionally, within the Data Manager you will get direct access to the management area for each individual database, so that you can effectively modify it.

Via the Database Manager it’s easy to create an archived duplicate of your database anytime you desire! For this reason, you are going to always have a backup of your dynamic content material in case your site gets broken into or if you incorrectly erase a database. To create a backup: click the ’clock’ symbol alongside a particular database and after that wait for a few seconds for the backup process to be concluded.

There won’t be any restrictions about the volume of databases you can back up or the volume of backups you may make for a database.

A lot of Rivera Hosting’s shared web hosting packages grant PgSQL support. Whilst falling behind MySQL with regards to acceptance and usage, PgSQL databases are famous for supplying the top level of stability for your website content material. This is the basic reason why companies like Skype and Yahoo rely on PgSQL databases as a substitute for MySQL.

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

With Rivera Hosting, you shall regularly discover the most current release of MySQL plus the default MySQL storage engine – InnoDB, installed.

InnoDB is a lot more reliable when compared to the former storage engine’s edition – MyISAM. It is ACID–compliant and, best of all – it gives you total transaction support. Additionally, it works by using row–level locking, as a substitute for MyISAM’s table–level locking, that previously used to lead to functionality troubles at peak usage periods.

Keeping tabs on the load produced by the databases within your busy site will let you avoid all sorts of overload issues that might slow it down and chase away website visitors. For this purpose, we have integrated a descriptive Database Stats tool into your Hosting Control Panel. There you shall find in depth information on the incoming requests to your databases for each and every hour, day and month.

Using the quantity of day–to–day and by the hour queries, it will be easy to find out which databases are employed the most and consider actions to optimize their work.