Database Manager

The Database Manager inside the Website Control Panel comes with an effective yet user–friendly and uncomplicated interface. You are able to configure a brand new MySQL or PostgreSQL database by simply typing a username and password. What’s more, you could make a backup file or change the password of the database with a click of the mouse.

Via the Database Manager you’ll get direct access to the administration area for all of your databases, allowing you to make quick alterations if you happen to need to.

With the Database Manager you can create an archived backup of your database whenever you need! Therefore, you will always have a backup of your operating information in case your web site gets compromised or you incorrectly delete a database. To produce a back–up: click on the ’clock’ image alongside any database and after that simply wait for a couple of seconds for the process to be done.

There are no limitations for the quantity of databases you can back up or the number of backup copies you can create for a database.

A lot of the cloud hosting packages offer PgSQL support. While dropping behind MySQL with regards to level of popularity and usage, PgSQL databases are renowned for supplying the greatest level of security for your web site content material. That’s the reason why brands like Skype and Yahoo rely on PgSQL databases in lieu of MySQL.

With regard to database management, PgSQL is just as effortless to use as MySQL.

The MySQL databases on Web Hosting For Life’s web servers employ the newest version of the InnoDB storage engine. InnoDB was built to guarantee the top efficiency for sites that deal with substantial volumes of data. It grants CPU performance that could not be equalled by other disk–based relational database engines.

InnoDB is ACID–compliant and provides complete transaction support, which means that you can easily update/insert/create/alter/drop more than once for a single "operation" of your application. In addition, it uses row–level locking rather than MyISAM’s table–level locking, that enhances multi–user concurrency and performance.

Keeping track of the load generated by the databases in your powerful web site will help you avoid all overload difficulties that could slow it down and chase away visitors. Therefore, we’ve built–in a in depth Database Stats tool within the Website Control Panel. There you shall find in depth information regarding the inbound requests to your databases for each hour, day and month.

Based on the number of day–to–day and hourly queries, it will be straightforward to find out which databases are used the most and take steps to optimize their load.