Databases Manager

Taking control of your databases is much easier than ever, as a result of Web Site Control Panel interface for MySQL and PgSQL administration! Even though you may not have in depth experience of handling databases, you will find it an easy task to deal with the Databases Manager.

You can make a completely new database merely by keying in the username and password or make a database back–up with just a click of the mouse. Furthermore, with the Data Manager you’ll possess direct access to the admin area for each database, meaning you can easily revise it.

With the Databases Manager it’s easy to produce an archived backup of your database anytime you wish! This way, you are going to always have a backup of your active content in the event your web site gets broken into or if you mistakenly erase a database. To generate a back–up: click on the ’clock’ image next to a certain database and then wait for a few seconds for the backup process to be finalized.

There aren’t any restrictions for the amount of databases you would be able to back up or the amount of back–ups you may make for a database.

PgSQL databases are significantly less popular than the prevalent MySQL databases. Nevertheless, they’re a preferred alternative for developers who are looking for the best stability for their websites and applications. Because of the incredibly user–friendly Databases Manager included in the s2f hosting Control Panel, you can control your PostgreSQL databases with a mouse click.

You are going to find PgSQL databases integrated automatically inside of the advanced Linux web hosting packages. In case you are using a standard hosting package, you’ll be able to request PgSQL databases to be added in your website hosting account as upgrades.

We have integrated InnoDB – the new default MySQL database engine on each of our machines. InnoDB is designed for huge database web sites that require high general performance and scalability. Experiments demonstrate that sites applying InnoDB based tables reach a 3–fold general performance boost for big joins, as compared to those working with MyISAM tables.

InnoDB makes use of row–level locking so as to eliminate functionality issues discovered at the peak consumption times of the previous variant of the database engine – MyISAM, which uses table–level locking.

Tracking the load accumulated by the databases for your dynamic web site assists you to prevent all overload difficulties that can slow it down and chase away visitors. Therefore, we have bundled a comprehensive Database Stats tool in the Web Site Control Panel. There you can see in–depth info on the inbound requests to your databases for every hour, day and month.

Depending on the number of daily and by the hour queries, it’s possible to find out which databases are used the most and then take actions to enhance their load.