Database Manager

The Database Manager within our Website Control Panel provides a powerful nevertheless user–friendly and uncomplicated user interface. It is possible to set up a brand new MySQL or PostgreSQL database by simply specifying a username and security password. Also, you can make a back–up file or alter the password of any database with just a click of the mouse.

With the Database Manager you’ll have direct access to the administrative area for every one of your databases, which means you can make simple alterations if you ever have to.

We’ve made the manual database back–up creation into a quite easy job. To do this: in the Database Manager, click on the ’clock’ symbol next to the database that you want to back up and after that wait for a few seconds for the process to take place. With regards to the size of the database, the creation of any backup file will require between a couple of seconds and a minute.

You may make as many backups per database as you desire. We’ve not specified any restrictions on the amount of databases you could back up too.

You’ll find PgSQL support in each of our Linux hosting bundles. PgSQL databases may not be as well–known and widespread as MySQL, nevertheless they provide the highest level of protection for your website content. For this reason, many famous brands like Skype and Yahoo take advantage of PgSQL databases. Dealing with PgSQL databases is as easy and simple as MySQL, as a result of the easy–to–use user interface of the Database Manager.

PgSQL databases are integrated by default inside the most innovative web hosting packages. For the normal plans, they are included as upgrades.

The MySQL databases on Web Sqaud Domain and Hosting Services’s servers work with the most recent release of the InnoDB storage engine. InnoDB has been built to guarantee the optimum performance for web sites that operate with substantial amounts of data. It provides CPU performance that could not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and supplies total transaction support, which means that it’s possible to update/insert/create/alter/drop several times for one "operation" of your web app. In addition, it takes advantage of row–level locking instead of MyISAM’s table–level locking, that boosts multi–user concurrency and functionality.

From your broad database stats tool built–into the Website Control Panel, you’ll be able to keep a record of the load produced from your busy web sites around the clock. Any overload trouble with your web sites could lower the loading speeds and have a negative impact on the overall impression of your visitors. Hence, by having data for the database load immediately, you are able to fix overload issues straight away.

The database stats interface displays info of the amount of daily, hourly and monthly queries, so its possible to review just how the load is distributed over different periods of time.