Databases Manager

Overseeing your databases is easier than before, due to the Web Control Panel user interface for MySQL and PgSQL management! Assuming you do not have considerable experience in making use of databases, you will find it an easy task to manage our Databases Manager.

You can make a completely new database by merely typing the username and security password or create a database back–up with a simple click of the mouse. In addition, from the Data Manager you’ll get direct access to the administrator area for every database, so you can effectively manage it.

Via the Databases Manager you’ll be able to make an archived backup of your database anytime you need! That way, you are going to always have a back–up of your operating content material if your website gets compromised or you mistakenly eliminate a database. To make a back–up: click the ’clock’ icon next to a particular database and then simply wait for a few seconds for the backup process to be executed.

There are not any restricts about the number of databases you can back up or the volume of back–ups you can create for a database.

A lot of the Linux cloud web hosting packages offer PgSQL support. Although dropping behind MySQL in terms of acceptance and utilization, PgSQL databases are renowned for presenting the highest level of safety for your web site content and articles. This is the basic reason why companies like Skype and Yahoo make use of PgSQL databases as a substitute for MySQL.

With respect to database management, PgSQL is equally simple and easy as MySQL.

The MySQL databases on Loftlin Solutions’s web servers use the most recent version of the InnoDB storage engine. InnoDB has been built to guarantee the highest performance for web sites that operate with massive volumes of data. It features CPU efficiency that could not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, which means you are able to update/insert/create/alter/drop several times for a single "operation" of your web app. Additionally, it makes use of row–level locking rather than MyISAM’s table–level locking, that boosts multi–user concurrency and efficiency.

Keeping track of the load caused by the databases on your powerful web site will let you prevent virtually any overload problems that can slow it down and chase away website visitors. For this purpose, we’ve included a descriptive Database Stats tool directly into the Web Control Panel. There you will find broad info on the arriving requests to your databases for each hour, day and month.

Based on the number of day–to–day and by the hour queries, it’s possible to find out which databases are utilized the most as well as consider procedures to enhance their load.