Databases Manager

Supervising your databases is much simpler than ever, on account of the Web Control Panel user interface for MySQL and PgSQL management! Even if you do not have detailed experience in managing databases, it will be simple to deal with Site Merchants’s Databases Manager.

You can make a completely new database by simply specifying the username and security password or generate a database back–up with only a click of the mouse. Moreover, from the Data Manager you will possess direct access to the admin area for each and every database, so its possible to efficiently revise it.

Provided you have dealt with databases, you are aware that making a manual database back–up is just not an elementary task. In order to change this, we have created a simple and easy to use tool that can back up your whole database with one click. The backup file will be all set for you in under a minute, depending upon the size of the chosen database.

There are no restrictions on the amount of backups you can make for any chosen database.

You can find PgSQL support in all our shared web hosting plans packages. PgSQL databases aren’t as sought after and widespread as MySQL, however they give the maximum level of security for your website content. Therefore, a number of widely known businesses like Skype and Yahoo employ PgSQL databases. Handling PgSQL databases is as simple as MySQL, thanks to the user–friendly interface of the Databases Manager.

PgSQL databases are incorporated automatically with the most advanced web hosting packages. For the normal bundles, they are presented as upgrades.

We’ve installed InnoDB – the new default MySQL database engine on our machines. InnoDB is great for massive database sites that demand high levels of overall performance and scalability. Tests have shown that web sites making use of InnoDB based tables attain a 3–fold overall performance boost for substantial joins, compared with those working with MyISAM tables.

InnoDB utilizes row–level locking in order to be able to get rid of the functionality issues spotted at the peak consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

Site Merchants offers you a hassle–free option to observe the database usage for your active websites. Via the descriptive database statistics user interface, that is incorporated into the Web Control Panel, you’ll be able to keep track of the load accumulated by your active websites in real time. The presented info will let you analyze the database load variations per hour, each day or per month.

You are able to observe the database load for your web sites within the Database Stats portion of the Web Control Panel. The table on–screen shows the database queries accumulated in the present month. To look at data for a previous month, click on the back arrows placed at the top.