Database Manager

Administering your databases is less complicated than in the past, as a result of Web Hosting Control Panel user interface for MySQL and PgSQL control! In case you do not have thorough knowledge of working with databases, you will find it easy to use the Database Manager.

You can make a brand new database merely by specifying the username and password or create a database backup with merely a click of the mouse. Moreover, via the Data Manager you’ll possess direct access to the administrator area for each database, so you can easily revise it.

Via the Database Manager you are able to produce an archived duplicate of your database when you need! This way, you’ll always have a back–up of your dynamic content material in case your site gets hacked or if you accidentally remove a database. To generate a back–up: click the ’clock’ symbol next to any database and after that just wait for a few seconds for the process to be concluded.

There are not any limits for the amount of databases you can back up or the amount of backups you can create for a database.

PgSQL databases are significantly less sought after when compared to the popular MySQL databases. However, they are a favorite choice for developers who seek the ultimate safety for their web sites and web applications. Through the intuitive Database Manager included in the LivingstoneIT Hosting Control Panel, you can control all your PostgreSQL databases with only a click of the mouse.

Yow will discover PgSQL databases incorporated automatically inside of the advanced Linux shared hosting packages. Provided that you are using a basic hosting package, you’ll be able to request PgSQL databases to be added to your account as upgrades.

The MySQL databases on our machines use the most recent release of the InnoDB storage engine. InnoDB has been designed to ensure the optimum functionality for web sites that work with large amounts of data. It features CPU efficiency that could not be matched by any other disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, meaning it is possible to update/insert/create/alter/drop repeatedly for one "operation" of your web application. Additionally, it utilizes row–level locking rather than MyISAM’s table–level locking, that enhances multi–user concurrency and performance.

Checking the load accumulated by the databases in your dynamic web site makes it possible to prevent any overload issues that might slow it down and ward off visitors. For this specific purpose, we’ve provided a descriptive Database Stats tool within the Web Hosting Control Panel. There you can get all–inclusive info on the arriving requests to your databases for every hour, day and month.

In line with the number of daily and by the hour queries, it’s possible to determine which databases are employed the most and then take steps to optimize their work.