Database Manager

The Database Manager inside our Web Site Control Panel contains a powerful but still easy to navigate user interface. It is possible to configure a completely new MySQL or PostgreSQL database by just specifying a username and security password. Furthermore, you could make a backup file or change the password of an database with merely a click of the mouse.

From the Database Manager you’ll get direct access to the administrator area for every one of your databases, so you’re able to make uncomplicated modifications when you need to.

With the Database Manager you can easily produce an archived backup of your database whenever you would like! That way, you are going to always have a back–up of your operating content material in case your web site gets broken into or you erroneously get rid of a database. To generate a back–up: click on the ’clock’ image next to any database and then just wait for a few seconds for the backup process to be done.

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

You are going to find PgSQL support in all our Linux shared website hosting bundles. PgSQL databases may not be as sought after and commonly used as MySQL, nevertheless they supply the top level of protection for your site content and articles. Therefore, several famous businesses like Skype and Yahoo use PgSQL databases. Maintaining PgSQL databases is as simple and easy as MySQL, thanks to the incredibly user–friendly interface of the Database Manager.

PgSQL databases are bundled automatically inside of the most advanced web hosting bundles. For the normal bundles, they’re offered as upgrades.

The MySQL databases on DomainsWALLA’s web servers use the most recent build of the InnoDB storage engine. InnoDB has been designed to guarantee the highest possible performance for websites that deal with large amounts of data. It supplies CPU efficiency that can not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants full transaction support, meaning you are able to update/insert/create/alter/drop a couple of times for a single "operation" of your web application. In addition, it works by using row–level locking as an alternative to MyISAM’s table–level locking, that raises multi–user concurrency and performance.

Keeping track of the load produced by the databases within your active web site makes it possible to reduce all kinds of overload difficulties that could slow it down and ward off site visitors. For this purpose, we’ve built–in a thorough Database Stats tool into the Web Site Control Panel. There you shall find broad info 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 are going to be able to determine which databases are being used the most as well as consider procedures to optimize their work.