Database Manager

Supervising your databases is much easier than ever before, due to the Website Control Panel user interface for MySQL and PgSQL administration! Assuming you do not have substantial experience in handling databases, you will find it effortless to work with Sylvan Servers’s Database Manager.

You may create a whole new database just by keying in the username and password or make a database back–up with only a click of the mouse. Likewise, through the Data Manager you will have direct access to the management area for each individual database, which means you can immediately alter it.

Within the Database Manager you are able to generate an archived copy of your database when you need! Therefore, you are going to always have a backup of your operating information if your site gets broken into or if you incorrectly delete a database. To generate a backup: click on the ’clock’ symbol on the side of a certain database and afterwards simply wait for a couple of seconds for the backup process to be done.

There aren’t any restricts on the number of databases you can back up or the volume of backups you may make for any database.

PgSQL databases are much less popular in comparison to the popular MySQL databases. Then again, they’re a favorite choice for web developers who are looking for the best security for their sites and applications. Because of the user–friendly Database Manager built–into the Sylvan Servers Control Panel, you can control all your PostgreSQL databases with merely a mouse click.

You are going to find PgSQL databases integrated by default inside the advanced shared hosting service packages. In case you are using a regular hosting package, you’re able to ask for PgSQL databases to be included in your website hosting account as upgrades.

With Sylvan Servers, you shall regularly find the most up–to–date build of MySQL as well as the default MySQL storage engine – InnoDB, set up.

InnoDB is more dependable in comparison to the old storage engine’s version – MyISAM. It’s ACID–compliant and, most significantly – it provides complete transaction support. Additionally, it employs row–level locking, in contrast to MyISAM’s table–level locking, that used to lead to efficiency troubles at high usage times.

Checking the load generated by the databases for your dynamic web site will let you prevent any overload troubles that might slow it down and chase away website visitors. For this reason, we’ve incorporated a detailed Database Stats tool in the Website Control Panel. There you can find all–encompassing information on the incoming requests to your databases for every single hour, day and month.

In line with the volume of day–to–day and per hour queries, you’re going to be able to find out which databases are employed the most and consider steps to enhance their work.