Databases Manager

The Databases Manager inside the Site Control Panel boasts an effective nevertheless convenient–to–use interface. You’re able to set up a new MySQL or PostgreSQL database by simply specifying a user name and security password. In addition, you can make a back–up file or modify the security password of any database with only a click of the mouse.

From the Databases Manager you’ve got immediate access to the administrator area for every one of your databases, so that you can make simple adjustments in case you need to.

Through the Databases Manager you’ll be able to generate an archived backup of your database anytime you want! For this reason, you will always have a backup of your operating information if your site gets compromised or you mistakenly erase a database. To make a back–up: click on the ’clock’ symbol next to any database and afterwards simply wait for a few seconds for the backup process to be executed.

There are no limitations on the quantity of databases you would be able to back up or the number of back–ups you may make for any database.

PgSQL databases are much less sought after as compared to the popular MySQL databases. Having said that, they are a favorite selection for designers who are looking for the maximum security for their web sites and web apps. Through the easy–to–use Databases Manager built–into the AdvancedWebHost.com Control Panel, you can manage your PostgreSQL databases with merely a click of the mouse.

Yow will discover PgSQL databases included automatically with the top shared website hosting services packages. Assuming that you are using a basic hosting package, you’re able to ask for PgSQL databases to be added to your hosting account as upgrades.

The MySQL databases on our machines employ the latest release of the InnoDB storage engine. InnoDB was made to ensure the highest possible functionality for web sites that deal with large amounts of data. It features CPU efficiency that could not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, meaning that you’ll be able to update/insert/create/alter/drop several times for one "operation" of your web app. Moreover, it uses row–level locking instead of MyISAM’s table–level locking, that boosts multi–user concurrency and performance.

Through the in–depth database stats tool included in the Site Control Panel, you are able to keep track of the stress created through your busy web sites twenty–four hours a day. Every single overload trouble with your sites can slow the loading speeds and have a damaging impact on the overall experience of your respective website visitors. Thus, having information about the database load right away, you are able to resolve overload troubles quickly.

The database stats interface reveals information of the amount of daily, hourly and monthly queries, so you’re able to evaluate the way the load is allocated over various time periods.