Databases Manager

The Databases Manager inside our Site Control Panel includes a robust but convenient–to–use user interface. It is possible to set up a brand new MySQL or PostgreSQL database by just specifying a user name and security password. Additionally, you can create a back–up file or modify the password of the database with merely a mouse click.

From the Databases Manager you’ve got immediate access to the administrative area for all of your databases, so that you can make effortless modifications in the event you need to.

Via the Databases Manager you are able to produce an archived duplicate of your database anytime you need! This way, you’ll always have a backup of your operating information in case your site gets compromised or you erroneously eliminate a database. To generate a backup: click on the ’clock’ icon alongside a certain database and afterwards just wait for a few seconds for the backup process to be finished.

There won’t be any boundaries about the amount of databases you would be able to back up or the volume of backups you can make for a database.

The majority of our shared web hosting plans feature PgSQL support. Although falling behind MySQL in terms of global recognition and utilization, PgSQL databases are renowned for supplying the maximum level of safety for your site content and articles. That’s the key reason why brands like Skype and Yahoo employ PgSQL databases in lieu of MySQL.

In terms of database management, PgSQL is identically easy to understand as MySQL.

With Linton Hosting, you shall inevitably discover the most up–to–date edition of MySQL along with the default MySQL storage engine – InnoDB, set up.

InnoDB is far more secure compared to the previous storage engine’s version – MyISAM. It’s ACID–compliant and, most of all – it has total transaction support. Additionally, it works by using row–level locking, as an alternative for MyISAM’s table–level locking, that used to result in functionality issues at high usage times.

Tracking the load accumulated by the databases within your powerful web site will let you prevent any overload problems that could slow it down and chase away site visitors. For this reason, we’ve bundled a descriptive Database Stats tool in the Site Control Panel. There you shall find in depth info on the inbound requests to your databases for each hour, day and month.

Depending on the amount of daily and per hour queries, you’ll be able to determine which databases are being used the most and also take actions to enhance their work.