Database Manager

The Database Manager inside the Web Hosting Control Panel has a refined yet uncomplicated user interface. You can configure a completely new MySQL or PostgreSQL database simply by typing a username and password. Also, you may create a backup file or modify the password of the database with merely a click of the mouse.

Through the Database Manager you’ll possess direct access to the admin area for every one of your databases, so you can make uncomplicated modifications when you have to.

From the Database Manager you’re able to make an archived copy of your database anytime you desire! That way, you are going to always have a backup of your dynamic information in the event your website gets compromised or if you mistakenly eliminate a database. To produce a back–up: click on the ’clock’ image alongside a certain database and afterwards wait for a few seconds for the backup process to be finalized.

There won’t be any boundaries about the number of databases you can back up or the amount of back–ups you can create for a database.

Most of the Linux website hosting service packages provide PgSQL support. Whilst dropping behind MySQL when considering reputation and employment, PgSQL databases are renowned for giving the best level of security for your web site content. That is the basic reason why brands like Skype and Yahoo employ PgSQL databases in lieu of MySQL.

In terms of database administration, PgSQL is just as straightforward as MySQL.

With eGeekMD, you shall regularly find the latest edition of MySQL and the default MySQL storage engine – InnoDB, installed.

InnoDB is much more dependable than the old storage engine’s version – MyISAM. It is ACID–compliant and, above all – it provides complete transaction support. In addition, it employs row–level locking, in contrast to MyISAM’s table–level locking, that used to lead to performance issues at high usage times.

Keeping track of the load generated by the databases in your active web site makes it possible to prevent any overload issues that could slow it down and ward off site visitors. For this reason, we have incorporated a in depth Database Stats tool inside the Web Hosting Control Panel. There you can find extensive information regarding the incoming requests to your databases for every hour, day and month.

In line with the volume of daily and by the hour queries, it will be easy to find out what databases are employed the most as well as consider steps to enhance their load.